Forum Discussion

Sathish's avatar
Sathish
Ideator I
8 years ago

Export GridContainer to Excel

We use the Aras treegridcontainer to construct data in a custom UI. Is there an inbuilt API that will enable to export the data that is displayed in the treegrid UI  to excel. Any inputs related to this will be helpful
Excel

3 Replies

  • christopher_gillis's avatar
    christopher_gillis
    New Member
    8 years ago
    Hello, This may be possible by using the aras.export2Office javascript function. You can see an example of how to use this function to export a grid to an Excel file in the JavaScript Method cui_default_mwt_export2Excel. Chris
    Christopher Gillis Aras Labs Software Engineer
    • Pavlo_Shchebuniaiev's avatar
      Pavlo_Shchebuniaiev
      Ideator I
      3 years ago

      I`m little bit struggling with this question too. In my case I need to export all rows of the Impact Matrix and indeed aras.export2Office works but impactGrid.grid.getXML collects only 1 level of rows (no collapsed rows).
      maybe somebody knows how to get all rows into xml to be able to export to excel them later on?

  • AngelaIp's avatar
    AngelaIp
    Ideator I
    8 years ago
    Hi good question! I would be also interested in this use case. Also I haven´t seen an option to export tree grid content so far. I right now use standard report options to create Excel reports with similar design and content. Angela