topic Re: Download Excel Issues in Application Development and Automation Discussions

Download Excel Issues

uttamagarwala — Thu, 06 Jan 2011 10:36:20 GMT

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

Re: Download Excel Issues

Former Member — Thu, 06 Jan 2011 10:48:40 GMT

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

Re: Download Excel Issues

uttamagarwala — Thu, 06 Jan 2011 10:53:28 GMT

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

Is it possible?

Or SAP doesnot support 2007.

Uttam

Re: Download Excel Issues

Former Member — Thu, 06 Jan 2011 10:59:53 GMT

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

Re: Download Excel Issues

fabio_passoni — Thu, 06 Jan 2011 11:07:07 GMT

Issues

Check the function: XXL_FULL_API

If you need to have such....

Ok...

Re: Download Excel Issues

Former Member — Fri, 07 Jan 2011 10:06:45 GMT

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

Re: Download Excel Issues

Former Member — Fri, 07 Jan 2011 10:21:17 GMT

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