Skip to Content
avatar image
Former Member

Reg:Excel Applications Using Webdynpro

Hi,

Can anyone please help me in solving this requirement.My requirement is in normal R/3 i can download data into excel from a report with colors and font everything using OLE concepts .But in Webdynpro how can i download the data into excel with colors and font as incase of OLE.

Please help in solving this issue.........................

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 25, 2008 at 12:37 PM

    Try using the ALV Component. There is a built-in Export to Excel functionality that uses the the Excel XML format. This allows you to retain much of the internal formatting of the table (font colors for instance).

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2013 at 11:00 PM

    Hello Thomas,

    We have same issue. We have developed report by WD ALV features, We have highlighted some of cell with colors depend upon the business logic in the report.

    When we are exporting those WD ALV report, color is not coming in excel file.We are using Microsoft Excel 2007. Please guide me in step wise to resolve this issue.

    Thanks in advance.

    Dilip Chaturvedi

    Add comment
    10|10000 characters needed characters exceeded