Grid - Save Back To Dataset After Load From XLS

FMX TMS FMX UI Pack
1

Hi,


I have the Firemonkey TMS grid, live bound to a dataset.

After I load an Excel .XLS file using XLSImport method, all the data loads into the grid, but it does not automatically save to the underlying dataset. As soon as I click into the grid again, it refreshes and all the extra rows in the grid are lost.

Is there a way to load the new rows imported from the XLS file back to the dataset as it loads?

Thanks,

Greg
2

Unfortunately no, currently only reading from a dataset is supported

and direct editing the cells to save the data. We have added this on our feature request list for investigation.

Kind Regards, 
Pieter
3

Hi Pieter,


Thanks for the reply, I will write my own handler for now and save back to the dataset.

This would be a very useful feature when loading from csv or XLS for a future TMS release. 

Thanks,

Greg