首页 > 其他 > 详细

Convert XLSX file to DataTable via NPOI

时间:2020-06-26 20:45:27      阅读:56      评论:0      收藏:0      [点我收藏+]
static DataTable ReadExcelConvertToDataTable(string xlsxFileName)
        {
            DataTable dt = new DataTable();
            try
            {
                IWorkbook book; 
                using (FileStream fs = new FileStream(xlsxFileName, FileMode.Open, FileAccess.Read))
                {
                    book = new XSSFWorkbook(fs);
                    ISheet st = book.GetSheetAt(0);
                    int rowsCount = st.LastRowNum; 
                    DataRow dtHeadersRow = dt.NewRow();
                    int colsCount = st.GetRow(0).Cells.Count();

                    var firstRow = st.GetRow(0);
                    for (int i = 0; i < colsCount; i++)
                    {
                        string colName = firstRow.GetCell(i).StringCellValue;
                        DataColumn dc = new DataColumn(colName);
                        dt.Columns.Add(colName);
                    }
                    dt.Rows.Add(dtHeadersRow);
                    for (int i = 0; i <= rowsCount; i++)
                    {
                        DataRow dr = dt.NewRow();                       
                        StringBuilder rowBuilder = new StringBuilder();
                        for (int j = 0; j < colsCount; j++)
                        {
                            ICell cell = st.GetRow(i).GetCell(j);
                            string cellValue = string.Empty;
                            if (cell != null)
                            {
                                switch (cell.CellType)
                                {
                                    case CellType.String:
                                        cellValue = cell.StringCellValue;
                                        break;
                                    case CellType.Numeric:
                                        cellValue = cell.NumericCellValue.ToString();
                                        break;
                                }
                            }
                            dr[j] = cellValue;
                        }
                        dt.Rows.Add(dr);                        
                    }
                }
            }
            catch(Exception ex)
            {
                Console.WriteLine(ex.TargetSite);
                return dt;                
            }
            return dt;
        }

 

Convert XLSX file to DataTable via NPOI

原文:https://www.cnblogs.com/Fred1987/p/13196147.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!