Identifying the excel row dynamically

[Former Member]

Hi Folks.

I am downloading the internal table data into an excel sheet by using cl_gui_frontend_services=>clipboard_export.But my internal table data is dynamically changing up .

Now the problem is that I need to bold the data (Some rows) in the excel sheet dynamically.Is there any formal way to proceed for this?

Identifying the Total row and formatting that particular row?

Any pointers in this regard are very much needful.

Regards,

SSR.

[naimesh_patel]

You need to use the OLE to achieve the formatting in Excel.

Check out this program for reference of OLE:

http://www.sap-img.com/abap/download-to-excel-with-format-border-color-cell-etc.htm

Regards,

Naimesh Patel