我觉得请问一下，Excel假如要上传入Database，必须先转为 DataTable吗?
我搜了一些材料全是先 Excel → DataTable → Database(sql)
我对DataTable并并不是很熟，这几天逐渐学，我想问一下有别的方式 吗?
如果有别的方式 请要我参照，麻烦了，感谢
下列就是我读Excel to DataTable
但是为了更好地确定，用Console.WriteLine读出是错码
模块是应用 NPOI
using System; using System.Data; using System.IO; using System.Text; using NPOI.HSSF.UserModel; using NPOI.SS.UserModel; using NPOI.XSSF.UserModel; namespace Excel_to_DataTable { class Program { static void Main(string[] args) { DataTable dt = new DataTable(); using(FileStream file = new FileStream(@"H:ying桌面上testLIST.xlsx", FileMode.Open,FileAccess.Read)) { IWorkbook workbook = null; workbook = new XSSFWorkbook(file); ISheet sheet = workbook.GetSheetAt(0); IRow row; row = sheet.GetRow(0); if (row != null) { for(int m = 0; m < row.LastCellNum; m ) { string cellvalue = row.GetCell(m).ToString(); dt.Columns.Add(cellvalue); } } for(int i = 1; i <= sheet.LastRowNum; i ) { System.Data.DataRow dr = dt.NewRow(); row = sheet.GetRow(i); if(row != null) { for(int j=0; j < row.LastCellNum; j ) { string cellvalue = row.GetCell(j).ToString(); dr[j] = cellvalue; } } dt.Rows.Add(dr); } file.Close(); foreach(DataRow roww in dt.Rows) { foreach (DataColumn col in dt.Columns ) { Console.WriteLine(roww[col]); } } Console.ReadLine(); } } }