topic OLE Excel object-Selecting Range in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/ole-excel-object-selecting-range/m-p/6315229#M1393427 <HTML><HEAD></HEAD><BODY><P>Hi Experts</P><P></P><P>I am importing result into one excel sheet and I am making it auto fit using OLE objects. I am facing the problem to select the range of columns and set the format as text. I am trying to in different ways but failing at selecting the range.</P><P></P><PRE><CODE>CALL METHOD OF book 'WORKSHEETS' = sheets. CALL METHOD OF excel 'CELLS' = cell. CALL METHOD OF cell 'EntireColumn' = ole_columns . CALL METHOD OF ole_columns 'AutoFit'. call METHOD of excel 'COLUMNS' = columns. set PROPERTY OF columns 'RANGE' = 'A:K'. CALL METHOD of columns 'SELECTION' = selection. CALL METHOD of selection 'NUMBERFORMAT' = numberfor. set PROPERTY OF numberfor 'NUMBERFORMAT' = '@'. </CODE></PRE><P></P><P>Could you please correct me where I am going wrong.</P><P></P><P>Thanks</P><P>Praveen</P></BODY></HTML> Mon, 02 Nov 2009 03:55:26 GMT praveen_hannu 2009-11-02T03:55:26Z OLE Excel object-Selecting Range https://community.sap.com/t5/application-development-and-automation-discussions/ole-excel-object-selecting-range/m-p/6315229#M1393427 <HTML><HEAD></HEAD><BODY><P>Hi Experts</P><P></P><P>I am importing result into one excel sheet and I am making it auto fit using OLE objects. I am facing the problem to select the range of columns and set the format as text. I am trying to in different ways but failing at selecting the range.</P><P></P><PRE><CODE>CALL METHOD OF book 'WORKSHEETS' = sheets. CALL METHOD OF excel 'CELLS' = cell. CALL METHOD OF cell 'EntireColumn' = ole_columns . CALL METHOD OF ole_columns 'AutoFit'. call METHOD of excel 'COLUMNS' = columns. set PROPERTY OF columns 'RANGE' = 'A:K'. CALL METHOD of columns 'SELECTION' = selection. CALL METHOD of selection 'NUMBERFORMAT' = numberfor. set PROPERTY OF numberfor 'NUMBERFORMAT' = '@'. </CODE></PRE><P></P><P>Could you please correct me where I am going wrong.</P><P></P><P>Thanks</P><P>Praveen</P></BODY></HTML> Mon, 02 Nov 2009 03:55:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/ole-excel-object-selecting-range/m-p/6315229#M1393427 praveen_hannu 2009-11-02T03:55:26Z Re: OLE Excel object-Selecting Range https://community.sap.com/t5/application-development-and-automation-discussions/ole-excel-object-selecting-range/m-p/6315230#M1393428 <HTML><HEAD></HEAD><BODY><P>small issue while accessing the cells, actual method is </P><P>call METHOD of excel 'RANGE' = columns EXPORTING #1 = 'A:K'.</P><P> set PROPERTY OF columns 'NUMBERFORMAT' = '@'.</P></BODY></HTML> Mon, 02 Nov 2009 07:35:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/ole-excel-object-selecting-range/m-p/6315230#M1393428 praveen_hannu 2009-11-02T07:35:19Z