Is there any way to programmatically create an Excel spreadsheet defining a column with "wrap text" format? I have...
searched the SAP library, but the results were discouraging.
In Excel VBA, to set a column, e.g., D to "Wrap Text", you use:
Columns("D:D").WrapText = True
To do this in ABAP, you'd need to create an OLE Excel object, using (omitting definitions) something like:
CREATE OBJECT o_wks 'Excel.Application' NO FLUSH. GET PROPERTY OF o_wks 'Range' = o_rng1 NO FLUSH exporting #1 = 'D:D'. SET PROPERTY OF o_rng1 'WrapText' = '1'.
Dig Deeper on SAP workflow development
Related Q&A from Matthew Billingham
An SAP user needs information on how to change the password on several SAP user accounts from a central location. Continue Reading
An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header. Continue Reading
An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order. Continue Reading