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
Showing results for 
Search instead for 
Did you mean: 

Record Count during download to excel

Former Member
0 Kudos

Hi,

When downloading a file created on the application server on to my local machine(in the excel format), what is the maximum no of records that can be downloaded in one go?

I had a case where the file contained a large number of records & all could not be downloaded when I tried using ws_download.

Many Thanks.

2 REPLIES 2

athavanraja
Active Contributor
0 Kudos

I remember reading somewhere that Excel has a limitation of holding only 65000 records.

Regards

Raja

ssimsekler
Active Contributor
0 Kudos

Hi!

In fact, MS Excel itself has the restriction of at most 65535 rows in a worksheet.

'WS_DOWNLOAD' has a restriction about the line length. I do not remember the number but it was about 1800 I guess (had better check this).

As it is announced 'WS_DOWNLOAD' is obsolete and is replaced by the function module 'GUI_DOWNLOAD'. But I do not know whether the latter one has that line length restriction.

The easiest solution should be, as I think, to split the data to be transfered to multiple files.

*--Serdar