Excel文件讀取

private List<List<SqlParameter>> readDateXls(string tableName) { OleDbConnection myConn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:/DB.xls;Extended Properties=Excel 8.0;"); myConn.Open(); OleDbDataAdapter thisAdapter = new OleDbDataAdapter("SELECT * FROM [" + tableName + "$]", myConn); OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter); DataSet thisDataSet = new DataSet(); thisAdapter.Fill(thisDataSet, "ExcelInfo"); List<string> colName = new List<string>(); //一行目取り込み for (int i = 0; i < thisDataSet.Tables["ExcelInfo"].Columns.Count; i++) { if (!thisDataSet.Tables["ExcelInfo"].Columns[i].ToString().StartsWith("F")) { colName.Add(thisDataSet.Tables["ExcelInfo"].Columns[i].ToString()); //Debug.Write(thisDataSet.Tables["ExcelInfo"].Columns[i] + ",/t"); } } Debug.WriteLine("/n"); List<List<SqlParameter>> paramter = new List<List<SqlParameter>>(); //行繰り返す for (int i = 0; i < thisDataSet.Tables["ExcelInfo"].Rows.Count; i++) { int paraNum = 0; List<SqlParameter> para = new List<SqlParameter>(); //列繰り返す for (int j = 0; j < thisDataSet.Tables["ExcelInfo"].Columns.Count; j++) { string value = thisDataSet.Tables["ExcelInfo"].Rows[i][j].ToString(); if (!String.IsNullOrEmpty(value)) { para.Add(new SqlParameter("@" + colName[paraNum].ToLower(), value)); //Debug.Write(thisDataSet.Tables["ExcelInfo"].Rows[i][j]); //Debug.Write("/t"); paraNum++; } } paramter.Add(para); //Debug.WriteLine("/n"); } myConn.Close(); return paramter; }