Author Topic: Updating grid from excel file with live data  (Read 270 times)

samsonwilliams

  • Newbie
  • *
  • Posts: 1
    • View Profile
Updating grid from excel file with live data
« on: May 31, 2024, 09:24:56 am »
Hello, 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

  • Administrator
  • Hero Member
  • *****
  • Posts: 6263
    • View Profile
Re: Updating grid from excel file with live data
« Reply #1 on: June 03, 2024, 11:02:44 pm »
Incremental changes in spreadsheet can't be saved to xlsx file but the whole spreadsheet can be posted and saved to the remote server.

Relevant methods:

https://paramquery.com/pro/api#method-exportData

https://paramquery.com/pro/api#method-postData