asked on 7/19/2008

Need to change the type of document in excel using C# to Landscape format.

I have to change the type of document in excel using C# to Landscape format.

Any help would be great.

.NET Programming Microsoft Excel C#

Last Comment

mathieu_cupryk

7/21/2008

irudyk

7/20/2008

How about trying something like:
Excel._Worksheet oSheet;
oSheet.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape;

mathieu_cupryk

7/20/2008

ASKER

What I need to do is setup the ledger

excelWorkSheet.PageSetup.PaperSize = Excel.XlPaperSize.xlPaper11x17;

This bombs on me.

irudyk

7/21/2008

Try using:
excelWorkSheet.PageSetup.PaperSize = Excel.XlPaperSize.xlPaperLedger;

mathieu_cupryk

7/21/2008

ASKER

still get an error.
see attached image.

7-21-2008-7-51-00-AM.gif

irudyk

7/21/2008

You are likely getting this error if the default printer you are attached to does not support Ledger size paper. Try changing your defualt printer to on that supports ledger size paper and retry to see if you get the error again.

ASKER CERTIFIED SOLUTION

irudyk

7/21/2008

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

mathieu_cupryk

7/21/2008

ASKER

First thing it should be set to legal then to fit on 1 page by 2 tall.
It needs a page break as well but crashes.

irudyk

7/21/2008

It needs to be set to "legal"? Do you mean landscape (per your orignal question)? You also list some more requirements, so for clarity, please completely outline exactly what you need done and include the portion of code your are using that is causing the errors.

mathieu_cupryk

7/21/2008

ASKER

I made a mistake it seems ok with the legal.