关于asp.net导出Excel出现“异常来自 HRESULT:0x800A03EC”错误解决方法

最新推荐文章于 2022-03-22 10:38:29 发布

wangqiuchen_Study

最新推荐文章于 2022-03-22 10:38:29 发布

阅读量7.1k

点赞数

分类专栏： Excel 文章标签： excel HRESULT0x800A03EC

本文链接：https://blog.csdn.net/wangqiuchen_Study/article/details/41891737

版权

Excel 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

        /// <summary>
        /// 导出Excel
        /// </summary>
        [TestMethod]
        public void ExportExcel()
        {
            string excelFileName = "E:\\IoTPlatform\\IoTPlatformSolution\\IoTPlatformUnitTest\\xml\\ceExcel";
string sql = @"select * from dbo.MonitorProjects where MonitorProjectName = 'textPN_4935'";
            mycon.Open();
            SqlDataAdapter myda = new SqlDataAdapter(sql, conStr);
            DataSet myds = new DataSet();
            myda.Fill(myds);
            Application excel = new Application();
            int rowIndex = 1;
            int colIndex = 0;
            excel.Application.Workbooks.Add(true);
            System.Data.DataTable table = myds.Tables[0];
            foreach (DataColumn dc in table.Columns)
            {
                colIndex++;
                excel.Cells[1, colIndex] = dc.ColumnName;
            }
            foreach (DataRow dr in table.Rows)
            {
                rowIndex++;
                colIndex = 0;
                foreach (DataColumn dc in table.Columns)
                {
                    colIndex++;
                    excel.Cells[rowIndex, colIndex] = dr[dc.ColumnName].ToString();
                }
            }
            excel.Visible = false;
            //Excel.XlFileFormat.xlWorkbookNormal与自己本机的版本要一致
            excel.ActiveWorkbook.SaveAs(excelFileName + ".xls", Excel.XlFileFormat.xlWorkbookNormal, null, null, false, false, Excel.XlSaveAsAccessMode.xlNoChange, null, null, null, null, null);
            excel.Quit();
            excel = null;
            GC.Collect();//垃圾回收
        }