using?System;
using?System.Collections;
using?System.Collections.Generic;
using?System.Data;
using?System.IO;
using?System.Linq;
using?System.Text;
using?NPOI.HPSF;
using?NPOI.HSSF.UserModel;
using?NPOI.HSSF.Util;
using?NPOI.OpenxmlFormats.Dml.Spreadsheet;
using?NPOI.SS.UserModel;
using?NPOI.SS.Util;
using?NPOI.XSSF.UserModel;

namespace?AT.ExcelOperator
{
????///?

????///?Excel操作方法
????///?

????public?class?ExcelHelper
????{
????????#region?公有變量

????????///?

????????///?Excel文件路徑
????????///?

????????public?string?FileName?{?get;?set;?}

????????///?

????????///?默認工作表名稱
????????///?

????????public?string?SheetName?{?get;?set;?}

????????#endregion

????????#region?私有變量

????????//工作薄
????????private?IWorkbook?workbook?=?null;

????????//sheet表
????????private?ISheet?sheet?=?null;

????????//文件流
????????private?FileStream?filestream?=?null;

????????//操作Excel文件的方式
????????private?ExcelOperateMode?operatetype;

????????//Excel類型
????????private?ExcelType?exceltype;
????????
????????#endregion

????????#region?構造函數
????????///?

????????///?構造函數
????????///?

????????///?Excel文件路徑
????????///?Sheet名稱
????????///?操作Excel方式（打開、創建）
????????public?ExcelHelper（string?strFileName?string?strSheetName?ExcelOperateMode?OperateType）
????????{
????????????FileName?=?strFileName;
????????????SheetName?=?strSheetName;
????????????operatetype?=?OperateType;
????????????exceltype?=?ExcelType.DEFAULT;
????????}
????????///?

????????///?構造函數
????????///?

????????///?Excel文件路徑
????????///?Sheet名稱
????????///?操作Excel方式（打開、創建）
????????///?Excel文件類型（兩種：XLSX，XLS）
????????public?ExcelHelper（string?strFileName?string?strSheetName?ExcelOperateMode?OperateType?ExcelType?pExcelType）
????????{
????????????FileName?=?strFileName;
????????????SheetName?=?strSheetName;
????????????operatetype?=?OperateType;
????????????exceltype?=?pExcelType;
????????}
????????#endregion

????????#region?Excel基本操作（新建、打開、保存、另存為、關閉）
????????///?

????????///?打開Excel文件
????????///?

????????///?打開成功返回true，打開失敗返回false
????????public?bool?Open（）
????????{
????????????bool?OK?=?false;
????????????try
????????????{
????????????????//1、以文件流的方式打開Excel
????????????????FileStream?fileStream?=?new?FileStream（FileName?FileMode.Open?FileAccess.ReadWrite）;
????????????????//2、初始化工作薄
????????????????InitializeWorkbook（fileStream）;
????????????????//3、獲取sheet
????????????????sheet?=?workbook.GetSheet（SheetName）;
????????????????//4、關閉文件流
????????????????fileStream.Close（）;
????????????????OK?=?true;
????????????}
????????????catch?（Except