Excel未在C#中打开

本文关键字：未在 Excel | 更新日期: 2023-09-27 17:59:20

我试着打开excel，但它不起作用。。。。有人能帮我吗。。。。

        string path = Session["dir"].ToString() + "''" + e.CommandArgument.ToString();
        Excel.Application xlApp;
        Excel.Workbook xlWorkBook;
        Excel.Worksheet xlWorkSheet;
        object misValue = System.Reflection.Missing.Value;
        xlApp = new Excel.ApplicationClass();
        xlWorkBook = xlApp.Workbooks.Open(path, 0, true, 5, "", "", true,Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "'t", false, false, 0, true, 1, 0);
        xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
        xlWorkBook.Close(true, misValue, misValue);
        xlApp.Quit();
        releaseObject(xlWorkSheet);
        releaseObject(xlWorkBook);
        releaseObject(xlApp);

Excel未在C#中打开

代码尝试激活COM对象。需要检查的一件事是，为IIS中的应用程序池配置的用户在DCOM配置中是否具有启动和激活权限。

您是否尝试删除关闭并退出？如果没有帮助，请尝试以下操作：

// Start a new workbook in Excel.
        var excel = new Microsoft.Office.Interop.Excel.Application { Visible = true };
        var excelWorkBooks = (Microsoft.Office.Interop.Excel.Workbooks)excel.Workbooks;
        var workbookAdd = (Microsoft.Office.Interop.Excel._Workbook)excelWorkBooks.Add(); // XlWBATemplate.xlWBATWorksheet
        var worksheets = (Microsoft.Office.Interop.Excel.Sheets)workbookAdd.Worksheets;
        var sheet = (Microsoft.Office.Interop.Excel._Worksheet)worksheets.Item[1];
        sheet.Visible = XlSheetVisibility.xlSheetVisible;
相关文章：