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