PDA

View Full Version : EXt Js - using excel



adini
5 Dec 2013, 9:43 PM
Hello,

I have two queries which i would like to get clarified
Question -1:

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.


Regards,
Adini

scottmartin
6 Dec 2013, 7:01 AM
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)
http://phpexcel.codeplex.com/

Grid to excel:
http://druckit.wordpress.com/2013/10/26/generate-an-excel-file-from-an-ext-js-4-grid/

Pivot:
http://www.mzsolutions.eu/mzPivotGrid.html

adini
6 Dec 2013, 8:38 PM
Thank you Martin, i will try to implement the suggested solution.


Regards,
Adini