cancel
Showing results for 
Search instead for 
Did you mean: 

Reg:Excel Applications Using Webdynpro

former_member197425
Active Participant
0 Kudos

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.........................

Accepted Solutions (1)

Accepted Solutions (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

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).

Answers (1)

Answers (1)

0 Kudos

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