Champion
29
Views
2
Comments
Solved
[OutSystems Data Grid] Get the excel binary file of data showing in grid
data-grid-reactive
Reactive icon
Forge component by Gonçalo Martins
Application Type
Reactive

Hello

I have a data grid which is dynamic grid, it populate column basis on the conditioning we have define,

Now I know we can export the excel via Contex Menu as well as on a button click via 
This Js code

  • GridAPI.GridManager.GetGridById($parameters.GridWidgetId).features.export.exportToExcel($parameters.IncludeStyles, $parameters.FileName); 

Now I want the same binary file for the layout showing in the grid.

  • The scenario is , before exporting this file I want to save this excel file to the database.

If this is not possible can we get the Json of what we are exporting to excel.

I hope someone may help with this

Thanks

Tousif Khan

Champion
Solution

Finally I have Searched on Wijmo Forum and I was able to get the information which I needed,

We use Collection View to get all the data which is behind the paginated screens, 

We did Json manipulation on the data we got from collection view and finally exported the excel with the changes and saved the file to DB.
Liink to Wijmo - https://www.grapecity.com/wijmo/demos/Core/CollectionView/Overview/purejs

https://www.grapecity.com/forums/wijmo/how-to-get-all-the-rows-from-wijmo-flexgrid-with-pagination

Marking this Post as a Solution so that, if someone had the same issue will find out the answer.

Thanks

Tousif Khan

Hello @Tousif Khan 

About getting the binary data of the Excel I don't think the Wijmo library supports that since that's not the purpose of the feature.

About the other topic, which JSON were you expecting to get? 
Could you please provide some more information about your use case? 

Cheers,
GM

Champion
Solution

Finally I have Searched on Wijmo Forum and I was able to get the information which I needed,

We use Collection View to get all the data which is behind the paginated screens, 

We did Json manipulation on the data we got from collection view and finally exported the excel with the changes and saved the file to DB.
Liink to Wijmo - https://www.grapecity.com/wijmo/demos/Core/CollectionView/Overview/purejs

https://www.grapecity.com/forums/wijmo/how-to-get-all-the-rows-from-wijmo-flexgrid-with-pagination

Marking this Post as a Solution so that, if someone had the same issue will find out the answer.

Thanks

Tousif Khan

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.