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: 

Excel Upload/Download

Former Member
0 Kudos

Hi

I have had a look through some of the posts in this forum on Excel and as I am new to ABAP I may be misunderstanding a few things.

Anyway, I am in a dilemma. We have a custom application written in ABAP, which at a given stage, we would like to write out a given set of values from a whole multitude of tables. I know where the data is. We need to map this to a formatted Excel document. The mappings are created. The second part of the dilemma is the Excel file will need to be picked up from the network (Windows file server) and the App Server is Unix.

Now, as far as I see it there are 2 ways of doing this, first is to write some ABAP code to upload the file, open it using OPEN DATASET (I think using the right unicode format), then push the data out using a mapping table.

The second way is to use Excel VBA to pull the data from SAP. Tricky bit still remains in how to initiate the macro.

If anyone can at least point me in the right direction, I would be most appreciated. Which would you recommend? Are there any potential pitfalls I need to be aware of?

Many thanks

Nick

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Look at these links

http://www.sapdevelopment.co.uk/file/file_updown.htm

http://www.sapdevelopment.co.uk/file/file_disall.htm

Hope this would be helpful.

Thanks & Regards,

Judith.

1 REPLY 1

Former Member
0 Kudos

Hi,

Look at these links

http://www.sapdevelopment.co.uk/file/file_updown.htm

http://www.sapdevelopment.co.uk/file/file_disall.htm

Hope this would be helpful.

Thanks & Regards,

Judith.