topic Re: FORMAT Excel Colums using ABAP in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/format-excel-colums-using-abap/m-p/5542511#M1265709 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>You can record macros in excel and look at generated visual basic code. Then you should convert it into ABAP code.</P></BODY></HTML> Fri, 01 May 2009 07:27:18 GMT Former Member 2009-05-01T07:27:18Z FORMAT Excel Colums using ABAP https://community.sap.com/t5/application-development-and-automation-discussions/format-excel-colums-using-abap/m-p/5542510#M1265708 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I need to format excel rows and columns . </P><P>Ex: I need to add border to the entire table and not just the title .</P><P></P><P>I used CALL METHOD of wf_range 'BorderAround'</P><P> EXPORTING </P><P> </P><OL><LI level="1" type="ol"><P>1 = 1 </P></LI></OL><P> </P><OL><LI level="1" type="ol"><P>2 = 4 .</P></LI></OL><P></P><P>This puts a box around the cell. What i want to do this for multiple cells and not handle it at for each cell.</P><P></P><P>like if my range is E1 to F3 then border is around ever cell. A2 A3 F2 F2 and not just around A2 to F3.</P><P></P><P>Please help</P></BODY></HTML> Fri, 01 May 2009 05:56:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/format-excel-colums-using-abap/m-p/5542510#M1265708 Former Member 2009-05-01T05:56:36Z Re: FORMAT Excel Colums using ABAP https://community.sap.com/t5/application-development-and-automation-discussions/format-excel-colums-using-abap/m-p/5542511#M1265709 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>You can record macros in excel and look at generated visual basic code. Then you should convert it into ABAP code.</P></BODY></HTML> Fri, 01 May 2009 07:27:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/format-excel-colums-using-abap/m-p/5542511#M1265709 Former Member 2009-05-01T07:27:18Z