topic Re: Excel file limitation error in Talend Studio

Excel file limitation error

karthik_T — Wed, 06 Jun 2018 17:17:38 GMT

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.

Re: Excel file limitation error

David_Beaty — Wed, 06 Jun 2018 17:27:21 GMT

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

Re: Excel file limitation error

karthik_T — Mon, 11 Jun 2018 08:42:26 GMT

Hi,

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

Re: Excel file limitation error

manodwhb — Mon, 11 Jun 2018 09:04:47 GMT

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

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

Re: Excel file limitation error

Anonymous — Mon, 11 Jun 2018 09:57:36 GMT

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

Re: Excel file limitation error

karthik_T — Wed, 13 Jun 2018 08:21:16 GMT

Hi,

thanks,its working.

Re: Excel file limitation error

manodwhb — Wed, 13 Jun 2018 08:48:14 GMT

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

Re: Excel file limitation error

Anonymous — Mon, 07 Jan 2019 15:55:54 GMT

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