Read a 40 size MB Excel file

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

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

Hi Karthik

Yes the sheet has conditional formatting and Formulas

Thanks
Ashwin S

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.

Hi Karthik

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

Thanks
Ashwin S

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

Regards,
Karthik Byggari

Hi @KarthikByggari

No
It has column count around 95 and dynamic rows

Thanks
Ashwin S

Hi Buddy @AshwinS2

This component could help you

Cheers @AshwinS2

1 Like

Hi Palaniappan

Will get back to you on this :slight_smile:

Thanks
Ashwin S

Hi

Is it compatible with 2016 and 2017 version

Thanks
Ashwin.S