c#调用excel的打印预览页

来源:互联网 发布:手机淘宝如何升级版本 编辑:程序博客网 时间:2024/06/04 17:53
            Excel.Application excelApp = new Excel.Application();            //不可或缺            excelApp.Visible = true;                        Excel.Workbook wb = excelApp.Workbooks.Open("C:/test.xls", Type.Missing, Type.Missing,                                                                                        Type.Missing, Type.Missing,                                                                                        Type.Missing, Type.Missing,                                                                                        Type.Missing, Type.Missing,                                                                                        Type.Missing, Type.Missing,                                                                                        Type.Missing, Type.Missing);            Excel.Worksheet ws = (Excel.Worksheet)wb.Worksheets[1];            bool userDidntCancel = excelApp.Dialogs[Excel.XlBuiltInDialog.xlDialogPrintPreview].Show(                                        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,                                        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,                                        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,                                        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,                                        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,                                        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);            GC.Collect();            GC.WaitForPendingFinalizers();            wb.Close(false, Type.Missing, Type.Missing);            excelApp.Quit();

0 0