pagesetup using OWC!!

[N. Shehzad]

All OWC experts,

Is there a way to programatically set the header/footer information on the
excel spreadsheet I created using OWC ? It seems like pagesetup is missing
from the Spreadsheet class object? What are my options

I will greatly appreciate your help.

Thank you.

N.Shehzad

 

[Alvin Bruney [ASP.NET MVP]]

Spreadsheets don't have headers and footers, they have rows and columns with
the what you call a rowheaders and column headers. These allows you some
customization.

--
Regards,
Alvin Bruney

Auther Plug
OWC Blackbook now on download at www.lulu.com/owc

 

[N. Shehzad]

I am talking about print page setup header and footer. The way you can set
those up on excel is by going to View --> Header/Footers - where you can any
information you want to print out on excel print page such as page number, or
heading. How to set that programtically on excel using OWC? That was possible
with excel automation such as:

With oActiveSheet.PageSetup

*.LeftHeader = ""
*.CenterHeader = ""
*.RightHeader = ""
.LeftFooter = "&BMy Footer goes here&B"
.CenterFooter = "&D"
.RightFooter = "Page &P"
*.PrintHeadings = .F.
.PrintGridlines = .F.
.CenterHorizontally = .T.
.CenterVertically = .F.
.Orientation = xlPortrait
endwith

Thanks

 

[N. Shehzad]

Does anyone has an answer to this?

thanks in advance!

 

[Alvin Bruney [ASP.NET MVP]]

Ok, that's still possible with a slightly modified syntax sp.activesheet (or
consult the object model for exact syntax).
--
Regards,
Alvin Bruney

Auther Plug
OWC Blackbook now on download at www.lulu.com/owc

 

[N. Shehzad]

I tried using that, but there is no pagesetup property, or any such property
that allows me to setup pagesetup information
It throws compilation error.
help!