Open a excel file (xlsx) and refresh al the data connections

Question

Hi,I'm trying to open an excel file and update de data in the file with a link to another excel file with the raw data. I can open, change the file in a cell and save. But the data doesn't get updated with the changes in the raw data file.How can I guarantee the data refresh in the xlxs file? In the Excel file all objets (tables and connections) are configured to update automatically when opening the file.Thanks in advance,Victor Marques

Konduru Keerthi Konduru Ravichandra Raju · Answer

Hi Victor, Syncfusion XlsIO does support refreshing the data connections for Excel tables. Please go through the below link for details and code snippet.https://help.syncfusion.com/file-formats/xlsio/working-with-excel-tables#refresh-external-data-connection-in-excel-table Regards,
Keerthi.