Knowledge Management

Question:
Hi,
I am using Excel OLE function to download data from ABAP directly into Excel. Although, Its preety fast when connected via 100bps network, the performance suffers significantly on dial up. ( almost 2 cells per second ).
Can anyone please give me any pointers towards improving the speed.
Thanks,
Kartik.
CODE :
LOOP A ITAB.
ASSIGN COMPONENT IDX OF ITAB TO <FS>
...
PERFORM FILL_CELL USING ....
......
ENDLOOP.
FORM FILL_CELL USING I J WERTE.
CALL METHOD OF GV_EXCEL 'CELLS' = GV_CELL EXPORTING #1 = I #2 = J.
SET PROPERTY OF GV_CELL 'VALUE' = WERTE.
ENDFORM.
Answer:
Export the data to the presentation server and use OLE call to open and format the file in Excel.
See this
discussion for details.
CaKe
Answer:
Thanks Cake for your suggestion!!
I guess some posts on this group have suggested rightly that new users must use search......... I used 'no flush' in my ole commands and Flushed everything at the end with the 'FREE OBJECT' command. The programs now downloads data to Excel very fast.
Thanks !!