Npoi Export excel--Lite version

You are welcome to spit on the water,

Today checked a day npoi of information, found on the internet are too big on, I summed up a version

Not much to say, directly on the code

 Public voidExporttoexceltwo (System.Data.DataTable DT,stringColtitle,stringFilePath) {Hssfworkbook WorkBook=NewHssfworkbook (); Hssfsheet sheet= (Hssfsheet) workbook.createsheet ("Sheet1"); Hssfrow Row1= (hssfrow) sheet. CreateRow (0); string[] titles = Coltitle.split (',');  for(inti =0; I < titles. Length; i++) {Hssfcell cell=(Hssfcell) row1.                Createcell (i, celltype.string); Cell.            Setcellvalue (Titles[i]); }             for(intj =0; J < dt. Rows.Count; J + +) {hssfrow rows= (hssfrow) sheet. CreateRow (j +1);  for(intK =0; K < dt. Columns.count; k++) {Hssfcell cells=(Hssfcell) rows.                    Createcell (k); Cells. Setcellvalue (dt. ROWS[J][K].                ToString ()); }            }            using(FileStream fs =NewFileStream (FilePath, FileMode.OpenOrCreate))            {workbook.write (FS); } GC.        Collect (); }

View Code

Npoi Export excel--Lite version