How to Read Data from an EXCEL Spreadsheet into a Form Using Webutil Client_OLE2

(Doc ID 813535.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle Forms - Version 10.1.2 to 11.1.2.0.0 [Release 10.1.2 to 11g]
z*OBSOLETE: Microsoft Windows
Checked for relevance on 06-Jan-2014

Microsoft Windows
This demo has been tested with Forms 10.1.2.3 from Developer Suite 10gR2 using Webutil 10.1.2.3 with Microsoft Excel 2000.

***Checked for relevance on 03-Aug-2012***


Goal

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.

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms