| How to show spreadsheet data in forms [message #418519] |
Sun, 16 August 2009 23:22  |
shaz
Messages: 182
Registered: June 2009
|
Senior Member |
|
|
Hi Gurus,
My task is to show the data of excel sheet(a.xls) in the oracle form.
The spread sheet contains a maximum of 5 records and there are 4 fields.
Can anyone guide me?
|
|
|
|
|
|
| Re: How to show spreadsheet data in forms [message #419578 is a reply to message #418519] |
Mon, 24 August 2009 06:07  |
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
|
Senior Member |
|
|
you want to display it as spreadsheet or you mean the data in sheet .
if you want to display data from sheet in form :
1-save the sheet in CSV format
2-create external table with same struchture to read data from the sheet
3- create your form to display data from created external table
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
