Hello,
I have an excel worksheet and update a lot of cells in one of the worksheets 'RAW_DATA' and then save the workbook. On the excel file saved to disk all changes are present.
I then try and save the 'DataBase' worksheet using the same workbook object, the updated values are not present, it is the same values I had in the workbook before the update.
How can I get the workbook object in memory to reload the values which are changed dynamically, based on the values I wrote to 'Raw_Data' and calculations.
To select worksheets to save as pdf/xps, is it correct to make the other sheets isVisible=false? if they have links to the worksheets which are no longer visible.
E.g.
wb.Worksheets["Raw_Data"].IsVisible = true;
wb.Worksheets["Processing"].IsVisible = false;
wb.Worksheets["DataBase"].IsVisible = false;
wb.Worksheets["Passeport_1_5"].IsVisible = false;
wb.Worksheets["Passeport_2_5"].IsVisible = false;
wb.Worksheets["Passeport_3_5"].IsVisible = false;
wb.Worksheets["Passeport_4_5"].IsVisible = false;
wb.Worksheets["Passeport_5_5"].IsVisible = false;
wb.Save(raw_file_csv, SaveFormat.CSV);
I have included the workbook which I am trying to work with.