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

namespace?ConsoleApplication1
{
????class?Program
????{
????????static?void?Main（string[]?args）
????????{
????????????//List?list?=?new?List（）;
????????????//list.Add（“333“）;
????????????//list.Add（“阿法士大夫“）;
????????????//list.Add（“23233232“）;
????????????//list.Add（“fasdfasfads“）;

????????????//string?s?=?string.Join（“?and?“?list）;
????????????//Console.WriteLine（s）;

????????????//dynamic?excel?=?Microsoft.VisualBasic.Interaction.Createobject（“Excel.Application“?string.Empty）;
????????????////excel.Visible?=?true;
????????????//excel.workbooks.Add（）;
?????????????????
????????????//dynamic?sheet?=?excel.ActiveSheet;

????????????//dynamic?headerCell?=?sheet.Cells[0?0];
????????????////把當前Grid中表頭信息賦值給Excel表頭.
????????????//headerCell.Value?=?“你好“;
????????????//headerCell.Font.Bold?=?true;//加粗
????????????//headerCell.Interior.Color?=?0xFF00;//設置背景顏色
?
???????????//Workbook工作簿，Sheet頁，row行，cell：單元格

//????????????HSSFWorkbook?hssfworkbook?=?new?HSSFWorkbook（）;
//????????????ISheet?sheet1?=?hssfworkbook.CreateSheet（“俺的第一頁“）;
//????????????IRow?rowHeader?=?sheet1.CreateRow（0）;//第i行
//????????????rowHeader.CreateCell（0?CellType.STRING）.SetCellValue（“傳智播客“）;
////xlsxlsx
//????????????IRow?row2?=?sheet1.CreateRow（1）;
//????????????row2.CreateCell（3?CellType.STRING）.SetCellValue（“fasdfasdfas“）;

//????????????using?（Stream?stream?=?File.OpenWrite（“d:/1.xls“））
//????????????{
//????????????????hssfworkbook.Write（stream）;
//????????????}
????????????//hssfworkbook.Write（

???????????//using（?Stream?stream?=?File.OpenRead（“d:/1.xls“））
???????????//{
???????????//????HSSFWorkbook?workbook?=?new?HSSFWorkbook（stream）;
???????????//????workbook.GetSheetAt（0）.GetRow（0）.GetCell（1）.StringCellValue;
???????????//}????????????

????????????//using?（SqlConnection?conn?=?new?SqlConnection（“Data?Source=.;?Initial?Catalog=HRMSYSDB;User?ID=hrmsa;Password=love@beijing“））
????????????//{
????????????//????conn.Open（）;
????????????//????using?（SqlCommand?cmd?=?conn.CreateCommand（））
????????????//????{
????????????//????????//只獲得表的架構信息（列信息）
????????????//????????cmd.CommandText?=?“select?top?0?*?from?T_Employee“;
????????????//????????DataSet?ds?=?new?DataSet（）;
????????????//????????SqlDataAdapter?adapter?=?new?SqlDataAdapter（cmd）;
????????????//????????adapter.FillSchema（dsSchemaType.Source）;//獲得表信息必須要寫
????????????//????????adapter.Fill（ds）;

????????????//????????DataTable?table?=?ds.Tables[0];
????????????//????????foreach?（DataColumn?col?in?table.Columns）
????????????//????????{
????????????//????????????Console.WriteLine（col.ColumnName+““+col.AllowDBNull+““+col.DataType）;
????????????//????????}
????????????//????}
????????????//}

????????????//string?s1?=?“aaa“

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

?????文件???????5120??2014-05-02?16:41??隨堂代碼\ConsoleApplication1\bin\Debug\ConsoleApplication1.exe

?????文件??????15872??2014-05-02?16:41??隨堂代碼\ConsoleApplication1\bin\Debug\ConsoleApplication1.pdb

?????文件??????11600??2014-04-26?20:53??隨堂代碼\ConsoleApplication1\bin\Debug\ConsoleApplication1.vshost.exe

?????文件????????490??2013-03-18?17:00??隨堂代碼\ConsoleApplication1\bin\Debug\ConsoleApplication1.vshost.exe.manifest

?????文件?????445440??2012-12-21?20:44??隨堂代碼\ConsoleApplication1\bin\Debug\Ionic.Zip.dll

?????文件????1443840??2012-12-21?20:44??隨堂代碼\ConsoleApplication1\bin\Debug\NPOI.dll

?????文件????2014019??2012-12-21?20:44??隨堂代碼\ConsoleApplication1\bin\Debug\NPOI.xml

?????文件???????3128??2012-12-21?20:49??隨堂代碼\ConsoleApplication1\ConsoleApplication1.csproj

?????文件?????445440??2012-12-21?20:44??隨堂代碼\ConsoleApplication1\Ionic.Zip.dll

?????文件????1443840??2012-12-21?20:44??隨堂代碼\ConsoleApplication1\NPOI.dll

?????文件????2014019??2012-12-21?20:44??隨堂代碼\ConsoleApplication1\NPOI.xml

?????文件???????3455??2014-05-02?16:41??隨堂代碼\ConsoleApplication1\obj\x86\Debug\ConsoleApplication1.csproj.FileListAbsolute.txt

?????文件??????36002??2014-05-02?16:41??隨堂代碼\ConsoleApplication1\obj\x86\Debug\ConsoleApplication1.csprojResolveAssemblyReference.cache

?????文件???????5120??2014-05-02?16:41??隨堂代碼\ConsoleApplication1\obj\x86\Debug\ConsoleApplication1.exe

?????文件??????15872??2014-05-02?16:41??隨堂代碼\ConsoleApplication1\obj\x86\Debug\ConsoleApplication1.pdb

?????文件???????6390??2014-06-07?15:36??隨堂代碼\ConsoleApplication1\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????3594??2012-12-23?11:08??隨堂代碼\ConsoleApplication1\Program.cs

?????文件???????1370??2012-12-21?19:55??隨堂代碼\ConsoleApplication1\Properties\AssemblyInfo.cs

?????文件??????25088??2014-05-02?16:41??隨堂代碼\HRMSys.DAL\bin\Debug\HRMSys.DAL.dll

?????文件??????65024??2014-05-02?16:41??隨堂代碼\HRMSys.DAL\bin\Debug\HRMSys.DAL.pdb

?????文件??????12800??2014-05-02?16:41??隨堂代碼\HRMSys.DAL\bin\Debug\HRMSys.Model.dll

?????文件???????7680??2014-05-02?16:41??隨堂代碼\HRMSys.DAL\bin\Debug\HRMSys.Model.pdb

?????文件???????2048??2012-12-23?11:41??隨堂代碼\HRMSys.DAL\DepartmentDAL.cs

?????文件??????12049??2012-12-23?17:44??隨堂代碼\HRMSys.DAL\EmployeeDAL.cs

?????文件???????2887??2012-12-23?17:51??隨堂代碼\HRMSys.DAL\HRMSys.DAL.csproj

?????文件???????1084??2012-12-18?11:50??隨堂代碼\HRMSys.DAL\IdNameDAL.cs

?????文件???????5859??2014-06-07?15:36??隨堂代碼\HRMSys.DAL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????2743??2014-05-02?16:41??隨堂代碼\HRMSys.DAL\obj\Debug\HRMSys.DAL.csproj.FileListAbsolute.txt

?????文件???????9059??2014-05-02?16:41??隨堂代碼\HRMSys.DAL\obj\Debug\HRMSys.DAL.csprojResolveAssemblyReference.cache

?????文件??????25088??2014-05-02?16:41??隨堂代碼\HRMSys.DAL\obj\Debug\HRMSys.DAL.dll

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