2010 Jun 24 2:14 PM
Hi,
Can anyone please tel me if we can change the format of fields downloaded to excel sheet.
Actually..i am displaying an ALV using reuse_alv_grid_display and also exporting the list to spreadsheet. But the problem is that during printout the last 2 columns are not getting displayed in excel.
So, is it possible that i can download to excel with, say, small font sizes.
2010 Jun 24 2:26 PM
HI,
think problem with the fieldcatlog.
uncomment the parameter like ref_tabname for all fields if you pass that.
2010 Jun 24 2:31 PM
Hi Inder,
Please see the link below:
[ABAP code snippet to upload Excel file into an internal table & display it in alv format |http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=60655105]
Regards,
Md Ziauddin.
2010 Jun 24 2:54 PM
Ziauddin,
the snippet in the link is from excel to internal table but i want from internal table to excel and also reduce the font size in excel as i am not getting all the columns while printing the list from excel.
Sreeram,
i tried to uncomment that parameter but thats not resolving the issue.
2010 Jun 24 4:50 PM
2010 Jun 29 12:15 PM
Read here: Happy reporting with Excel III: /people/otto.gold/blog/2010/06/23/happy-reporting-with-excel-iii-there-and-back
check also part 1 about OLE and part 2 about XML excel.
Regards Otto