speed up process - OLE objects

[Former Member]

I have used OLE objects to move data from 5 ITAB to 5 sheets in a single XL file , i find it to be very slow process ,

is there any way to speed up the process.

Pls help to resolve.

[Former Member]

Hi,

Check the below link for Office Integration using the Spreadsheet Interface

i_oi_spreadsheet.

[http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCCIOFFI/BCCIOFFI.pdf|http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCCIOFFI/BCCIOFFI.pdf]

Check the below Demo programs for information on DOI.

SAPRDEMO_ACTIVEX_INTEGRATION Demonstration of ActiveX document integration

SAPRDEMO_DOI_BDS Demonstration for Using BDS In Office Integration

SAPRDEMO_ESUITE_SPREADSHEET Demonstration for eSuite Spreadsheet Integration

SAPRDEMO_ESUITE_WORDPROCESSOR Demonstration Program for eSuite Word Processor Integration

SAPRDEMO_FORM_INTERFACE Demonstration for Form Interface

SAPRDEMO_MAILMERGE_INTERFACE Demonstration for Mail Merge Interface

SAPRDEMO_MS_DEMO Program SAPRDEMO_MS_DEMO

SAPRDEMO_PIVOTINTERFACE Demonstration for Spreadsheet Interface

SAPRDEMO_SPREADSHEET_INTERFACE Demonstration for Spreadsheet Interface

SAPRDEMO_TABLES_IN_EXCEL Demonstration for Spreadsheet Interface

SAPRDEMO_WORD_NOTEPAD Demonstration for Spreadsheet Interface

SAPRDEMODOCUMENTCONTAINER Demo for OLE container control

SAPRDEMODOCUMENTCONTAINER2 Demonstration for OLE Container Control (Optimized)

SAPRDEMOEXCELINTEGRATION Demo for Excel97 integration

SAPRDEMOEXCELINTEGRATION2 Demonstration for Excel 97 Integration (Optimized)

SAPRDEMOLOTUS123INTEGRATION Demo for Lotus 1-2-3 integration (from Release 9)

SAPRDEMOOFFICEINTEGRATION Demo for Office integration

SAPRDEMORTFPROCESSING Demo for RTF-based word processing using Desktop Office Integratio

SAPRDEMOVIEWING Demonstration for Viewing Interface

SAPRDEMOVISIO50INTEGRATION Demonstration for Visio 5.0 Integration

SAPRDEMOWORD97INTEGRATION Demonstration for Word97 integration

SAPRDEMOWORDPROINTEGRATION Demonstration of WordPro98 integration

Also check the below links for more information on Desktop Office Integration.

ABAP Object Oriented SpreadSheet with "Unlimited" Power

http://www.sap-img.com/abap/abap-object-oriented-spreadsheet-with-unlimited-power.htm

How to Create Pivot Table in Excel using Desktop Office Integration

http://www.sap-img.com/abap/how-to-create-pivot-table-in-excel-using-desktop-office-integration.htm

Hope this helps.

Thanks,

Balaji

Edited by: Balaji Ganapathiraman on Mar 28, 2008 1:43 PM