C# 简单将数据导出到Excel模板流程

最新推荐文章于 2018-01-12 13:42:59 发布

原创最新推荐文章于 2018-01-12 13:42:59 发布 · 959 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#C# #Excel #ASP.NET

本文介绍如何使用Excel的API进行数据录入和文件保存，包括创建Application对象、打开文件、指定工作表、写入数据及保存文件的操作流程。

需引用以下：

using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;

private void btnSave_Click(object sender, EventArgs e)
        {
            if (this.tbfilePath.Text.Trim() == "")//获得文件保存路径
            {
                MessageBox.Show("保存路径不能为空！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            //创建Application对象
            Excel.Application app = new Excel.Application();
            app.Visible = true;
            //得到WorkBook对象, 下面的是打开已有的文件
            Excel.Workbook Book = app.Workbooks._Open(@"E:\模板.xls",//此处为绝对路径。
            Missing.Value, Missing.Value, Missing.Value, Missing.Value
            , Missing.Value, Missing.Value, Missing.Value, Missing.Value
            , Missing.Value, Missing.Value, Missing.Value, Missing.Value);

if (app == null)
{

return;

            }
            //指定要操作的Sheet
            Excel.Worksheet sheet = app.ActiveSheet as Excel.Worksheet; //默认的为sheet1
            //写入数据
            Excel.Range sno = sheet.get_Range("B3", Missing.Value);//填充到B3这个单元格
            sno.Value2 = "07055528";

Excel.Range sname = sheet.get_Range("D3", Missing.Value);
sname.Value2 = "ninjia";

Excel.Range classno = sheet.get_Range("F3", Missing.Value);
classno.Value2 ="07055521"

            //保存WorkBook
            string fileName = stuName+"_模板_" + System.DateTime.Now.ToShortDateString() + ".xls";//动态构造文件名
            string filePath = this.tbfilePath.Text.Trim();
            if (filePath.Substring(filePath.Length - 1, 1) != "\\")//如果路径结尾有\这不用加"\\"，'\'为转义字符
            {
                filePath = filePath + "\\";

}

            Book.SaveAs(@filePath + fileName,//另存为路径
            Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
            Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value,
            Missing.Value, Missing.Value);
            //关闭文件
            sheet = null;
            Book = null;
            app.Quit();
            app = null;
        }