Open excel sheet through program calculate value and fetch value in program

[Former Member]

Hi experts,

My requirement is to open a excel sheet while i execute a report,There is some calculation that i need to do in excel sheet and want to fetch the calculated value back in to my program.

Is there any way of doing so ?

Regards,

Kashyap

[naimesh_patel]

You can use the OLE to open the excel, perform the calculation and read the values from the cell.

Check [Blag|https://wiki.sdn.sap.com/wiki/x/nDk]'s blog [Excel OLE and ABAP - Create fancy reports|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13091] [original link is broken] [original link is broken] [original link is broken]; for using the OLE to Open Excle and set the values.

To get the Values back from the Excel, you can use the GET PROPERTY of Cell, like this:

      GET PROPERTY OF e_cell 'Value' = lf_string.

Regards,

Naimesh Patel