Download Excel Issues

[uttamagarwala]

Dear Experts,

I am using ECC 6.0 version of sap with GUI 7 and MS office 2007.

When I download any data to excel its take the feature or excel 2003 and not allow me to download the data more than 66000 lines

Please help.

Uttam

[uttamagarwala]

Dear Experts,

I am using ECC 6.0 version of sap with GUI 7 and MS office 2007.

When I download any data to excel its take the feature or excel 2003 and not allow me to download the data more than 66000 lines

Please help.

Uttam

[Former Member]

Excel 2003 has the limit of 65536 rows by 256 columns which had been quite a problem for dealing with large data feeds which have lots and lots of row of data. Excel 2007 on the other hand, pushed that limit up to 1,048,576 rows by 16,384 columns.

If you must use 2003 then you could use several sheets to do what you want..

call method of excel 'Worksheets' = wsheet exporting #1 = 2 

[uttamagarwala]

But I am using 2007 and need all the data in one sheet.

Is it possible?

Or SAP doesnot support 2007.

Uttam

[Former Member]

Hi, think you shoud read this post

[LINK SAP|;

But one of the solution isto to change your extension from xls to xlsx. This is just a thought because i don´t know how do you build your code..

[fabio_passoni]

Issues

Check the function: XXL_FULL_API

If you need to have such....

Ok...

[Former Member]

Hi Uttam,

In the ALV, choose Local File -> Spreadsheet and save on ur computer.

Now open the file in excel.

You should be able to see more than 65K records.

Works for me.

Regards,

Jovito

[Former Member]

Hi,

By default that download option takes 2003 Excel.

Try List -> Export -> Spreadsheet

You will get popup of "An XXL list object is exported with XX lines and YY columns. Choose a processing mode:"

Select Table and excel will be generated.

PS: Store excel as soon as its downloaded, cuz it will not ask for option to SAVE when you close it.

Regards,

Ateet