Home » Developer & Programmer » Forms » Footer & headers in excel using ole2
Footer & headers in excel using ole2 [message #249135] Tue, 03 July 2007 08:21 Go to next message
srinivas.k2005
Messages: 334
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

Re: Footer & headers in excel using ole2 [message #249269 is a reply to message #249135] Tue, 03 July 2007 20:16 Go to previous messageGo to next message
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
Re: Footer & headers in excel using ole2 [message #249284 is a reply to message #249269] Tue, 03 July 2007 23:21 Go to previous messageGo to next message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
Thanks a lot....
Re: Footer & headers in excel using ole2 [message #250274 is a reply to message #249135] Mon, 09 July 2007 07:05 Go to previous messageGo to next message
srinivas.k2005
Messages: 334
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: Footer & headers in excel using ole2 [message #254783 is a reply to message #252782] Sat, 28 July 2007 03:29 Go to previous messageGo to next message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
No still i am searching for the solution.
Re: Footer & headers in excel using ole2 [message #255183 is a reply to message #254783] Mon, 30 July 2007 23:44 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Footer & headers in excel using ole2 [message #255552 is a reply to message #249135] Wed, 01 August 2007 03:30 Go to previous messageGo to next message
srinivas.k2005
Messages: 334
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
Re: Footer & headers in excel using ole2 [message #256060 is a reply to message #255552] Thu, 02 August 2007 21:07 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Footer & headers in excel using ole2 [message #256711 is a reply to message #249135] Mon, 06 August 2007 07:18 Go to previous messageGo to next message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
I have not solved.Client has pushed it to last priority
Re: Footer & headers in excel using ole2 [message #259541 is a reply to message #256711] Wed, 15 August 2007 22:38 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: updating using forms
Next Topic: Log on Screen in Forms 6/6i
Goto Forum:
  


Current Time: Mon Dec 05 08:38:05 CST 2016

Total time taken to generate the page: 0.10751 seconds