You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Nov 14, 2017. It is now read-only.
There is nothing like a good example to get started with this package. Check out this MeteorPad for an exportable leaderboard to excel file. Follow the comments in the meteorpad, mainly in the server/app.js file.
Get the SheetNames (this is important to use most of the functions)
varyourSheetsName=workbook.SheetNames;
Get a cell
console.log("Get the 1st Sheet Name (remember is an array): "+workbook.SheetNames[0]);console.log("Get Some Cell from it: "+workbook.Sheets[yourSheetsName[0]]['C37'].v);
Make a JSON out of your excel
// We want JSON for this sheet:varsheet=workbook.Sheets[yourSheetsName[0]]// You can get the sheet as list of lists.varoptions={header : 1}// Or you can get an object with column headers as keys. varoptions={header : ['title','fName','sName','address']}// If options is empty or omitted, it should use the first-row headers by default. // However this doesn't seem to work with all Excel worksheets. varoptions={}// Generate the JSON like so:varworkbookJson=excel.utils.sheet_to_json(sheet,options);