XLSX 转 DataSet
XLSX 转 DataSet
public DataSet XlsToDataSet(string vFilePath) { DataSet dataSet = new DataSet(); Stream stream = null; try { stream = File.OpenRead(vFilePath); HSSFWorkbook hssfworkbook = new HSSFWorkbook(stream); int numberOfSheets = hssfworkbook.NumberOfSheets; for (int i = 0; i < numberOfSheets; i++) { HSSFSheet hssfsheet = (HSSFSheet)hssfworkbook.GetSheetAt(i); DataTable dataTable = new DataTable(); dataTable.TableName = hssfsheet.SheetName; HSSFRow hssfrow = (HSSFRow)hssfsheet.GetRow(0); int lastCellNum = (int)hssfrow.LastCellNum; for (int j = (int)hssfrow.FirstCellNum; j < lastCellNum; j++) { DataColumn column = new DataColumn(hssfrow.GetCell(j).StringCellValue); dataTable.Columns.Add(column); } int lastRowNum = hssfsheet.LastRowNum; for (int j = hssfsheet.FirstRowNum + 1; j < hssfsheet.LastRowNum; j++) { HSSFRow hssfrow2 = (HSSFRow)hssfsheet.GetRow(j); DataRow dataRow = dataTable.NewRow(); for (int k = (int)hssfrow2.FirstCellNum; k < lastCellNum; k++) { dataRow[k] = hssfrow2.GetCell(k).ToString(); } dataTable.Rows.Add(dataRow); } dataSet.Tables.Add(dataTable); } } catch (Exception ex) { throw new Exception("Xls to DataSet: \n" + ex.Message); } finally { if (stream != null) { stream.Close(); } } return dataSet; }
本文来自博客园,作者:码农阿亮,转载请注明原文链接:https://www.cnblogs.com/wml-it/p/14731134.html
技术的发展日新月异,随着时间推移,无法保证本博客所有内容的正确性。如有误导,请大家见谅,欢迎评论区指正!
开源库地址,欢迎点亮:
GitHub:https://github.com/ITMingliang
Gitee: https://gitee.com/mingliang_it
GitLab: https://gitlab.com/ITMingliang
建群声明: 本着技术在于分享,方便大家交流学习的初心,特此建立【编程内功修炼交流群】,为大家答疑解惑。热烈欢迎各位爱交流学习的程序员进群,也希望进群的大佬能不吝分享自己遇到的技术问题和学习心得!进群方式:扫码关注公众号,后台回复【进群】。