Default page oriantation to Landscape

[himanibhagwat]

Hi All,

In a .NET windows application using C#, I'm opening an existing excel worksheet using office interop, where in I get Excel.Application object, Workbook object etc. I want to set the default orienation to Landscape while this worksheet will be printed by user. I searched around a lot!! But din't find any object with which orientation property can be set to landscape through code.
Here is the piece of code used for opening the xls file:

Microsoft.Office.Interop.Excel.Application xlAppn = null;
xlAppn = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook curWorkBook = xlAppn.Workbooks.Open(fileName,
0, false, 5,
"", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindow s, "\t", true, false,
0, true, true, false);

Microsoft.Office.Interop.Excel.Sheets curSheets = curWorkBook.Worksheets;
_Worksheet curWorkSheet = (_Worksheet)curSheets.get_Item(1);



I do some modifications to the cells data after this, close it. And then MS excel is launched using,
System.Diagnostics.Process.Start(fileName);

Any help is highly appreciated!! Thanks in advance.

--Himani

[hashlock]

Short answer - use the PageSetup for a sheet:

using Excel = Microsoft.Office.Interop.Excel;
Excel._Worksheet oSheet;
oSheet.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape;

In the future, just load the Excel Interop dll into the VS object browser and do a search for whatever you're looking for.

ciao,

Hans

Hi All,

In a .NET windows application using C#, I'm opening an existing excel worksheet using office interop, where in I get Excel.Application object, Workbook object etc. I want to set the default orienation to Landscape while this worksheet will be printed by user. I searched around a lot!! But din't find any object with which orientation property can be set to landscape through code.
Here is the piece of code used for opening the xls file:

Microsoft.Office.Interop.Excel.Application xlAppn = null;
xlAppn = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook curWorkBook = xlAppn.Workbooks.Open(fileName,
0, false, 5,
"", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindow s, "\t", true, false,
0, true, true, false);

Microsoft.Office.Interop.Excel.Sheets curSheets = curWorkBook.Worksheets;
_Worksheet curWorkSheet = (_Worksheet)curSheets.get_Item(1);



I do some modifications to the cells data after this, close it. And then MS excel is launched using,
System.Diagnostics.Process.Start(fileName);

Any help is highly appreciated!! Thanks in advance.

--Himani