topic Re: Open excel sheet through program calculate value and fetch value in program in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/open-excel-sheet-through-program-calculate-value-and-fetch-value-in-program/m-p/5580104#M1272624 <HTML><HEAD></HEAD><BODY><P>You can use the OLE to open the excel, perform the calculation and read the values from the cell.</P><P></P><P>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] <B>[original link is broken]</B> <B>[original link is broken]</B> <B>[original link is broken]</B>; for using the OLE to Open Excle and set the values.</P><P></P><P>To get the Values back from the Excel, you can use the GET PROPERTY of Cell, like this:</P><PRE><CODE> GET PROPERTY OF e_cell 'Value' = lf_string. </CODE></PRE><P></P><P>Regards,</P><P>Naimesh Patel</P></BODY></HTML> Mon, 18 May 2009 13:52:43 GMT naimesh_patel 2009-05-18T13:52:43Z Open excel sheet through program calculate value and fetch value in program https://community.sap.com/t5/application-development-and-automation-discussions/open-excel-sheet-through-program-calculate-value-and-fetch-value-in-program/m-p/5580103#M1272623 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>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.</P><P></P><P>Is there any way of doing so ?</P><P></P><P></P><P>Regards,</P><P>Kashyap</P></BODY></HTML> Mon, 18 May 2009 13:32:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-excel-sheet-through-program-calculate-value-and-fetch-value-in-program/m-p/5580103#M1272623 Former Member 2009-05-18T13:32:09Z Re: Open excel sheet through program calculate value and fetch value in program https://community.sap.com/t5/application-development-and-automation-discussions/open-excel-sheet-through-program-calculate-value-and-fetch-value-in-program/m-p/5580104#M1272624 <HTML><HEAD></HEAD><BODY><P>You can use the OLE to open the excel, perform the calculation and read the values from the cell.</P><P></P><P>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] <B>[original link is broken]</B> <B>[original link is broken]</B> <B>[original link is broken]</B>; for using the OLE to Open Excle and set the values.</P><P></P><P>To get the Values back from the Excel, you can use the GET PROPERTY of Cell, like this:</P><PRE><CODE> GET PROPERTY OF e_cell 'Value' = lf_string. </CODE></PRE><P></P><P>Regards,</P><P>Naimesh Patel</P></BODY></HTML> Mon, 18 May 2009 13:52:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-excel-sheet-through-program-calculate-value-and-fetch-value-in-program/m-p/5580104#M1272624 naimesh_patel 2009-05-18T13:52:43Z