Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();

                         Type tp = app.GetType();

                         Microsoft.Office.Interop.Excel.Workbooks workBook = app.Workbooks;

                         Type elType = workBook.GetType();

                         object objelName = sourceFile;

                         Microsoft.Office.Interop.Excel.Workbook ebook = (Microsoft.Office.Interop.Excel.Workbook)elType.InvokeMember("Open", System.Reflection.BindingFlags.InvokeMethod, null, workBook, new Object[] { objelName, true, true });

                         Object missing = System.Reflection.Missing.Value;

                         for (int i = ; i < ebook.Worksheets.Count; i++)

                         {

                             Worksheet ws = ebook.Worksheets[i + ];

                             ws.PageSetup.Orientation = XlPageOrientation.xlPortrait;//页面方向竖向

                             ws.PageSetup.Zoom = false;

                             ws.PageSetup.FitToPagesWide = ;

                             ws.PageSetup.FitToPagesTall = false;

                         }

                         ebook.PrintOut(missing, missing, missing, missing, missing, true, missing, xpsFile);

                         tp.InvokeMember("Quit", System.Reflection.BindingFlags.InvokeMethod, null, app, null);

                         workBook.Close();

                         app.Quit();