Uh oh!
There was an error while loading.Please reload this page.
- Notifications
You must be signed in to change notification settings - Fork8k
Open
Description
Gist to test the content of an Excel File in a controller (e2e) test, with a lib like supertest:
functionbinaryParser(res,callback){res.setEncoding('binary')res.data=''res.on('data',function(chunk){res.data+=chunk})res.on('end',function(){callback(null,newBuffer(res.data,'binary'))})}describe('exports/:id (GET)',()=>{it('should return an excel File',async()=>{constres=awaitrequest(app.getHttpServer()).get('/exports/xxx').expect('Content-Type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=utf-8').buffer().parse(binaryParser)assert.ok(Buffer.isBuffer(res.body))constworkbook=XLSX.read(res.body,{type:'buffer'})constsheet=workbook.Sheets[workbook.SheetNames[0]]constjson=XLSX.utils.sheet_to_json(sheet,{header:1})expect(json).toEqual([['My first Row','My second Row'],['val 1',50],['val 2',10]])})})
Metadata
Metadata
Assignees
Labels
No labels