Is there a FM to download internal table to spreadsheet with diff formating

[Former Member]

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.

[venkatasriram_mygapula]

HI,

think problem with the fieldcatlog.

uncomment the parameter like ref_tabname for all fields if you pass that.

[Former Member]

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.

[Former Member]

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.

[Former Member]

Use GUI_DOWNLOAD....

[OttoGold]

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