Export Excel width in REUSE_ALV_GRID_DISPLAY

[Former Member]

Hello experts!

I have a problem when i try export to excel in REUSE_ALV_GRID_DISPLAY. The characters number is lower than 1023, exactly around 540 and the columns headers 693, but the export truncates columns. i.e: 66 total columns but it shows 62  columns on first line and 4 the second line. My question is, Is it possible to increase the maximum width to 1023, acording the notes 855314 - Downloading a list from the ALV to Excel?

Regards.

[Former Member]

Hello experts!

I have a problem when i try export to excel in REUSE_ALV_GRID_DISPLAY. The characters number is lower than 1023, exactly around 540 and the columns headers 693, but the export truncates columns. i.e: 66 total columns but it shows 62  columns on first line and 4 the second line. My question is, Is it possible to increase the maximum width to 1023, acording the notes 855314 - Downloading a list from the ALV to Excel?

Regards.

[Former Member]

Hi José,

Have you tried in the declaration of the report to set the size?

REPORT  <report-name> LINE-SIZE <nnn>.

Regards.

[Former Member]

Hi jose,

are you  using any functions to convert alv to excel?

alv also provides the function to convert alv to excel shown below.

Regards Ashwin.kv

[Former Member]

Thank you guys for your answers.

I have proved set the size, but the problem continues and I am using that function.

Any idea more?

Thanks, regards.

[peng_wen]

Hello,

As far as I know the only limitation for this should be the maximum width to 1023,
I would like to suggest you to check the exact length again by the Print button, Properties,
double click on the Format, what is the column number?
Moreover I think you can try the export again with new SAPGUI patch and see is it the same.

Regards,
Wen Peng

[Former Member]

Hello jose,

Have a look on this,

http://wiki.scn.sap.com/wiki/display/SI/OLE+concept+for+downloading+the+report+output+into+excel

OLE excel document creation and formating

Hope useful,

Regards,

sudheer

[Former Member]

Thank you very much to all.

Finally i have solved the problem. First, i added datatype in catalog but it failed.

But only failed one column, so i did several test and i have discovered that the fault is in database, specifically in the type. I must save the records again.