Skip to Content
avatar image
Former Member

Record Count during download to excel

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jul 14, 2004 at 11:17 AM

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

    Regards

    Raja

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 14, 2004 at 08:57 PM

    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

    Add comment
    10|10000 characters needed characters exceeded