Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

only 65535 records getting downloaded to excel

Former Member

‎2009 Feb 26 11:32 AM

0 Kudos
177

Dear All,

I have an Internal table exceeding 65535 records, almost 80000 records.

I want to download all the records to an Excel.

How do i download the entire records into same work sheet.

is there any work around.

Also tried to give column headings to the EXCEL.

using GUI_DOWNLOAD, but the column headings are appearing to max of 10 charectors.

i gave heading lets say 'MATERIAL NUMBER', only material is printed (ten char)

Please suggest.

Regards,

Purshoth

7 REPLIES 7

Former Member

‎2009 Feb 26 11:34 AM

0 Kudos
89

upgrade your excel.

Actually the old excel is only capable of 65535 lines.

Former Member
In response to Former Member

‎2009 Feb 26 11:36 AM

0 Kudos
89

what should i do. please let me know if there is any work around.

Former Member

‎2009 Feb 26 11:37 AM

0 Kudos
89

Hi purushothaman,

It is possible if can change the worksheet after the limit exceeds in excel.

Or else you can try with Notepad, as there is no limit for the nr of lines.

Regards,

SB.

Former Member

‎2009 Feb 26 11:40 AM

0 Kudos
89

Hi Purushothaman,

I am not sure of limitation on no of records in newer version of Excel.

If newer version allows more than 65535 records, then try to get newer version.

If you have to work in same existing version, then you can split your download. Means download file after every 65535 records. So you will have multiple files.

Regards,

Anil

Former Member
In response to Former Member

‎2009 Feb 26 12:48 PM

0 Kudos
89

Please let me know otherwise how to add different internal tables as one work sheet in the same excel fiel.

I will split the internal table into 2 or more tables.

but each table needs to be appended as a different worksheet in the same excel.

Please let me know.

regards,

siva

Former Member

‎2009 Feb 26 12:52 PM

0 Kudos
89

You could try importing into the last version of Open Office Calc. Unlike Excel, Open Office is free to download, test, keep,modify and use.

Former Member

‎2009 Feb 26 1:23 PM

0 Kudos
89

Hi,

i think u are using excel 2003 in ur system. by using Excel 2003 we can download up to 65535.

its limitation of excel 2003.

options :

1. Install excel -2007 in ur sytem u can download up to 8 lakhs.

2. Download to note pad (.txt ).

3. split ur internal table into two internal tables and download into two excel files.

Rgds..

siva