View Post

批量導入數據.net

源網址：http://Exceldatareader.codeplex.com/

參考如下：

NUGET引用

Note

Please try the latest source from the repo before reporting issues as there have been recent changes.Also, if you are reporting an issue it is really useful if you can supply an example excel file as this makes debugging much easier and without it we may not be able to resolve any PRoblems.

How to use

C# code :

FileStream stream = File.Open(filePath, FileMode.Open, Fileaccess.Read);//1. Reading from a binary Excel file ('97-2003 format; *.xls)IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);//...//2. Reading from a Openxml Excel file (2007 format; *.xlsx)IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);//...//3. DataSet - The result of each spreadsheet will be created in the result.TablesDataSet result = excelReader.AsDataSet();//...//4. DataSet - Create column names from first rowexcelReader.IsFirstRowAsColumnNames = true;DataSet result = excelReader.AsDataSet();//5. Data Reader methodswhile (excelReader.Read()){//excelReader.GetInt32(0);}//6. Free resources (IExcelDataReader is IDisposable)excelReader.Close();

VB.NET Code:

Dim stream As FileStream = File.Open(filePath, FileMode.Open, FileAccess.Read)'1. Reading from a binary Excel file ('97-2003 format; *.xls)Dim excelReader As IExcelDataReader = ExcelReaderFactory.CreateBinaryReader(stream)'...'2. Reading from a OpenXml Excel file (2007 format; *.xlsx)Dim excelReader As IExcelDataReader = ExcelReaderFactory.CreateOpenXmlReader(stream)'...'3. DataSet - The result of each spreadsheet will be created in the result.TablesDim result As DataSet = excelReader.AsDataSet()'...'4. DataSet - Create column names from first rowexcelReader.IsFirstRowAsColumnNames = TrueDim result As DataSet = excelReader.AsDataSet()'5. Data Reader methodsWhile excelReader.Read()  'excelReader.GetInt32(0);End While'6. Free resources (IExcelDataReader is IDisposable)excelReader.Close()