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

what is the best way to insert massive data into an existing excel file?

Former Member

‎12-12-2008 6:03 AM

0 Kudos

dear gurus,

i am wondering that what is the best way to insert massive data into an existing excel file, more performance perspective.

the file is read from BDS , and we want to insert data into it .

the way i can think of is

1. OLE AUTOMATION

i think performance will be a big problem

2. Office integration

i am not sure it's facing the same performance issue ?

3 . XXL_SIMPLE_API/FULL_API

I am not sure whether they can insert data into an existing excel file?

could you please give me some advices?

br.

jun

2 REPLIES 2

former_member223537
Active Contributor

‎12-12-2008 6:04 AM

0 Kudos

Hi,

If you want to APPEND data( add data to an existing excel file) from SAP, then use GUI_DOWNLOAD fm with APPEND = 'X' paramter.

Best regards,

Prashant

Former Member
In response to former_member223537

‎12-12-2008 6:07 AM

0 Kudos

thank you Prashant,

can we append the data into a specified sheet of the excel file?