NPM XLSX [sheetJS] add dynamic columns

Thanks for help in advance,    Now, we have multiple Array of Tag ID's(I'm using NPM XLSX package )  1. [       id:tagID1,        error:        {         code:0,          success: true       },       data: [      [1604395417575, 608, 3],       [1604395421453, 279, 3],      [1604395421453, 142, 3]     ]   ]      [       id:tagID2,        error:        {         code:0,          success: true       },       data: [      [1604395417575, 608, 3],       [1604395421453, 279, 3],      [1604395421453, 142, 3]     ]   ]   [       id: tagID3,        error:        {         code:0,          success: true       },       data: [      [1604395417575, 608, 3],       [1604395421453, 279, 3],      [1604395421453, 142, 3]     ]   ]    Eg Note: 1604395417575 - timestamp, 608 - value, 3- quality      I want to show in Excel sheet as in the below format    | Timestamp    |  tagID1 value  | tagID1 quality | tagID2 value   | tagID2 quality|  | --------     | -------------- | -------- ------| -------------- | ------------- |  | 1604395417575| 605            |   3            |     605        |   3      |  | 1604395417575| 605            |   3            |     600        |   3      |  

I'm new to XLSXSheetJS - I want to format the array in excel sheet in above particular format using sheetJS(XLSX), How can I do it? Desperately need an help on this issue. clkqiohqoifhqifheqjfpefepoqfkepoqfkepfkopewjfewiofeiwjfie

Thanks for the help in advance!!  

https://stackoverflow.com/questions/67033105/npm-xlsx-sheetjs-add-dynamic-columns April 10, 2021 at 06:08PM