求教asp.net用NPOI读取EXCEL时如何将字符类型的数字转换成数字型的数字

Question

NPOIExcel

Answer 1

代码如下 该如何在代码中将EXCEL中的字符串转换为数字型 /// <summary>
        /// 读取EXCEL到DataTable
        /// </summary>
        /// <param name="strFileName"></param>
        /// <returns></returns>
        private DataTable ImportExcelToDataTable(string strFileName)
        {
            DataTable dt = new DataTable();            HSSFWorkbook hssworkbook;            using(FileStream file=new FileStream(strFileName,FileMode.Open,FileAccess.Read))
            {
                hssworkbook = new HSSFWorkbook(file);
            }
            NPOI.SS.UserModel.ISheet sheet = hssworkbook.GetSheetAt(0);
            System.Collections.IEnumerator rows = sheet.GetRowEnumerator();            NPOI.SS.UserModel.IRow headerRow = sheet.GetRow(0);
            int cellCount = headerRow.LastCellNum;            for (int j = 0; j < cellCount; j++)
            {
                NPOI.SS.UserModel.ICell cell = headerRow.GetCell(j);
                dt.Columns.Add(cell.ToString());
            }            for (int i = (sheet.FirstRowNum + 1); i <= sheet.LastRowNum; i++)
            {
                NPOI.SS.UserModel.IRow row = sheet.GetRow(i);
                DataRow dataRow = dt.NewRow();                for (int j = row.FirstCellNum; j < cellCount; j++)
                {
                    if (row.GetCell(j) != null)
                    {
                        dataRow[j] = row.GetCell(j).ToString();
                    }
                }
                dt.Rows.Add(dataRow);
            }
            return dt;        }

Answer 2

 dataRow[j] = int.Parse(row.GetCell(j).ToString());