I have a large Excel file where i need to preserve the format but the “Uipath.Excel.Activites.ExcelReadrange” is really slow when the “PreserveFormat” box is checked.
Is there any other way to do this faster?
Is it possible to just use the “Uipath.Excel.Activites.ExcelReadrange” and only read specific columns and preserve the formats of those?
Currently it looks like this:
Directly after the Read Range i have a filter datatable where I am only interested in 4 columns.
Can i do like this:
Or will this read the entire excel sheet 4 times first starting from “A3” and then from “C3” and so on?
What is the best way to make this as fast as possible?