Home » Developer & Programmer » Forms » Forms and Excel
Forms and Excel [message #418740] Tue, 18 August 2009 07:43 Go to next message
paltoy
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
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

This might help.

http://forums.oracle.com/forums/thread.jspa?messageID=2346960&#2346960

http://forums.oracle.com/forums/thread.jspa?messageID=1210781&#1210781
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: Fri Dec 09 15:18:31 CST 2016

Total time taken to generate the page: 0.32977 seconds