NPOI是一个开源的C#读写Excel、WORD等微软OLE2组件文档的项目。使用 NPOI 可以在没有安装 Office 或者相应环境的机器上对 WORD/EXCEL 文档进行读写。
这里简单封装了一个使用NPOI导出Excel的DLL,方便项目使用。步骤如下:
1、NuGet包管理器添加对NPOI和log4net的安装引用
2、添加Excel属性信息类ExcelProperty.cs
/// <summary>
/// 用于定义导出的excel属性
/// </summary>
public class ExcelProperty
{
public ExcelProperty() { }
/// <summary>
/// 文件基本属性
/// </summary>
/// <param name="company">公司名称</param>
/// <param name="author">作者信息</param>
/// <param name="ApplicationName">创建程序信息</param>
/// <param name="Comments">填加xls文件备注</param>
/// <param name="title">填加xls文件标题信息</param>
/// <param name="Subject">填加文件主题信息</param>
public ExcelProperty(string company, string author, string applicationName, string comments, string title, string subject)
{
this.Company = company;
this.Author = author;
this.ApplicationName = applicationName;
this.Comments = comments;
this.Title = title;
this.Subject = subject;
}
/// <summary>
/// 公司名称
/// </summary>
private string company = "";
/// <summary>
/// 公司名称
/// </summary>
public string Company
{
get { return company; }
set { company = value; }
}
/// <summary>
/// 作者信息
/// </summary>
private string author = "";
/// <summary>
/// 作者信息
/// </summary>
public string Author
{
get { return author; }
set { author = value; }
}
/// <summary>
/// 创建程序信息
/// </summary>
private string applicationName = "";
/// <summary>
/// 创建程序信息
/// </summary>
public string ApplicationName
{
get { return applicationName; }
set { applicationName = value; }
}
/// <summary>
///填加xls文件备注
/// </summary>
private string comments = "";
/// <summary>
///填加xls文件备注
/// </summary>
public string Comments
{
get { return comments; }
set { comments = value; }
}
/// <summary>
/// 填加xls文件标题信息
/// </summary>
private string title = "";
/// <summary>
/// 填加xls文件标题信息
/// </summary>
public string Title
{
get { return title; }
set { title = value; }
}
/// <summary>
/// 填加文件主题信息
/// </summary>
private string subject = "";
/// <summary>
/// 填加文件主题信息
/// </summary>
public string Subject
{
get { return subject; }
set { subject = value; }
}
}