OraFAQ Forum: Forms » Footer & headers in excel using ole2

Home » Developer & Programmer » Forms » Footer & headers in excel using ole2

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

Footer & headers in excel using ole2 [message #249135]

Tue, 03 July 2007 08:21

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi,

I am working with forms10g.
I have a requirement to generate the data into excel report
with headers and footers using ole2.

Thanks,
Srinivas

Report message to a moderator

Re: Footer & headers in excel using ole2 [message #249269 is a reply to message #249135]

Tue, 03 July 2007 20:16

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

try these links:
http://www.tek-tips.com/viewthread.cfm?qid=320647&page=51
http://www.tek-tips.com/viewthread.cfm?qid=896676&page=22
http://www.orafaq.com/forum/t/80716/0/
http://www.tek-tips.com/viewthread.cfm?qid=282292
http://glufke.net/oracle/viewtopic.php?p=19

Report message to a moderator

Re: Footer & headers in excel using ole2 [message #249284 is a reply to message #249269]

Tue, 03 July 2007 23:21

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Thanks a lot....

Report message to a moderator

Re: Footer & headers in excel using ole2 [message #250274 is a reply to message #249135]

Mon, 09 July 2007 07:05

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi,

I have a problem with excel sheets when i populate data
in sheets using ole2.
Default we will have three sheets.
Sheet1 Sheet2 Sheet3

But when i add a new sheet ,after generating data in 3
sheets.The sheet is getting added beside sheet3.
Like:
Sheet1 Sheet2 Sheet4 Sheet3

Please guide me how can i handle , so that the sheet will be
created after Sheet3.
Renaming will not help!!

Thanks,
Srinivas

[Updated on: Mon, 09 July 2007 07:06]

Report message to a moderator

Re: Footer & headers in excel using ole2 [message #252782 is a reply to message #250274]

Fri, 20 July 2007 00:08

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Re: Footer & headers in excel using ole2 [message #254783 is a reply to message #252782]

Sat, 28 July 2007 03:29

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

No still i am searching for the solution.

Report message to a moderator

Re: Footer & headers in excel using ole2 [message #255183 is a reply to message #254783]

Mon, 30 July 2007 23:44

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please confirm that the last command before the creation of Sheet4 was an action to Sheet3. Perhaps the last actioned command was an action on Sheet2.

David

Report message to a moderator

Re: Footer & headers in excel using ole2 [message #255552 is a reply to message #249135]

Wed, 01 August 2007 03:30

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

The last command option was on Sheet 3.The Data is populated on sheet 3 and the cursor is also on sheet 3.Then once i call for new sheet the new sheet is created behind sheet 3.
Thanks For your reply.

Srinivas

Report message to a moderator

Re: Footer & headers in excel using ole2 [message #256060 is a reply to message #255552]

Thu, 02 August 2007 21:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Does this mean that you have solved your problem or NOT solved the problem of 'sheet4' appearing between 'sheet2' and 'sheet3'?

David

Report message to a moderator

Re: Footer & headers in excel using ole2 [message #256711 is a reply to message #249135]

Mon, 06 August 2007 07:18

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

I have not solved.Client has pushed it to last priority

Report message to a moderator

Re: Footer & headers in excel using ole2 [message #259541 is a reply to message #256711]

Wed, 15 August 2007 22:38

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I don't believe that you can create a worksheet to the 'right' of an existing worksheet. Open Excel and see what happens. When you insert a row it goes ABOVE the current row. When you insert a column it goes to the LEFT of the current column. When you add a new worksheet it goes to the LEFT of the current worksheet. You will either have to work out the command to MOVE the worksheet to the right or have a 'spare' worksheet to the right of the workbook and do your insert to the left of it and then delete this unwanted worksheet.

David

Report message to a moderator

Previous Topic:	updating using forms
Next Topic:	Log on Screen in Forms 6/6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:57:57 CDT 2024