Application Development 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
Showing results for 
Search instead for 
Did you mean: 

Upload Excel Worksheets in background job

Former Member
0 Kudos

Hi,

How can i load data from Excel Worksheets to internal table from ABAP in background mode.

I load it from a job.

Thanks,

5 REPLIES 5

robert_altenstraer
Active Participant
0 Kudos

Hi

easiest way:

1. the user should save the xls as CSV file ( seperated by ; ( semicolon ) )

2. open dataset > read dataset > close dataset

bestreg Robert

0 Kudos

The problem is that there are multiple Worksheets in the excel file.

With the sentences OPEN DATASET, how do I open a particular Worksheet?

Thanks,

0 Kudos

You can't use excel functions in background.

You can read a excel file in background but SAP can't understand it .

Former Member
0 Kudos

I don think we have way to work with presentation server in background mode. Anyway check this [link|;.

Former Member
0 Kudos

Working in background with excel and application server is not possible i guess.

Regards,

Lalit Mohan Gupta.