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: 

How to set font size and font type for a column of excel sheet using OLE

Former Member

‎05-25-2011 7:06 AM

0 Kudos

Hi Experts !

Please can anyone let me know how to set the font size and font type

for a column or row in excel sheet using OLE to download excel file using OLE object

1 REPLY 1

Former Member

‎05-25-2011 3:44 PM

0 Kudos

Assuming you have created the Excel application object as V_EXCEL...


  DATA: V_CRANGE TYPE OLE2_OBJECT,
        V_FONT   TYPE OLE2_OBJECT.
...
* Set font for Column F
    CALL METHOD OF V_EXCEL 'Range' = V_CRANGE
                           EXPORTING #1 = 'F:F'.
    CALL METHOD OF V_CRANGE 'Select'.
    GET PROPERTY OF V_CRANGE 'font'    = V_FONT.
    SET PROPERTY OF V_FONT 'SIZE'      = 11.
    SET PROPERTY OF V_FONT 'NAME'      = 'Arial'.

* Set font for Row 5 - 8
    CALL METHOD OF V_EXCEL 'Range'     = V_CRANGE
                          EXPORTING #1 = '5:8'.        " Rows 5 - 8
    CALL METHOD OF V_CRANGE 'Select'.
    GET PROPERTY OF V_CRANGE 'font'    = V_FONT.
    SET PROPERTY OF V_FONT 'SIZE'      = 11.
    SET PROPERTY OF V_FONT 'NAME'      = 'Arial'.