is possible able upload excel document varying ranges of data, , have data dynamically displayed in basic form of chart(bar, pie, etc.) on our company website.
after doing research figured 2 possible ways maybe use complicated macro in vba or javascript parser read data , display then. data go in here have sensitive information cannot use google charts or that.
there no real easy way have found. have had manually parse these things in past there libraries out there node might you.
https://www.npmjs.com/package/node-xlsx
you can export form excel csv. when this, me sure set custom separator other ',' , should fine import large array , data/charts need.
https://github.com/wdavidw/node-csv
hope helps.
Comments
Post a Comment