4 Code reads Excel to DataSet (non-Excel component)

Toxyis the followingNpoiThe main purpose of this project is to solve the problem of extracting documents. Its supported formats include alldocx,xlsx,xls,CSV,vcardand so on. here is a simple but very practical example            
ParserContext c=new ParserContext (@ "D:\demo.xls"); var parser=parserfactory.createspreadsheet (c); var spreadsheet= Parser. Parse ();D ataset ds = spreadsheet. Todataset ();

This is the legend that can directlyExcel Workbookconverted intoDataSetthe code, fantastic bar!hereCreatespreadsheetSupportxlsand thexlsx, so you don't have to worry about this problem.
exceptWorkbookTurnDataSetOutside,Toxyalso supports theExcelone of the tables inside turns intoDataTable, sincetoxytableThere is a calltodatatablethe method, while aToxyspreadsheet(equivalent toExcel Workbook) can include multipletoxytable. with theToxy, extractExcelthe work of the data has become much simpler!  References

Official site:Toxy.CodePlex.com  
HTTP://blog.sina.com.cn/s/blog_701d1da40101h66g.htmlhttp://blog.sina.com.cn/s/blog_701d1da40101gi6m.html

4 Code reads Excel to DataSet (non-Excel component)