因为开发中很多时候都会用到Excel读写功能为了简化操作而设计的一个对Excel操作的简化抽象类
using Excel = Microsoft.Office.Interop.Excel;
/// <summary>
/// Excel 操作工具 For .Net Framework 4.0
/// </summary>
public abstract class AbstractExcelUtil
{
#region --- 内部字段 Begin ---
/// <summary>
/// Excel 程序载体
/// </summary>
Excel.Application excelApp = null;
/// <summary>
/// Excel 工作本
/// </summary>
Excel.Workbook excelWorkbook = null;
/// <summary>
/// Excel 单元表
/// </summary>
Excel.Worksheet excelWorksheel = null;
#endregion --- 内部字段 End ---
#region --- Ctor Begin ---
/// <summary>
/// 构造方法
/// </summary>
public AbstractExcelUtil()
{
}
#endregion --- Ctor End ---
#region --- 基本方法 Begin ---
/// <summary>
/// 创建 Excel 工作本
/// </summary>
protected void CreateWorkbook()
{
excelApp = new Excel.Application();
excelWorkbook = excelApp.Application.Workbooks.Add();
}
/// <summary>
/// 打开现有的 Excel 工作本
/// </summary>
/// <param name="filePath">工作本路径</param>
protected void OpenWorkbook(string filePath)
{
excelApp = new Excel.Applicatio