Tagged Questions
0
votes
1answer
116 views
ABAP GUI_DOWNLOAD issue where characters turned to decimal format E+
Program is using GUI_DOWNLOAD then save to excel file.
But upon opening the excel file, some cells which is expected to have sample value "1E9" is turned into data "1000000000" or "1.00E+09".
Sample ...
0
votes
1answer
181 views
Export EXCEL Workbook as PDF through SAP
I am using the ExportAsFixedFormat method of EXCEL, in order to export a workbook in PDF through SAP.
Desired outcome: I want to save the entire workbook, instead of saving only the active sheet.
...
0
votes
1answer
167 views
Excel Sheet created from ABAP using XML method throws error
I'm trying to create an excel sheet and send it as an inbox/email attachment from an SAP background process using the xml method. I'm following the code/method described here. I'm able to receive the ...
2
votes
0answers
83 views
ABAP HTTP Request Handler: Export data to Excel
I want to export data to an Excel file via HTTP Request. I have a class implementing the request handler interface.
I set the response body to something like:
"header1 \t header2 \t \n content1 \t ...
2
votes
1answer
444 views
Calling an excel macro with paramters from SAP ABAP
How can I call an excel macro with parameters from ABAP? I've found plenty of references for calling a macro without parameters online using the following method:
CALL METHOD OF obj_ex_APP 'Run'
...
1
vote
2answers
1k views
Multiple lines in same excel cell using OLE
I have some SAP OLE code that takes an internal table and pastes it into excel. However one field requires two lines within the same cell.
I've tried using CL_ABAP_CHAR_UTILITIES-NEWLINE and ...
0
votes
1answer
564 views
Passing data via OLE to existing Excel file - ABAP
I'm trying to export several tables to an Excel file using OLE.
Right now, I'm developing the hole file (merging cells, borders, shades, places, etc..).
But I already have an empty file. Is it ...
0
votes
1answer
323 views
Data migration from SAP to MySql
I just want my whole data in the SAP ABAP to be created in the MySql Workbench along with the table structure as a new database. I find phpmyadmin is not working for me. Also tried to download the ...
1
vote
0answers
915 views
SAP CRM read excel file to internal table [closed]
I need a functionality to upload an excel file and store the information in DB table. Till now I`m using cl_gui_frontend_services=>gui_upload( ) to read file content. Now I need to convert the content ...
1
vote
1answer
202 views
Date format into excel
I am trying to use BATCH Input for my record adding page,
But I cant receive the date format from excel it is always shown as '00000000'.
I tried those examples : 31.07.2012 20123007 20120730 and so ...