topic Re: layout change in Application Development and Automation Discussions

layout change

Former Member — Fri, 24 Aug 2007 06:46:15 GMT

my problem is..

in grid i have some data and edit some data in the grid itself

at runtime i change the layout from abap grid to excel layout.

in excel layout i have the edited data.

suppose

now i am in excel layout.i do some modification in data in excel itself.

at runtime i change the layout from excel layout to abap grid.

now in abap grid i don't have a edited data..

i want the data, for this what i want to do,

in excel i want to do any setting.

for that what to do ? can you please ..

please give me any idea reg this

Re: layout change

Former Member — Fri, 24 Aug 2007 08:12:32 GMT

Hi Selva,

In ALV grid, once you change the change the layout to Excel-Inplace, there is no way you can track the data back to the ALV grid - because the standard code only exports the data to excel ( does not have provision for sending the data back to calling prog).

If you are interested in Editing the data only then go for an editable ALV grid.

If your requirement is to update the data Excel in excel only - then you will have to take the pain of writing everything from the scratch - u can refer to FM XXL_FULL_API for this. It will help u in displaying an inplace excel sheet. As u r developing everything of ur own - you can send the data to excel in track back when its required.

I will suggest you to export the data to a flat file from ur grid, save that as CSV/XLS. In that case u will be able to edit the data using MS Excel. After that do a WS_UPLOAD to get the data from the edited flat file and update the ALV grid - this will take much lesses effort and u will be able to achieve what u want.

Cheers.

SKC

Re: layout change

Former Member — Fri, 24 Aug 2007 08:14:43 GMT

before switching back from excel layout to grid layout press the save button in excel.