My Oracle Support Banner

How to Read Data from an EXCEL Spreadsheet into a Form Using Webutil Client_OLE2 (Doc ID 813535.1)

Last updated on OCTOBER 26, 2023

Applies to:

Oracle Forms - Version 6.0.8 and later
z*OBSOLETE: Microsoft Windows
Microsoft Windows
This demo has been tested with Forms from Developer Suite 10gR2 using Webutil with Microsoft Excel 2000.


The goal is to read data into a Form from an Excel spread sheet on a windows client using Webutil Client_OLE2. The data can then be saved into the DB from the Form.

NOTE 1: This document and the examples contained are provided as is and are not supported by Oracle Support.

NOTE 2:  If you wish to read the Excel data from an Excel spread sheet on a Windows Application Server you will not need to use Webutil Client_OLE2. You could adapt this example just by moving the Excel Spread sheet to the Windows Application Server and changing the calls from Client_OLE2 to OLE2.

Note 3: Using Cient_ole2 has proved to be slow in certain environments. There are two other options that should make this faster:

option 1.  If the excel data can be converted to a comma delimited file (.csv file) then client_text_io can be used instead of client_OLE2.
option 2. If your server is windows and the excel file can be read from the server machine, OLE2 is a faster option.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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