Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

FORMAT Excel Colums using ABAP

Former Member

‎05-01-2009 6:56 AM

0 Kudos

Hi ,

I need to format excel rows and columns .

Ex: I need to add border to the entire table and not just the title .

I used CALL METHOD of wf_range 'BorderAround'

EXPORTING

  1. 1 = 1

  1. 2 = 4 .

This puts a box around the cell. What i want to do this for multiple cells and not handle it at for each cell.

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.

Please help

1 REPLY 1

Former Member

‎05-01-2009 8:27 AM

0 Kudos

Hi.

You can record macros in excel and look at generated visual basic code. Then you should convert it into ABAP code.