OraFAQ Forum: Forms » Forms and Excel

Home » Developer & Programmer » Forms » Forms and Excel

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Forms and Excel [message #418740]

Tue, 18 August 2009 07:43

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