Updating Excel file from Grid

[pbassey]

Good morning. I am looking for an example of how to have an excel file used to load the grid (using importXl & importWb) be updated as updates in the cells are made.  I see other examples of this in your demos, but nothing that uses an excel file as the source.

Thank you...

[paramvir]

Its workflow is import xlsx file into grid -> edit data and styles in grid -> export as xlsx file

Examples:

https://paramquery.com/pro/demos/import_xlsx_tabs

https://paramquery.com/pro/demos/import-xlsx

[pbassey]

Thank you for the reply, but your response describes the use of the Export function (this.exportExcel).  I was looking for an implementation where the data in the spreadsheet is updated back to the excel file in real time similar to this example:
https://paramquery.com/pro/demos/editing_instant

Is there an example where this can be accomplished by updating the original Excel file used to load the Grid??

Thanks,
Peter

[paramvir]

Same method can be used to update the originating Excel file on server by passing url parameter to it.

This method posts pq_data, pq_ext, pq_decode, pq_filename parameters to the server.

Server script can copy data from pq_data and base64 decode the data if pq_decode is true, save data in a file and replace the originating excel file with it.

Note that file based exports ( xlsx, html, json, csv ) don't support incremental or differential updates.

[pbassey]

Can you please provide a bit more detail with regard the syntax for the parameters (pq_data, pq_ext, pq_decode, pq_filename).  I see these parameters mentioned in your API section, but there are no examples anywhere on how to use them.

I would like to integrate these functions into a grid that does instant editing (saving) of data to the excel source file.  This example below is exactly what I need to do except the update is going back to the input excel file:
https://paramquery.com/pro/demos/editing_instant

[paramvir]

These parameters are posted to and are used in remote script.

The usage of these parameters can be seen in this example under the tabs ASP.NET, PHP & Java: https://paramquery.com/pro/demos/export. Only difference is that in this example xlsx file is returned back to the client ( browser ) while in your case you need to replace original file with new file on the server itself.

Please let me know if you need further assistance.