Read a 40 size MB Excel file

Help
1

Hi all
I have a 40 size MB Excel file in a particular Sheet which has number of rows and columns

Please help me to find the solution

Thanks
Ashwin.S

2

You can use Read Range activity to read the data from the Excel sheet.
Do you need all the data at once to process?

Regards,
Karthik Byggari

3

Hi Karthik

Yes the sheet has conditional formatting and Formulas

Thanks
Ashwin S

4

Because of formats and formulas, the size might be big.
You can load the excel data using Read Range activity and check if that works for you.

5

Hi Karthik

When i read the excel by using read range i am getting job error

Thanks
Ashwin S

6

Does that sheet contains any images or any objects ?
It may cause issue to read excel sheet.

Regards,
Karthik Byggari

7

Hi @KarthikByggari

No
It has column count around 95 and dynamic rows

Thanks
Ashwin S

8

Hi Buddy @AshwinS2

This component could help you
https://go.uipath.com/component/read-extra-large-spreadsheets

Cheers @AshwinS2

1 Like
9

Hi Palaniappan

Will get back to you on this :slight_smile:

Thanks
Ashwin S

10

Hi

Is it compatible with 2016 and 2017 version

Thanks
Ashwin.S