Home » Developer & Programmer » Forms » Forms and Excel
Forms and Excel [message #418740] Tue, 18 August 2009 07:43 Go to next message
Messages: 6
Registered: July 2009
Junior Member
Hi All,

I am impoting data from excel to forms.
Usually there will be 3 sheets in the excel and you all know they are named as sheet1,sheet2 and sheet3.

My requirement is I want the name of the excel sheet that I'm importing.I want this name to be assigned to a variable.If for example I'm importing sheet1 I want the value sheet1 to be captured in a variable.

Can some tell me Is there any IN BUILT function by which we can get the name of the excel sheet.

Please reply as soon as possible.

[Updated on: Tue, 18 August 2009 07:50]

Report message to a moderator

Re: Forms and Excel [message #419763 is a reply to message #418740] Tue, 25 August 2009 08:53 Go to previous message
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

This might help.


Previous Topic: migration from oracle 9i forms to oracle 10g forms
Next Topic: can i use set-item-property in when-validate-item trigger ?
Goto Forum:

Current Time: Thu Oct 27 00:10:20 CDT 2016

Total time taken to generate the page: 0.11635 seconds