c# - Excel 打印预览

Question

以下是我为 Excel 文档打印预览的代码。

编译成功。

但预览窗口不可见。任何机构都可以指出我的错误是什么。是否需要添加更多编码或 dll。

(注:文档包含数据)

        Excel.Application excelApp = new Excel.Application();

        Excel.Workbook wb = excelApp.Workbooks.Open(@"C:\\Documents and Settings\\Admin\\Desktop\\DoCoMo\\news5.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, 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();

Answer 1

您可能必须手动显示 Excel 窗口:

excelApp.Visible = true;

但是，我听说它们是与特定 Excel 版本相关的一些问题(它可能适用于某些人，而不适用于其他人)。