How to Read Data from an EXCEL Spreadsheet into a Form Using Webutil Client_OLE2
Last updated on SEPTEMBER 07, 2017
Applies to:Oracle Forms - Version 10.1.2 to 220.127.116.11.0 [Release 10.1.2 to 11g]
z*OBSOLETE: Microsoft Windows
Checked for relevance on 06-Jan-2014
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***
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 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.
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