ExportDataTable with formulas

[Mia Lee]

When I have a spreadsheet that has formulas in the cells, and I use ExportDataTable of the worksheet object to populate a datatable, the data comes in as the formula and not as the display text. Is there a workaround?

[Geetha M]

Hi Mialee,

By default, only the cell values are used to when exporting to datatable and if you want to have DisplayText, then you may need to iterate through each and every cell and add it to the table.

Please let me know if you have any further questions.

Regards,
Geetha