OraFAQ Forum: Forms » SHEET1 AND SHEET2 IN EXCEL

Home » Developer & Programmer » Forms » SHEET1 AND SHEET2 IN EXCEL

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

SHEET1 AND SHEET2 IN EXCEL [message #475434]

Wed, 15 September 2010 02:12

ravig
Messages: 2
Registered: September 2010
Location: BANGALORE

Junior Member

HI,

HOW TO USE BOTH SHEET1 AND SHEET2 IN EXCEL USING 6i..

THANK U

Report message to a moderator

Re: SHEET1 AND SHEET2 IN EXCEL [message #475540 is a reply to message #475434]

Wed, 15 September 2010 09:06

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Please Explain your question in detail.

Report message to a moderator

Re: SHEET1 AND SHEET2 IN EXCEL [message #475589 is a reply to message #475434]

Thu, 16 September 2010 00:07

ravig
Messages: 2
Registered: September 2010
Location: BANGALORE

Junior Member

Hi Ranamirfan,

I need to generate a report that ve 2 different data . Data1 shoud come in sheet1 and in same workbook DAta2 should come in sheet2 ...

Thank u .

Report message to a moderator

Re: SHEET1 AND SHEET2 IN EXCEL [message #475592 is a reply to message #475589]

Thu, 16 September 2010 00:46

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Client_OLE2.add_arg(arg, 1); --active sheet

Client_OLE2.add_arg(arg, 'Sheet1'); --Point to sheet name

Client_OLE2.set_property(Worksheet,'Name', 'Newsheetname'); --rename sheet

Report message to a moderator

Previous Topic:	ORA-01422: exact fetch returns more than requested number of rows.
Next Topic:	Non-Equi Join In Oracle Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 11:19:08 CDT 2024