1. #1
    Sencha User
    Join Date
    Nov 2013
    Posts
    9
    Vote Rating
    0
    adini is on a distinguished road

      0  

    Default Unanswered: EXt Js - using excel

    Unanswered: EXt Js - using excel


    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

  2. #2
    Sencha - Support Team scottmartin's Avatar
    Join Date
    Jul 2010
    Location
    Houston, Tx
    Posts
    9,001
    Answers
    666
    Vote Rating
    456
    scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future

      0  

    Default


    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...ext-js-4-grid/

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

  3. #3
    Sencha User
    Join Date
    Nov 2013
    Posts
    9
    Vote Rating
    0
    adini is on a distinguished road

      0  

    Default


    Thank you Martin, i will try to implement the suggested solution.


    Regards,
    Adini

Thread Participants: 1