From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

Excel file limitation error

Highlighted
Five Stars

Excel file limitation error

Hi,

i am loading data from database to excel files. but after loading 900000 it getting error illegal argument exceed limit.

below is the screen shot lease find it.

Highlighted
Nine Stars

Re: Excel file limitation error

As Excel has a maximum of 64K rows, I dont think you can do what you need - though a setting in the component may allow it (see link).

 

Thanks

 

David

Regards David
Dont forget to give Kudos when an answer is helpful or mark the answer as the solution.
Highlighted
Five Stars

Re: Excel file limitation error

Hi,

i think i have to split the excel file into two sheets or files.How to do splitting can you tell me

Highlighted
Moderator

Re: Excel file limitation error

@karthik_T,check below links may be useful to split.

 

https://www.talendforge.org/forum/viewtopic.php?id=48635

https://community.talend.com/t5/Design-and-Development/resolved-split-large-excel-file-to-2-or-more-...

Manohar B
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Excel file limitation error

SSRS 2008R2 supports the .xls file extension for Excel, but these Excel files support a maximum of 65,536 records per sheet. When you try to export a SSRSreport which has more than 65,536 records it will fail to export the report intoExcel.J

Free Movie Sites l Frp Bypass Apk l Iptv Kodi Addons

Highlighted
Five Stars

Re: Excel file limitation error

Hi,

thanks,its working.

Highlighted
Moderator

Re: Excel file limitation error

@karthik_T,please accept the solution,which one is helped you.

Manohar B
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: Excel file limitation error

SSRS 2008R2 supports the .xls file extension for Excel, but these Excel files support a maximum of 65,536 records per sheet. When you try to export a SSRSreport which has more than 65,536 records it will fail to export the report intoExcel.J tinklepad movies | IMO Free Download For Windows | flixnet kodi | kissanime mobile | Tubemate For PC | Download My Talking Tom For PC

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog