I did a few tests on Workbook Write Range, and it seems to me that it only writes the data content to the excel file without the associated formula.
Can I conclude that Workbook Write Range overrides any existing data, and formula (but keep the format of the individual cells of the original excel written to the Data Table, eg. date, general) on the excel file with the data from the DataTable ?
I encounter error when I use the Workbook Write Range to an excel file with existing format and formula (even I cleared all content in the excel file), but ok (can get all data to the excel) if the excel file is empty.
Is there anything wrong with my concept ?