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?
I Am yet to try this, yet, as per my knowledge, I Don’t think this would work , by giving range like this.
You have to use four read range activities for four different columns if the columns are not continous.
Yeah, I feel like this only will make it take longer, is it a way to only read specific columns(and keep the format) instead of the whole file from the “A3” in this case.
Add Data Column activity can be used.
Yet, there is a catch. The read column activity returns a different type (IEnum) and Add Data COlumn needs System.data.datacolumn
Type conversion has to be done.
Else, read range ( give range of single column) - this is easier as it would return data table itself which can be used with merge data tables
You say " Else, read range ( give range of single column) - this is easier as it would return data table itself which can be used with merge data tables"
How do i give Read range the command to only read a single column?
"Add Data Column activity can be used.
Yet, there is a catch. The read column activity returns a different type (IEnum) and Add Data COlumn needs System.data.datacolumn
Type conversion has to be done.
Else, read range ( give range of single column) - this is easier as it would return data table itself which can be used with merge data tables
Thanks,
Arun"
I am interested in the balded part and also this:
"You have to give ‘A:A’ - i.e, for whichever column you need to read. this example reads entire A column.