Skip to Content

Problem using i_oi_container_control->get_ranges_data

Hello,

I want to select specified worksheets from an excel-sheet by using the methods open_document,  get_spreadsheets_interface, get_sheets,

select_sheet, set_selection, insert_range and get_ranges_data of i_oi_container_control.

The whole process works fine when testing several excel-sheets which got more than one worksheet. But trying it on the excel-sheet for which the whole thing was created (with three worksheets) the program ends up in a total hang-up.

The problem starts within get_ranges_data: debugging shows me that the program hangs forever when calling 'OLE_FLUSH_CALL' (this cannot be debugged any further). The selected excel-sheet sits on my PC. When the hang-up is "active" I can see within task-manager that excel.exe has been started.

The whole thing can only be stopped by killing both SAP-GUI and Excel. Starting Excel again I get the information that an excel-sheet with a cryptical name (indeed it has the contents of my selected excel-sheet) has been recreated. Obviously this is the result of the hang-up. But there is no hint to the reason. All this only happens with one certain excel-sheet (unfortunately the one I need), others work fine.

Has anyone an idea what ist behind this problem?

We use SAP ECC 6.0 (no EHPs) on IBM-AIX, SAP-GUI 7.30 (Patch 5), Excel 2007 and Windows 7 64 bit.

Thanks a lot  and Merry Xmas!

Dietrich Kunze

Bayerische Versorgungskammer

Munich

Germany

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 22, 2013 at 09:37 AM

    Hi Dietrich,

    just check your excel, if you got any untypical charactes in. I got a similar problem some day and my solution was, to get into the file and convert all data to text.

    The reason, why it wasn't working was a cell, which wasn't converted in a proper type SAP could handle.

    Regards from Unterfranken😉

    Florian

    BTW: You put your question in the Adobe-space. You would get more help, if you move it to the ABAP-Space

    Add comment
    10|10000 characters needed characters exceeded