EXt Js - using excel
I have two queries which i would like to get clarified
Instead of using pivot tables in excel, can we pass excel data sheet as a input to html page which was build on Ext Js and like to show different graphs based on the data.
Question - 2
can we do all the work does pivot table in Ext js?
please share me some thoughts on this.
To supply data to a graph, you just need to export it to JSON so the grid/chart can load the data.
You should find a library that works with your server to read the XLS and convert the data (php example)
Grid to excel:
Thank you Martin, i will try to implement the suggested solution.