Read Large excel file

Help Activities
, ,
1

Hello,

I’d like to know how I can work with excel files with more than 70k lines without getting hours to read the lines and set them to a data table. With the actual activities, I’m getting more than 2 hours to read it.

2

@thayane.ribeiro

Welcome to forums

Check below for your reference

Hope this helps you

Thanks

1 Like
3

Hi @thayane.ribeiro ,

Few things You can Try -

  1. Change the Extension of the File to .xlsb and Try Reading it .

  2. We can try writing a Logic to Read the Excel Data in chunks - E.g. - Row 1 : 10000 , Then 100001 - 20000 , and so on

Thanks
Mukesh

1 Like
4

Check this below link, @thayane.ribeiro

Hope this may help you :slight_smile:

5

@thayane.ribeiro How many columns does it includes? Are there any VLookups used in the file you are reading?
Try with workbook read range activity before going to any other solution.
Also, try using read range in excel application scope with unchecking the visible option of Excel Application scope property.
image

1 Like
6

Thanks, everyone! I changed my file extension to CSV and now it’s reading in less than one minute!

2 Likes
7

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