Community
Application Development and Automation 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: 
Read only

ABAP reading Excel

Former Member

‎2007 Oct 04 4:28 PM

0 Likes
447

I have an Excel file created outside of SAP that needs to be read as input in a batch job (not in the SAPGUI), an Excel file.

Is it possible for an ABAP prograrm to read as input an Excel File?

I have an Excel file created outside of SAP that needs to be read as input in a batch job (not in the SAPGUI), an Excel file.

Is it possible for an ABAP prograrm to read as input an Excel File?

Reply
2 REPLIES 2
Read only

Former Member

‎2007 Oct 04 4:32 PM

0 Likes
415

No, in a batch job you cannot upload file from presentation server. So you can not use GUI_UPLOAD or any other excel file upload function module used to upload file from presentation server.

If the file is placed on Application server, you can use OPEN DATASET command and read the file.

Read only

Former Member

‎2007 Oct 04 4:33 PM

0 Likes
415

Hi Wardell Castles,

Try this function module to read Excel file from SAP Program <b>TEXT_CONVERT_XLS_TO_SAP</b>

Regards.

Ramesh.