Reading excel to datatable is 0

Learning Hub Academy Feedback
, , , ,
1

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
2

Hi @Username95 ,

Can you please send me the sample excel file.

Cheers

3

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.

5

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

6

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