C#导出EXCEL

最新推荐文章于 2024-01-19 11:06:51 发布

qiyunlei

最新推荐文章于 2024-01-19 11:06:51 发布

阅读量542

点赞数

分类专栏： c#

本文链接：https://blog.csdn.net/qiyunlei/article/details/8900531

版权

c# 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class ex : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        doExport("e:\\zn.xls");
    }

    /**/
    /// <summary>
    /// 执行导出
    /// </summary>

/// <param name="strExcelFileName">要导出的文件名</param>

private void doExport(string strExcelFileName)

{
Excel.Application excel = new Excel.Application();

// Excel.Workbook obj=new Excel.WorkbookClass();
// obj.SaveAs("c:\zn.xls",Excel.XlFileFormat.xlExcel9795,null,null,false,false,Excel.XlSaveAsAccessMode.xlNoChange,null,null,null,null);\

        int rowIndex = 1;
        int colIndex = 0;
        excel.Application.Workbooks.Add(true);
        string[] tt = { "第一列", "第二列", "第三列" }; //标题数组
        string[] con = { "1", "2", "3"};               //内容数组

        foreach (string col in tt)   //生成标题
        {
            colIndex++;
            excel.Cells[1, colIndex] = col;
        }

        foreach (string row in con) //生成内容得到行
        {
            rowIndex++; //行标记
            colIndex = 0;//列标记
            foreach (string col in tt) //循环列
            {
                colIndex++;//列标记++
                excel.Cells[rowIndex, colIndex] = row.ToString();
            }
        }

excel.Visible = false;

excel.ActiveWorkbook.SaveAs(strExcelFileName + ".XLS", Excel.XlFileFormat.xlExcel9795, null, null, false, false, Excel.XlSaveAsAccessMode.xlNoChange, null, null, null, null, null);

        //wkbNew.SaveAs strBookName
        //excel.Save(strExcelFileName);
        System.Diagnostics.Process.Start(strExcelFileName + ".XLS");//打开指定文件

excel.Quit();
excel = null;

GC.Collect();//垃圾回收
}

}