读取EXCEL的办法
Excel 读取 办法
2023-09-27 14:28:13 时间
private void button9_Click(object sender, EventArgs e) { var folder =new FolderBrowserDialog(); if (folder.ShowDialog() == DialogResult.OK) { GetAllDirList(folder.SelectedPath); var SixCount = 0; var SevenCount = 0; var sixsb = new StringBuilder(); var sevensb = new StringBuilder(); for (var i = 0; i < fl.Count; i++) { var six = false; var seven = false; var fi = (FileInfo)fl[i]; var dataTable = ReadExcel(fi.FullName); for (var k = 0; k < dataTable.Rows.Count; k++) { if (dataTable.Columns.Count == 6) { var a0 = dataTable.Rows[k][0].ToString(); var a1 = dataTable.Rows[k][1].ToString(); var a2 = dataTable.Rows[k][2].ToString(); var a3 = dataTable.Rows[k][3].ToString(); var a4 = dataTable.Rows[k][4].ToString(); var a5 = dataTable.Rows[k][5].ToString(); if ((a0 == "") || (a1 == "") || (a2 == "") || (a3 == "") || (a4 == "") || (a5 == "")) { continue; } six = true; sixsb.Append(dataTable.Columns[0].ColumnName + " " + dataTable.Columns[1].ColumnName + " " + dataTable.Columns[2].ColumnName + " " + dataTable.Columns[3].ColumnName + " " + dataTable.Columns[4].ColumnName + " " + dataTable.Columns[5].ColumnName); sixsb.Append("\r\n"); sixsb.Append(a0 + " " + a1 + " " + a2 + " " + a3 + " " + a4 + " " + a5); sixsb.Append("\r\n"); } if (dataTable.Columns.Count == 7) { var a0 = dataTable.Rows[k][0].ToString(); var a1 = dataTable.Rows[k][1].ToString(); var a2 = dataTable.Rows[k][2].ToString(); var a3 = dataTable.Rows[k][3].ToString(); var a4 = dataTable.Rows[k][4].ToString(); var a5 = dataTable.Rows[k][5].ToString(); var a6 = dataTable.Rows[k][6].ToString(); if ((a0 == "") || (a1 == "") || (a2 == "") || (a3 == "") || (a4 == "") || (a5 == "") || (a6 == "")) { continue; } seven = true; sevensb.Append(dataTable.Columns[0].ColumnName + " " + dataTable.Columns[1].ColumnName + " " + dataTable.Columns[2].ColumnName + " " + dataTable.Columns[3].ColumnName + " " + dataTable.Columns[4].ColumnName + " " + dataTable.Columns[5].ColumnName + " " + dataTable.Columns[6].ColumnName); sixsb.Append("\r\n"); sevensb.Append(a0 + " " + a1 + " " + a2 + " " + a3 + " " + a4 + " " + a5 + " " + a6); sevensb.Append("\r\n"); } } if (six) SixCount++; if (seven) SevenCount++; Program.MyFrm.SetTextMessage("SixCount:" + SixCount); Program.MyFrm.SetTextMessage("SevenCount:" + SevenCount); Program.MyFrm.SetTextMessage("========以下为六个字段的信息======================================"); Program.MyFrm.SetTextMessage(sixsb.ToString()); Program.MyFrm.SetTextMessage("========以下为七个字段的信息======================================"); Program.MyFrm.SetTextMessage(sevensb.ToString()); } } } private static DataTable ReadExcel(string strFileName) { var book = new Workbook(strFileName); var sheet = book.Worksheets[0]; var cells = sheet.Cells; return cells.ExportDataTableAsString(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn + 1, true); } private static ArrayList fl = new ArrayList(); //我把ArrayList当成动态数组用,非常好用 private static void GetAllDirList(string strBaseDir) { fl.Clear(); var di = new DirectoryInfo(strBaseDir); var diA = di.GetDirectories(); var fiA = di.GetFiles();//获得了所有起始目录下的文件 for (var i = 0; i < fiA.Length; i++) { fl.Add(fiA[i]); } for (var i = 0; i < diA.Length; i++) { GetAllDirList(diA[i].FullName); } }
相关文章
- 解决POI读取Excel如何判断行是不是为空
- 破解Excel 工作表/薄密码
- 如何解决excel工作簿保护密码
- orcad元件属性批量修改(通过excel表格)
- C#中npoi操作Excel[版本2.0.1读写2003、2007格式]
- 读取excel数据报空指针
- silverlight中datagrid数据到处excel
- 零点起飞学Word与Excel高效办公实战与技巧
- Word/Excel/PPT 2016商务办公从入门到精通
- php excel 读取日期问题
- springmvc 使用poi解析excel并通过hibernate连续插入多条数据 实际数据库只能保存最后一条
- CxGrid如何实现导出Excel 功能
- Python xlwt数据保存到 Excel中以及xlrd读取excel文件画图
- EXCEL如何让表头不动 冻结表头
- Dynamics CRM 报表导出EXCEL 列合并问题的解决方法
- 怎么样excel其产生的条形码(10分钟的时间excel)从而出现了条形码
- unity读取excel表格中的单元格内容
- thinkphp thinkadmin使用phpspreadsheet批量导出excel数据
- 基于Java实现Json文件转换为Excel文件
- Java POI读取Excel文件中时间日期(date)和数据的方法及示例代码
- NPOI读取Excel文件
- Qt操作Excel--QtXlsx--编译与安装
- ASP.NET Core 导入导出Excel xlsx 文件
- Excel解析easyexcel工具类
- C#读取excel数据到datatable中
- 使用poi读写Excel