Reading excel to datatable is 0

Hi, anyone knows why when reading an excel to datatable, blank cells are read as either “0” or “1/0/1900” , instead of just blank? How do i make it such that it will read as “” ?

1 Like

Hi @Username95 ,

Can you please send me the sample excel file.


Hi, You can have cell formatting set in excel. Try a different read range method for Excel. From the package: System> File> Workbook> Read Range
it does not require nesting in the Excel Application Scope and is faster.

If you are using preserve format then uncheck it…
or try with workbook read range activity

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.