asp.net导出excel

导出数据到Excel文件

最新推荐文章于 2024-04-03 16:55:09 发布

转载最新推荐文章于 2024-04-03 16:55:09 发布 · 42 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/bluedy1229/articles/1314966.html

本文介绍了一种使用C#将DataTable中的数据导出到Excel文件的方法。此过程包括创建Excel应用程序实例、设置可见性、填充表格数据以及保存并关闭工作簿等步骤。

private void ExportExcel(System.Data.DataTable ds, string strExcelFileName)
        {
            object objOpt = Missing.Value;
            Excel.Application excel = new Excel.Application();
            excel.Visible = true;
            _Workbook wkb = excel.Workbooks.Add(objOpt);
            _Worksheet wks = (_Worksheet)wkb.ActiveSheet;

wks.Visible = XlSheetVisibility.xlSheetVisible;

int rowIndex = 1;
int colIndex = 0;

            System.Data.DataTable table = ds;
            foreach (DataColumn col in table.Columns)
            {
                colIndex++;
                excel.Cells[1, colIndex] = col.ColumnName;
            }

            foreach (DataRow row in table.Rows)
            {
                rowIndex++;
                colIndex = 0;
                foreach (DataColumn col in table.Columns)
                {
                    colIndex++;
                    excel.Cells[rowIndex, colIndex] = row[col.ColumnName].ToString();
                }
            }
            try
            {
                wkb.SaveAs(string.Format("{0}\{1}", System.Windows.Forms.Application.StartupPath, strExcelFileName), objOpt, null, null, false, false, XlSaveAsAccessMode.xlNoChange, ConflictOption.OverwriteChanges, null, null, null, null);

            }
            catch
            {
            }
            finally
            {
                wkb.Close(false, objOpt, objOpt);
                excel.Quit();
            }
        }

转载于:https://www.cnblogs.com/bluedy1229/articles/1314966.html