Skip to Content
0
Dec 20, 2013 at 12:32 PM

Problem using i_oi_container_control->get_ranges_data

218 Views

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