Hi All,
My excel file contains almost 205K rows. Pl. apprise me how to read all the rows efficiently and fast. Also the new package of UiPathTeam.XLExcel.Activites has been introduced for handling the huge and large excel data files but unable to use it properly. Could anyone tell the process?
Many thanks,
What are you attempting to do with the 205k rows after it has been read into memory?
For the UiPathTeam.XLExcel.Activites, what problems are you experiencing when attempting to use the dependency?
Thanks
Hi @Kristopher : Thank you very much for your reply. Pl. find attached the .xaml file herewith for your reference and perusal. The only problem lies in the Assign Activity DateFormts and It does not recognize the DateTimeStyles but on the other hand, the same workflow smoothly runs without UiPathTeam.XLExcel Activity.
Pl guide.
Thanks,
Extra_Large_Excel_Files_Handling.xaml (15.3 KB)
The error you are experiencing is because either the System.Globalization namespace must be imported into the XAML file:
Or the fully qualified name of the method must be used, similar to CultureInfo:
Once you change that, does your file work properly?
Thanks
@Kristopher : Thanks a lot for your swift response. Issue is resolved now but when I use Read Range activity from UiPathTeams.XLExcel, following error occurred:
Assign Activity
LHS: CurrentRow(“ETB/NTB”)
RHS: CurrentRow(“Account Opening Date”).Tostring.Trim
Gives an error:
“Account Opening Date does not belong to the data table.”
On the other hand, when I use Read Range activity from Workbook then the above error gets resolved. But the following error arises, pl. see attachment. You may also check it from my previous .xaml file that I have shared with you. Many thanks,
Can you share the Excel file with just the Headers populated, and possibly some test data please?
This error normally arises when the code cannot find the column name specified. This is often attributed to excess spaces before/after the values, or maybe too many spaces between words (and sometimes other issues). The name of the column must be an exact match. You may want to try and copy / paste the column name from the spreadsheet directly into your code to see if there are extra characters.
Thanks
Hi @Kristopher : I have also copied and pasted the column name directly from the spreadsheet but the same error received. Pl. see below.
Actually the excel file is confidential and cannot be shared please. But I have attached the log file, may be it can be useful for you.
2022-01-29_Studio.zip (4.0 KB)
Extra_Large_Excel_Files_Handling.xaml (20.6 KB)
Many thanks,
In your Read range, you did not specify Headers.
Does your Excel file have Headers?
If you are not specifying Headers, then your column headers are named Column1, Column2, etc.
You added the ETB/NTB column to the DataTable, but as you can see from debug mode - the first column is not Account Opening Date, it is Column1
When specifying Headers = True on the Read Range activity, I was able to see the following data in the DataTable:
Note - I had to format the date values in the Excel file as Strings, not as Dates ('01/01/2022 - note the apostrophe at the beginning to specify that this is a String, not a Date)
Thanks
@Kristopher : Thank you very much for your great support. Issue is resolved now but one problem is remain. As my Account Opening Date column in excel had some different date formats and I handled those in the assign activity name DateFormats because I want to compare my excel column with the static date which is in Assign Activity name ZNA_Date.
I want to minus the dates from the static date and then classify into ETB and NTB. You may see the the workflow in .xaml file which I have shared with you.
Pl. help in this regard.
Many thanks,
The easiest way to resolve this issue is to apply data validation to the cells in Excel and ensure the users who provide the data are inputting the dates into the desired format.
Thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
