Workbook Write Range to excel with formula




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 ?




If you use the Write Range activity associated with the Excel Application Scope it should work. Workbook actions will not do if you try to write formulas, it will just write the formula as a literal value :smile: .


Thank you very much for your prompt advice.