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

namespace?SXLibrary
{
????public?class?ExcelObj
????{
????????///?

????????///?插入到excel的cell
????????///?

????????///?excel文件名
????????///?目標?（行，列，值）
????????///?默認sheetName可以不寫
????????public?static?void?WriteToExcelCell（string?fileName?Listject>>?customCell?string?sheetName?=?“sheet1“）
????????{
????????????NPOI.HSSF.UserModel.HSSFWorkbook?book?=?new?NPOI.HSSF.UserModel.HSSFWorkbook（）;
????????????NPOI.SS.UserModel.ISheet?sheet?=?book.CreateSheet（sheetName）;
????????????foreach?（var?item?in?customCell）
????????????{
????????????????int?r?=?item.Item1;
????????????????int?c?=?item.Item2;
????????????????object?content?=?item.Item3;
????????????????NPOI.SS.UserModel.IRow?row?=?null;
????????????????if?（sheet.GetRow（r）?==?null）
????????????????{
????????????????????row?=?sheet.CreateRow（r）;
????????????????}
????????????????else
????????????????{
????????????????????row?=?sheet.GetRow（r）;
????????????????}
????????????????NPOI.SS.UserModel.ICell?cell?=?row.CreateCell（c）;
????????????????cell.SetCellValue（content.ToString（））;
????????????????string?objType?=?content.GetType（）.ToString（）;
????????????????#region?類型轉換
????????????????switch?（objType）
????????????????{
????????????????????case?“System.String“://字符串類型
????????????????????????cell.SetCellValue（content.ToString（））;
????????????????????????break;
????????????????????case?“System.DateTime“://日期類型??
????????????????????????DateTime?dateV;
????????????????????????DateTime.TryParse（content.ToString（）?out?dateV）;
????????????????????????string?strtime?=?dateV.ToString（“yyyy-MM-dd?HH:mm:ss“）;
????????????????????????if?（strtime.Substring（11?8）?==?“00:00:00“）
????????????????????????{
????????????????????????????strtime?=?dateV.ToString（“yyyy-MM-dd“）;
????????????????????????}
????????????????????????cell.SetCellValue（strtime）;
????????????????????????break;
????????????????????case?“System.Boolean“://布爾型??
????????????????????????bool?boolV?=?false;
????????????????????????bool.TryParse（content.ToString（）?out?boolV）;
????????????????????????cell.SetCellValue（boolV）;
????????????????????????break;

????????????????????case?“System.Int16“://整型??
????????????????????case?“System.Int32“:
????????????????????case?“System.Int64“:
????????????????????case?“System.Byte“:
????????????????????????int?intV?=?0;
????????????????????????int.TryParse（content.ToString（）?out?intV）;
????????????????????????cell.SetCellValue（intV）;
????????????????????????break;
????????????????????case?“System.Decimal“://浮點型??
????????????????????case?“System.Double“:
????????????????????????double?doubV?=?0;
????????????????????????double.TryParse（content.ToString（）?out?doubV）

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

?????文件???????8704??2014-01-14?11:09??ExcelObj\ExcelObj\bin\Debug\ExcelObj.dll

?????文件??????17920??2014-01-14?11:09??ExcelObj\ExcelObj\bin\Debug\ExcelObj.pdb

?????文件????1600000??2014-01-14?11:07??ExcelObj\ExcelObj\bin\Debug\NPOI.dll

?????文件???????9114??2014-01-14?11:09??ExcelObj\ExcelObj\ExcelObj.cs

?????文件???????2688??2014-01-14?11:09??ExcelObj\ExcelObj\ExcelObj.csproj

?????文件????1600000??2014-01-14?11:07??ExcelObj\ExcelObj\NPOI.dll

?????文件???????5659??2014-01-14?11:09??ExcelObj\ExcelObj\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????308??2014-01-14?11:09??ExcelObj\ExcelObj\obj\Debug\ExcelObj.csproj.FileListAbsolute.txt

?????文件???????8704??2014-01-14?11:09??ExcelObj\ExcelObj\obj\Debug\ExcelObj.dll

?????文件??????17920??2014-01-14?11:09??ExcelObj\ExcelObj\obj\Debug\ExcelObj.pdb

?????文件???????7199??2014-01-14?11:09??ExcelObj\ExcelObj\obj\Debug\ResolveAssemblyReference.cache

?????文件???????1366??2014-01-14?11:06??ExcelObj\ExcelObj\Properties\AssemblyInfo.cs

?????文件????????914??2014-01-14?11:06??ExcelObj\ExcelObj.sln

????..A..H.?????14848??2014-01-14?11:10??ExcelObj\ExcelObj.suo

?????目錄??????????0??2014-01-14?11:06??ExcelObj\ExcelObj\obj\Debug\TempPE

?????目錄??????????0??2014-01-21?15:02??ExcelObj\ExcelObj\bin\Debug

?????目錄??????????0??2014-01-14?11:08??ExcelObj\ExcelObj\bin\Release

?????目錄??????????0??2014-01-21?15:02??ExcelObj\ExcelObj\obj\Debug

?????目錄??????????0??2014-01-21?15:02??ExcelObj\ExcelObj\bin

?????目錄??????????0??2014-01-14?11:06??ExcelObj\ExcelObj\obj

?????目錄??????????0??2014-01-21?15:02??ExcelObj\ExcelObj\Properties

?????目錄??????????0??2014-01-21?15:02??ExcelObj\ExcelObj

?????目錄??????????0??2014-01-21?15:02??ExcelObj

-----------?---------??----------?-----??----

??????????????3295344????????????????????23