Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > General

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 01-02-2001, 01:15 AM
N/A
Guest
 
Posts: n/a
Default Adding a header to an Excel document

Does anybody know how to add a header to a excel2000 doc, with delphi?
Reply With Quote
  #2  
Old 01-02-2001, 01:49 AM
N/A
Guest
 
Posts: n/a
Default RE: Adding a header to an Excel document

I don't know
Reply With Quote
  #3  
Old 01-08-2001, 11:34 AM
MrBaseball34 MrBaseball34 is offline
Senior Member
 
Join Date: Jan 2001
Posts: 7,260
Default RE: Adding a header to an Excel document

First look at this site to get afeeling of how to load an Excel docuemnt using the Delphi components:

http://www.djpate.freeserve.co.uk/AutoExcl.htm

Then to set the header, you need an ExcelWorksheet object
that is connected to your worksheet. You then access the
page headers through the PageSetup object with the
LeftHeader, CenterHeader and RightHeader properties of
the PageSetup object.

The footers can also be done in a similar manner using
LeftFooter, etc...

ExcelWorkshet1.PageSetup.CenterHeader := 'Blah';
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT. The time now is 08:49 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.