-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Re: format column using ole.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
format column using ole.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2009 Jul 13 11:50 AM
- SAP Managed Tags
- ABAP Development
I want to format cell column to type 'Text' using OLE.
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2009 Jul 13 12:11 PM
- SAP Managed Tags
- ABAP Development
Hi Neelambari,
use this code snippet.
data : l_gs_excel TYPE ole2_object,
l_gs_cells TYPE ole2_object.
CREATE OBJECT l_gs_excel 'EXCEL.APPLICATION'.
CALL METHOD OF l_gs_excel 'Range' = l_gs_cells
EXPORTING
#1 = 'A1'.
CALL METHOD OF l_gs_cells 'Select' .
SET PROPERTY OF l_gs_cells 'NumberFormat' = '@'.
Amitava
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2009 Jul 13 12:11 PM
- SAP Managed Tags
- ABAP Development
Hi Neelambari,
use this code snippet.
data : l_gs_excel TYPE ole2_object,
l_gs_cells TYPE ole2_object.
CREATE OBJECT l_gs_excel 'EXCEL.APPLICATION'.
CALL METHOD OF l_gs_excel 'Range' = l_gs_cells
EXPORTING
#1 = 'A1'.
CALL METHOD OF l_gs_cells 'Select' .
SET PROPERTY OF l_gs_cells 'NumberFormat' = '@'.
Amitava
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2009 Jul 13 12:14 PM
- SAP Managed Tags
- ABAP Development
hi neelambari,
you can use this snippet written by me
https://wiki.sdn.sap.com/wiki/display/Snippets/OLEprogramforconvertingtomultitabexcel
cheers
s.janagar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2009 Jul 13 12:21 PM
Bluesky