Skip to Content
0
Former Member
Dec 12, 2008 at 06:03 AM

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

13 Views

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