Guest User

Untitled

a guest
Nov 20th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. import xlsx from 'xlsx';
  2.  
  3. let Workbook = xlsx.utils.book_new();
  4. let items = [];
  5. let itemsH = [];
  6.  
  7. if (this.items.length > 0)
  8. {
  9. items = this.items.map(repor => {
  10. let formatted = {
  11. 'Req': repor[0].value,
  12. 'Requester': repor[1].value,
  13. 'ServiceRequested': repor[2].value,
  14. 'Status_Description': repor[3].value,
  15. 'CreatedDate': repor[4].value,
  16. 'Remaning_Time': repor[5].value,
  17. 'Status': repor[7].value,
  18. };
  19. return formatted;
  20. });
  21.  
  22. let itemsSheet = xlsx.utils.json_to_sheet(items);
  23. let wbcols = [{ wpx: 100 }, { wpx: 120 }, { wpx: 100 }, { wpx: 110 }, { wpx: 110 }, { wpx: 90 }, { wpx: 90 }];
  24. itemsSheet['!cols'] = wbcols;
  25.  
  26. xlsx.utils.book_append_sheet(Workbook, itemsSheet, 'Pending');
  27.  
  28. xlsx.writeFile(Workbook, `Approvals.xlsx`);
Add Comment
Please, Sign In to add comment