Advertisement
Guest User

Untitled

a guest
Oct 7th, 2015
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. function getSheetData(workbook, sheetNumber, cellName) {
  2. var workbook = xlsx.readFile(workbook);
  3. var sheet_name = workbook.SheetNames[sheetNumber];
  4. var address_of_cell = cellName;
  5. var worksheet = workbook.Sheets[sheet_name];
  6. var desired_cell = worksheet[address_of_cell];
  7. var desired_value = desired_cell.v;
  8. return desired_value;
  9. }
  10.  
  11. var data = getSheetData('1234.xlsx', 0, 'A1');
  12. console.log(data);
  13.  
  14. // in js file
  15. res.render('example.jade', {
  16. data: getSheetData('1234.xlsx', 0, 'A1');
  17. })
  18.  
  19. // in jade file
  20. div=data
  21.  
  22. // in main js file
  23. global.getSheetData = function(workbook, sheetNumber, cellName){
  24. // your code
  25. }
  26. // in jade file
  27. div=getSheetData('1234.xlsx', 0, 'A1')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement