Read Range in Workbook

Feedback StudioX
1

if the “preserve format” is not selected while reading the range in the workbook does it also discards all the filters automatically?
Please help me with this query?

3

Hi @SHRUTI_SHAMBHAWI, welcome to the Community.

When reading a range from a workbook using the Read Range activity, the Preserve Format option does not affect the filters applied in the worksheet. It is actually related to how the data is read and represented in the DataTable object in UiPath.

Hope this helps,
Best Regards.

4

Hi @SHRUTI_SHAMBHAWI

as the option name suggests preserve format,
it retains the format of the values written inside it.
It would be reading the data of each row cell by cell, thus taking longer time to read the data from excel.
It will retain Number formats, Date formats, Currencies, etc.

Thanks

5

Hi @SHRUTI_SHAMBHAWI

No, selecting or not selecting the “preserve format” option while reading a range in a workbook does not automatically discard filters. The “preserve format” option primarily affects the formatting of the data being read, such as preserving the number format, cell colors, and other formatting styles.

Thanks!!