108
Views
4
Comments
Solved
[OutSystems Data Grid] Get the excel binary file of data showing in grid
outsystems-data-grid
Reactive icon
Forge asset by OutSystems
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

2023-10-21 19-42-11
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

2019-11-27 05-27-15
Sivaramakrishnaprasad Repalle

Hi @Tousif Khan ,

I have similar requirement, can you please guide me how did you done this, may be sample oml or javascript code that you have used to fetch the binary file while exporting data from grid?

Thanks in advance!

Siva

UserImage.jpg
Savvas Savva

Hello!

I have a similar requirement as well. I also need guidance on this. Perhaps you could provide a sample OML or JavaScript code snippet that demonstrates how you fetched the binary file during data export from the grid?

2022-11-12 11-28-30
Gonçalo Martins
Staff

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

2023-10-21 19-42-11
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

2019-11-27 05-27-15
Sivaramakrishnaprasad Repalle

Hi @Tousif Khan ,

I have similar requirement, can you please guide me how did you done this, may be sample oml or javascript code that you have used to fetch the binary file while exporting data from grid?

Thanks in advance!

Siva

UserImage.jpg
Savvas Savva

Hello!

I have a similar requirement as well. I also need guidance on this. Perhaps you could provide a sample OML or JavaScript code snippet that demonstrates how you fetched the binary file during data export from the grid?

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