Skip to Content
0
Former Member
Oct 26, 2005 at 09:41 AM

Manipulating data in Excel inplace via ALV grids

152 Views

Hi everybody,

I want to create a report which displays data in an Excel file (Excel inplace).

To solve the problem I have created a custom layout and uplodaded it via the report BCALV_BDS_MAINTENANCE to the BDS. The written report loads the data into an ALV grid, opens Excel inplace and displays the data in the custom layout. This works fine but for one exception: You can only upload an internal table to the ALV grid, consequently no additional information about the selected data itself (e.g. given by a custom selection screen) can be presented in the grid. What I need is a way which adds strings to the excel file not in an internal table.

Is there a way to to this? Is this possible with ALV grids or do I have to use OLE?

Thanks in advance.

Greetings, Daniel