如果我使用Microsoft.Office.Interop.Excel，如何在客户端pc中保存xsl文件

Question

当我在个人电脑上工作时，下面的代码运行良好，xsl将保存在指定的路径中。但是，当应用程序托管时，在保存xsl文件的过程中，我会收到如下错误消息HRESULT异常：0x800A03EC

请告诉我如何在客户端pc中保存xsl文件。我需要修改我的代码。？？？

  public void Convertoxsl(DataSet ds)
        {
            Application ExcelApp = new Application();
            Workbook ExcelWorkBook = null;
            Worksheet ExcelWorkSheet = null;
            string FileName = string.Empty;
            ExcelApp.Visible = true;
            ExcelWorkBook = ExcelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
            List<string> SheetNames = new List<string>();
            string sn = ddlPageName.SelectedItem.Text;
            SheetNames.Add(sn);

            try
            {
                int getcol = 0;
                for (int i = 1; i < ds.Tables.Count; i++)
                    ExcelWorkBook.Worksheets.Add(); //Adding New sheet in Excel Workbook
                for (int i = 0; i < ds.Tables.Count; i++)
                {
                    int r = 1; // Initialize Excel Row Start Position  = 1
                    ExcelWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)ExcelWorkBook.Worksheets[i + 1];
                    //Writing Columns Name in Excel Sheet
                    for (int col = 1; col <= ds.Tables[i].Columns.Count; col++)
                    {
                        if (ds.Tables[i].Columns.Count != 3)
                        {
                            return;
                        }
                        ExcelWorkSheet.Cells[r, col] = ds.Tables[i].Columns[col - 1].ColumnName;
                        getcol = col;
                    }

                       r++;

                    //Writing Rows into Excel Sheet
                    for (int row = 0; row < ds.Tables[i].Rows.Count; row++) //r stands for ExcelRow and col for ExcelColumn
                    {
                        // Excel row and column start positions for writing Row=1 and Col=1
                        for (int col = 1; col <= ds.Tables[i].Columns.Count; col++)
                            ExcelWorkSheet.Cells[r, col] = ds.Tables[i].Rows[row][col - 1].ToString();

                        r++;
                    }
 ExcelWorkSheet.Name = SheetNames[i];//Renaming the ExcelSheets

            }

           string dirPageName = D:projectPath;
           FileName =dirPageName +abc + ".xlsx";

            if (!Directory.Exists(dirPageName))
            {
                Directory.CreateDirectory(dirPageName);
            }
            if (File.Exists(FileName))
            {
                File.Delete(FileName);
            }

            ExcelWorkBook.SaveAs(FileName);
            ExcelWorkBook.Close();
            ExcelApp.Quit();
            Marshal.ReleaseComObject(ExcelWorkSheet);
            Marshal.ReleaseComObject(ExcelWorkBook);
            Marshal.ReleaseComObject(ExcelApp);
            ltMessage.Text ="File Successfully exported";
            ltMessage.Visible = true;


        }
        catch (Exception exHandle)
        {

            ltMessage.Text = exHandle.Message;
            ltMessage.Visible = true;
        }
        finally
        {
            foreach (Process process in Process.GetProcessesByName("Excel"))
                process.Kill();
        }
    }

Answer 1

HRESULT:0x800A03EC是一个未知（对VB.Net而言）COM错误。当Excel因为您的输入或参数错误或不起作用而抛出一些错误时，通常会发生这种情况。

还要仔细检查错误细节。在我的案例中，Data部分有一个Item，它为我提供了Excel抛出的确切错误的线索。

@欧文说：IIS用户帐户必须拥有写入文件的权限。在以下文章中搜索0x800A03EC，How to Create Excel file in ASP.NET C#