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 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.
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