// 获取excel文件并存到列表里面 private void getExcelFile(string excelName, string codeName) { this.createFolder(this.excelPath); /* .xls文件 */ string xlsSet = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + this.excelPath + excelName + ";" + "Extended Properties='Excel 8.0;HDR=No;IMEX=1'"; /* .xlsx文件 */ string xlsxSet = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + this.excelPath + excelName + ";" + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\""; DataSet ds = new DataSet(); OleDbDataAdapter oada = new OleDbDataAdapter("select * from [Sheet1$]", xlsxSet); try { oada.Fill(ds); } catch (Exception e) { Console.WriteLine("\n" + excelName + "获取失败" + "\n"); return; } int rows = ds.Tables[0].Rows.Count; int cols = ds.Tables[0].Columns.Count; configAttributeArr.Clear(); var time1 = System.DateTime.Now; Console.WriteLine(" ----- 读取配置文件 " + excelName + " " + time1); for (int i = 0; i < rows; i++) { if (ds.Tables[0].Rows[i].ItemArray[0].ToString() == "") { break; } if (i >= 3) { ConfigAttribute configAttribute = new ConfigAttribute(); configAttribute.nameArr = new List <string>(); configAttribute.usedArr = new List <string>(); configAttribute.typeArr = new List <string>(); configAttribute.dataArr = new List <List <string> >(); List <string> list = new List <string>(); for (int j = 0; j < cols; j++) { string used = ds.Tables[0].Rows[2][j].ToString(); if (used == "s") { continue; } configAttribute.usedArr.Add(used); string name = ds.Tables[0].Rows[0][j].ToString(); configAttribute.nameArr.Add(name); string type = ds.Tables[0].Rows[1][j].ToString(); configAttribute.typeArr.Add(type); string data = ds.Tables[0].Rows[i][j].ToString(); list.Add(data); } configAttribute.dataArr.Add(list); configAttributeArr.Add(configAttribute); } } CreateClassFile.instance.createTxtFile(codeName); }