Attemtping to Access More Than 256 Columns or 65536 Lines in Excel Using CLIENT_OLE2 fails with WUO-709 (Doc ID 1073649.1)

Last updated on APRIL 27, 2023

Applies to:

Symptoms

A Forms application is used to process MS Excel Sheets using WEBUTIL.CLENT_OLE2.
Accessing the first 256 columns (A to IV) goes fine, but any attempt to access columns IW and beyond with code such as:

.../...
args:=Client_OLE2.create_arglist;
Client_OLE2.add_arg(args, 1);
Client_OLE2.add_arg(args, 'IW');
cell:=Client_OLE2.get_obj_property(worksheet, 'Cells', args);
.../...

fails with:

WUO[getProperty()] Value of WUO_OLE2_GET_OBJ_PROPERTY_ARGS=
ERROR>WUO-709 [OleFunctions.get_obj_property_args()] Unable to get Property: Cells; Exception
com.jacob.com.ComFailException: Invoke of: Cells
Source:
Description:

Note: A similar error occurs for lines beyond 65 536.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.