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 laterz*OBSOLETE: Microsoft Windows
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.
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
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
| Goal |
| Solution |
| References |