Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jun 24, 2010 at 01:26 PM

    HI,

    think problem with the fieldcatlog.

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2010 at 01: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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2010 at 01: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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 29, 2010 at 11:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded