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 ...