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: 

Performance downloading data to Excel

carsten_srensen
Participant

‎01-08-2004 2:00 PM

0 Kudos

Hi experts.

I have programmed a nice ABAP program, that is used to extract all materials

in our system and write them to a Excel Sheet. Why have I prgrammed my own ABAP??

Because the Excel sheet consists of three tabs. And a lot of macroes.

The second tab holds the materials. The first tab, the user is able to create the data needed to

make reservations (via MB21)

That meens that I have also programmed a ABAP program that reads the Excel data.

So far so good.

The problem is PERFORMANCE!! When I am writing the Material Master data to the

excel, via Call Methods, it takes a VERY LONG TIME to write about 8000 rows!!

Does anyone have any good idea to speed up this process??

Best regards

And have a nice day

Carsten

5 REPLIES 5

dirk_feeken
Advisor
Advisor

‎01-09-2004 5:07 PM

0 Kudos

Do you use OLE automation to steer the Excel from within ABAP to fill the rows indivudually by single calls? Maybe it's faster to download the table at once to the file system in a simpe text format and upload it in excel again.

Just a guess, since I'm no expert and it's long ago that I played with this OLE stuff.

Dirk

sergey_korolev
Active Contributor
In response to dirk_feeken

‎01-12-2004 2:07 PM

0 Kudos

Also you might want to try DOI - Desktop Office Integration tools. This is a set of ABAP OO classes which can exchange data with Excel by bulk of data (not cell by cell). There some demo programs. DOI is available from 4.6.

Sergei

TMNielsen
Contributor

‎01-12-2004 2:13 PM

0 Kudos

Hello Carsten

I would like to give you a warning.

If you use OLE from a fancy ABAP program to build the excel with 3 sheets (tabs) and a lot of macrocs, - you will probably face some serius future problems.

The program will probably not work if you:

1) Upgrade your SAP system

2) Upgrade your excel (office)

My experience is that its better to just download simple data structures from SAP and than build the fancy stuff in EXCEL.

On a 46C or higher system,  I think I would do it with a combination of ALV and an excel template ( se transaction OAOR - Class = alvlayouttemplates - type = OT ).

With best regards

Thomas Madsen Nielsen