Skip to Content
avatar image
Former Member

SAP OLE to Excel - Record miss problem

Hi Experts

I am using SAP OLE to transfer records from SAP to multiple sheets of Excel.

Everything is going fine, except that randomly some records get missed while transferring to MS-Excel. This is the problem. However, the same program works pretty smoothly without any hitch when using Open Source platform like WPS Office. If there was any problem with the SAP code, nothing would have got transferred.

Is there anything amiss?

Many thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 22, 2017 at 08:18 AM

    Did you manage the sy-subrc value in each and every call of an OLE method in your code, would be you first step to analyze the problem. Which options did you use in automation methods, some NO FLUSH or QUEUE-ONLY, did you use FM FLUSH, etc.

    You should really provide more information. Alas the assertion that if it works with a product like open office then it should work with another as MS Office is often false, also often false with different versions of the same product. So the try, check, correct loops are required, and collection of error code is required in the code.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi.. your statement that "it works with a product like open office then it should work with another as MS Office is often false" was spot on. There was something missing in my code, which I resolved. Now stuck at something different though :)

  • Sep 22, 2017 at 06:30 AM

    There was no such issue with OLE in SAP for decades, so I would first blame a bug in your program. If there would be a bug in SAP standard, then you should reproduce/identify clearly where the error is, and contact the SAP support.

    Add comment
    10|10000 characters needed characters exceeded