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!