Skip to Content
-1

Downloading Internal table data into Excel with column heading in bold(Other than OLE process)

Hi,

I have a requirement, where i have to download table data with header(in Bold) into excel sheet(to the path selected in popup) but without using OLE object process.

Thanks in Advane,

Harinath

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 27, 2017 at 08:01 AM

    Have a look at the excellent ABAP2XLSX project. It does what you're after and a whole lot more.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 07:32 AM

    Use XML-Spreadsheet and the Standard ABAP Classes that you can leverage (IF_XML / CL_IXML)...

    Please check :

    • SAP-Wiki with an XML-Tags example : link / link
    • Microsoft XML-Spreadsheet Reference : link
    • SAP-Wiki creating XML as Spreadsheet : link / link
    Add comment
    10|10000 characters needed characters exceeded

  • Jul 06, 2017 at 07:53 AM

    If you had searched, you would have found the answers. If I'd have spotted this question before decent answers were supplied, I would have rejected it. Please search before posting.

    There is a way of leveraging the CL_SALV_TABLE (and related classes) to create a simple excel sheet. I found a blog about it by searching. I suggest you do the same.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Matthew,

      I have searched the posts. But most of the posts suggest to use GUI_DOWNLOAD, which also solved my requirement with one part of it missing. Missing part is: In the downloaded excel, if any column is having text content with more than one line, then whole text content has to be displayed in the same cell. But, it is displaying in a new row, in the same column whihc should not happen. Any help would be great on this issue.

      Thanks in Advance.