Hello everyone, I have a large csv file more than 10 lakhs above rows is there when i read it i am not able to read it properly i got the error which is "Job stopped with an unexpected exit code: 0xE0434352" please help me guys

Using uipath

Hi @zaid.ahmad

Welcome to UiPath community

You can split the excel data into some small parts and do you automation

Check out the thread

Regards
Gokul

hello @Gokul001
how to split file in 5 sheet pls help me

Use Read Range activity and set the Range -> A1:AG200000 Store it as Dt1

Which will give us first set of DataTable and name it as dt1

Have you checked the above thread @zaid.ahmad It will be more detail

Regards
Gokul

@Gokul001 thanks i will try to make this process.

regards
Zaid Qazi

Let us know , If you face any issues @zaid.ahmad

@Gokul001 Sure

Hi,
If you are still facing the issue, try using modern Excel activities for read range.

Hello @balraj.krishnappa and @Gokul001
When i merge the data table then i have got an error which is “Merge Data Table: ‘table’ argument cannot be null.
Parameter name: table”
i have followed this thread How to read huge excel in Uipath

Hi @zaid.ahmad

This error notify that you are merging the empty Data Table. So cross check the Dt that you has an error have a Data in that Dt.

Regards
gokul

@Gokul001
Like we can split the data and read them
The sequence of activities will be like
— use a Build datatable activity and create a same structure datatable as in excel with same column name and order of columns
and get the output as Finaldt
And followed by this use CLEAR DATATABLE ACTIVITY and mention the input as Finaldt

—the inside excel application scope use Read range activity we can set the range like this
“A1:G1000000”
Which will give us first set of datatable and name it as dt1 and here in the property panel enable add headers

—then use again a READ RANGE activity and disable the add headers property and mention the range like this
“A1000001” so that it will start from were we left
Where get the output as datatable named dt2

—now use a For each row loop and pass dt2 as input
And inside the loop use Add Datarow activity and mention the ArrayRow as row.ItemArray and datatable as final dt
So all the records from dt2 will now be added to Finaldt

—then finally use MERGE DATATABLE activity where mention the source as dt and destination as Finaldt

So Finaldt will be our datatable with all records from excel
Though it takes the same time or even less than normal excel application scope and read range activity, it will work without any fail or error

Hope this would help you

please explain merge dt line

Can you share the workflow screenshot @zaid.ahmad

Hi @zaid.ahmad

Check out the Skeleton of the workflow

HugeExcel.xaml (8.4 KB)

Regards
Gokul

1 Like

@Gokul001
I was using merge dt inside of for each row but its run successfully.
but now can i use filter dt for two column using final_dt

Have you achieve the answer your query Right?

This above one is a new one Right? @zaid.ahmad

@Gokul001
yes i followed your workflow and run it completely.

Great @zaid.ahmad

Kindly close this topic by mark as solved. It would be help full for other too.

You can create a new topic for i use filter dt for two column using final_dt for this query

Regards
gokul

@Gokul001 sure

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.