Advertisement
Guest User

Untitled

a guest
Mar 18th, 2019
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. cmp.set('v.customObjectTableColumns', [
  2. {label: 'Name', fieldName: 'Name', type: 'text'},
  3. {label: 'Quantity', fieldName: 'Quantity__c', type: 'number'},
  4. {label: 'Date', fieldName: 'Date__c', type: 'date'}]);
  5.  
  6. fr.onload = $A.getCallback(function() {
  7. let fileContents = fr.result;
  8. let workbook = XLSX.read(fileContents, {
  9. type: 'binary'
  10. });
  11. let rows = XLSX.utils.sheet_to_json(workbook.Sheets[workbook.SheetNames[0]]);
  12. let customObjects = [];
  13.  
  14. for (let i = 0, len = rows.length; i < len; i++) {
  15.  
  16. for (let j = 1; j <= 5; j++) {
  17. let customObject = {
  18. sobjectType: 'customObject__c',
  19. Name: rows[i]['Name'],
  20. Quantity__c: rows[i]['Quantity']
  21. Date__c: rows[i]['Date']
  22. };
  23. customObjects.push(customObject);
  24. }
  25. }
  26. cmp.set("v.customObjects", customObjects);
  27. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement