using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?NPOI.HSSF.UserModel;
using?NPOI.SS.UserModel;
using?NPOI.HSSF.Util;
using?System.Data;
using?System.IO;

namespace?MultiExcelOperation
{
????public?class?ExcelOperationhelper
????{
????????///?

????????///?讀取Excel保存為datatable
????????///?

????????///?Excel文件路徑
????????///?第幾行開始讀取
????????///?
????????public?static?DataTable?DoReadExcelDataTable（string?filePath?int?startRow）
????????{
????????????DataTable?dt?=?new?DataTable（）;


????????????if?（!File.Exists（filePath））
????????????{
????????????????return?dt;
????????????}


????????????HSSFWorkbook?workbook?=?null;


????????????HSSFSheet?sheet?=?null;


????????????FileStream?fs?=?new?FileStream（filePath?FileMode.Open?FileAccess.Read）;


????????????workbook?=?new?HSSFWorkbook（fs）;


????????????sheet?=?（HSSFSheet）workbook.GetSheetAt（0）;


????????????HSSFRow?row1?=?（HSSFRow）sheet.GetRow（startRow）;


????????????int?cellCount?=?row1.LastCellNum;


????????????//此處是讀取列名的，如果不需要列名則注釋此代碼
????????????for?（int?i?=?row1.FirstCellNum;?i?????????????{
????????????????DataColumn?columItem?=?new?DataColumn（row1.GetCell（i）.StringCellValue）;
????????????????dt.Columns.Add（columItem）;
????????????}


????????????int?rowCount?=?sheet.LastRowNum;


????????????for?（int?i?=?（sheet.FirstRowNum?+?1）;?i?<=?sheet.LastRowNum;?i++）
????????????{
????????????????HSSFRow?row?=?（HSSFRow）sheet.GetRow（i）;


????????????????DataRow?dtrow?=?dt.NewRow（）;


????????????????for?（int?j?=?row.FirstCellNum;?j?????????????????{
????????????????????if?（row.GetCell（j）?!=?null）
????????????????????{
????????????????????????dtrow[j]?=?row.GetCell（j）.ToString（）;
????????????????????}
????????????????}


????????????????dt.Rows.Add（dtrow）;
????????????}
????????????sheet?=?null;


????????????workbook?=?null;


????????????return?dt;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????144??2016-03-29?21:17??MultiExcelOperation\app.config

?????文件??????35328??2016-03-31?15:16??MultiExcelOperation\bin\Debug\MultiExcelOperation.exe

?????文件????????144??2016-03-29?21:17??MultiExcelOperation\bin\Debug\MultiExcelOperation.exe.config

?????文件??????50688??2016-03-31?15:16??MultiExcelOperation\bin\Debug\MultiExcelOperation.pdb

?????文件??????11600??2016-03-31?15:17??MultiExcelOperation\bin\Debug\MultiExcelOperation.vshost.exe

?????文件????????144??2016-03-29?21:17??MultiExcelOperation\bin\Debug\MultiExcelOperation.vshost.exe.config

?????文件????????490??2010-03-17?22:39??MultiExcelOperation\bin\Debug\MultiExcelOperation.vshost.exe.manifest

?????文件????1677824??2015-08-01?05:16??MultiExcelOperation\bin\Debug\NPOI.dll

?????文件?????472576??2015-08-01?05:16??MultiExcelOperation\bin\Debug\NPOI.OOxml.dll

?????文件?????467731??2015-08-01?05:16??MultiExcelOperation\bin\Debug\NPOI.OOxml.xml

?????文件??????90112??2015-08-01?05:16??MultiExcelOperation\bin\Debug\NPOI.Openxml4Net.dll

?????文件?????157387??2015-08-01?05:16??MultiExcelOperation\bin\Debug\NPOI.Openxml4Net.xml

?????文件????1928192??2015-08-01?05:16??MultiExcelOperation\bin\Debug\NPOI.OpenxmlFormats.dll

?????文件?????285696??2016-03-29?09:38??MultiExcelOperation\bin\Debug\試題庫-業(yè)務知識模塊-高速鐵路-車輛-成都動車段-轉向架地勤機械師.xls

?????文件??????93591??2016-03-31?14:08??MultiExcelOperation\bin\Debug\試題庫-業(yè)務知識模塊-高速鐵路-車輛-成都動車段-轉向架地勤機械師【判斷】.doc

?????文件??????86691??2016-03-31?14:08??MultiExcelOperation\bin\Debug\試題庫-業(yè)務知識模塊-高速鐵路-車輛-成都動車段-轉向架地勤機械師【單選】.doc

?????文件??????18413??2016-03-31?14:08??MultiExcelOperation\bin\Debug\試題庫-業(yè)務知識模塊-高速鐵路-車輛-成都動車段-轉向架地勤機械師【多選】.doc

?????文件????????423??2016-03-31?14:50??MultiExcelOperation\ClassDiagram1.cd

?????文件???????2200??2016-03-29?22:39??MultiExcelOperation\ExcelOperationhelper.cs

?????文件??????11891??2016-03-30?10:51??MultiExcelOperation\Form1.cs

?????文件???????6073??2016-03-30?10:51??MultiExcelOperation\Form1.Designer.cs

?????文件??????13498??2016-03-30?10:51??MultiExcelOperation\Form1.resx

?????文件??????20021??2016-03-31?15:16??MultiExcelOperation\FormExchangeExamItem.cs

?????文件??????15740??2016-03-31?15:16??MultiExcelOperation\FormExchangeExamItem.Designer.cs

?????文件??????13832??2016-03-31?15:16??MultiExcelOperation\FormExchangeExamItem.resx

?????文件????????176??2016-03-30?13:07??MultiExcelOperation\Model\AnalysisItem.cs

?????文件????????180??2016-03-30?13:04??MultiExcelOperation\Model\BlankFillingItem.cs

?????文件????????179??2016-03-30?13:07??MultiExcelOperation\Model\CompositionItem.cs

?????文件????????231??2016-03-30?13:07??MultiExcelOperation\Model\EssayItem.cs

?????文件????????182??2016-03-30?13:01??MultiExcelOperation\Model\MultipleChoiceItem.cs

............此處省略37個文件信息