Current Position:Home > ALV TO EXCEL PROBLEM? ( 90 COLUMNS ALV CAN'T EXPORT TO EXCEL NORMALLY)

ALV TO EXCEL PROBLEM? ( 90 COLUMNS ALV CAN'T EXPORT TO EXCEL NORMALLY)

Update:10-11Source: network consolidation
Advertisement
HI ABAPERS,
anyone have a alv that have over 90 columns and want to export to excel have experienced abnormal formating (like the header row show only up to 60 column and the rest show up in next row) and the data show in separate line.
anyway can have a better format?
also after 90 columns show up on alv, it can't show anymore except modify the layout in run time.
can we do something before that?
thanks & regards,
HOWARD

The Best Answer

Advertisement
Hi HOWARD,
My Report ouput having more than 90 columns in ALV, while downloading data from ALV to Excel sheet am facing alignment problem. (ie) the output column > 66 are appearing in next line of the excel sheet leads to improper alignment.
Pls give me a solution as u had already come across this issue..
Thank & Regards,
Paramesh.
  • ALV TO EXCEL PROBLEM? ( 90 COLUMNS ALV CAN'T EXPORT TO EXCEL NORMALLY) Update:10-11

    HI ABAPERS, anyone have a alv that have over 90 columns and want to export to excel have experienced abnormal formating (like the header row show only up to 60 column and the rest show up in next row) and the data show in separate line. anyway can ha

  • Problem with columns in the middle of my book Update:10-11

    I am writing my second book with Pages 2.02 and have run into a problem with columns. I want to add a long list of items as a list with check boxes for readers to check off. If I paste in enough text for three or four pages of two columns it gets mes

  • To get own Filed Desc. like ALV Grid while exporting to ALV using standard Update:10-11

    Hi all, How to get the custom field heading when we export to XLS using the standard Functionality/button available in ALV grid to  export to spread sheet. I mean is there anything in ALV field catalog /something by which we can have our custom headi

  • Problems with JPGs that have been exported from InDesign Update:10-11

    I have used InDesign CS4 for years and recently been upgraded to the Creative Cloud package, I have gone from a PC to a MAC as well. The problem seems to be when I export a document in InDesign to a JPG file, when I try and use the JPG in other appli

  • ALV download to Excel--Problem with Column Headers Update:10-11

    Hi, I have created a dynamic internal table and displaying it as ALV using SALV classes. Problem is that  when I download this ALV to Excel I'm not getting Column headings same as they are in ALV display. I mean in Excel it is showing Column headings

  • Problem while alv grid display exporting to excel sheet Update:10-11

    Hi,   I have done an ALV report using reuse_alv_grid _display , out put is fine , but when i click on excel view icon i could only see an excel sheet without any data ., but when i use export to local file and choose spread sheet its giving the data

  • ALV Grid Report spool problem with column with no data Update:10-11

    Hello All, I have created a simple alv grid report the report has a description field of 40 ch for which I have made the display length as 20 ch . This works fine in the foreground but when I run the report in background when there is no data in this

  • ALV Report performance & export problem Update:10-11

    Hi, We have developed an complex ALV report which accesses the data from FI Tables like BKPF, BSEG, BSAK etc.,   There are almost 100 lac records in BSEG and every day around 20000 records are getting added to that.  Eventhough I have used specific s

  • Reg alv grid display exporting to excel sheet Update:10-11

    hi experts, I have done an ALV report using reuse_alv_grid _display , out put is fine , but when i click on excel view icon i could only see an excel sheet without any data ., but when i use export to local file and choose spread sheet its giving  th

  • Error While ALV Grid is exported to Excel. Update:10-11

    Hi Experts, I get an error OBJECTS_NOT_CHARLIKE , while I try to download an ALV Grid , to an excel file using the standard icon Export  present on the ALV Grid. Regards. Edited by: sunitha j on May 19, 2009 1:15 PMThis happens when your output list