Preserve format enable

Hi Team,

In the excel, I have data has #N/A value in some of the columns and I need to read.
If I read using read range, not able to get #N/A value and if I do by keeping preserve format enable I can see.

But data is like 2000 rows, taking to much time.

Any suggestion on this?


@Sharanabasava1 Can you share the sample excel file and let us know what you want to update instead of “#N/A” in the file?

Excel sheet is in client machine and not have provision to send.

@Sharanabasava1 Which activity you are using for reading the file, excel or workbook activity?

excel and enable the preserve format