Big Excel File

Help Activities
1

Hello all,

I need to process Excel files with more than 25,000 lines. The problem is that it takes a very long time to go through these lines.

I would like to put them in a Data Table to then filter by supplier number, and retrieve the rows from these suppliers to create a file / supplier.

The Read Range activity takes a long time. The foreach row as well.

I also tried to convert my Excel file to CSV but some cells are empty so I always get an error “The header contains more data than the row…”

Do you have a solution for me please?

Thank you

2

Hi @DimitriLYR

Try using excel as DB and perform your steps

cheers

3

Hello @DimitriLYR,

I propose a solution to using excel directly, and using filter excel activity to filter the data and read the filtered data and save them to different file. If you need to use formula u just need to write on one cell and autofill the formula.

Write cell formula : https://docs.uipath.com/activities/docs/excel-write-cell
Autofill : https://docs.uipath.com/activities/docs/excel-auto-fill-range

Cheer,
Happy Automation

1 Like
4

Hi, thank for you share.

I’m try the soluce :slight_smile:

1 Like
5

Sure, let me know if you need help

6

Good morning !

I did not think about it ! Thank you very much for this tip!

1 Like
7

sure thing

1 Like
8

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