Excel file limitation error

Four 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.

Seven 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

Don't forget to give Kudos when an answer is helpful or the solution.
Four 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

Thirteen Stars
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

Four Stars

Re: Excel file limitation error

Hi,

thanks,its working.

Thirteen Stars

Re: Excel file limitation error

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

Manohar B