Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import xlsx from 'xlsx';
- let Workbook = xlsx.utils.book_new();
- let items = [];
- let itemsH = [];
- if (this.items.length > 0)
- {
- items = this.items.map(repor => {
- let formatted = {
- 'Req': repor[0].value,
- 'Requester': repor[1].value,
- 'ServiceRequested': repor[2].value,
- 'Status_Description': repor[3].value,
- 'CreatedDate': repor[4].value,
- 'Remaning_Time': repor[5].value,
- 'Status': repor[7].value,
- };
- return formatted;
- });
- let itemsSheet = xlsx.utils.json_to_sheet(items);
- let wbcols = [{ wpx: 100 }, { wpx: 120 }, { wpx: 100 }, { wpx: 110 }, { wpx: 110 }, { wpx: 90 }, { wpx: 90 }];
- itemsSheet['!cols'] = wbcols;
- xlsx.utils.book_append_sheet(Workbook, itemsSheet, 'Pending');
- xlsx.writeFile(Workbook, `Approvals.xlsx`);
Add Comment
Please, Sign In to add comment