Grid To Excel With formula

[Javier HernandezParticipant]

Hi! everyone, I need to know if there is a possibility that with this framework you can export a Grid or DataTable to excel but you can also add Excel formulas in the export and thus avoid the user having to enter the formulas for each column TOTAL o TOTAL row.

Regards
Javier Hernandez IT-Developer
Chile

[HristoParticipant]

Hello Javier Hernandez,

I would like to ask you to clarify it.
Do you think to save custom calculation created in the jqxGrid (or jqxDataTable) and to export it to Excel and to save this calculation as a formula there?
Unfortunately, we do not support such a feature.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[Javier HernandezParticipant]

In reality, what I’m looking for is to export the jqxgrid to excel …
but before this happens, “write” the formula SUM (A1: A10) (for example) in some cell and this is passed to excel in formula form, not as text. This in order to avoid the user perform a re-calculation of the total in case of need.

I try to make an export as dynamic as possible.

Javier Hernandez

[Author]

Posts