public string readCellExcel(string filePath, string isheetname, int irow, int icolumn)
{
string result = "";
try
{
using (StreamReader input = new StreamReader(filePath))
{
NPOI.HSSF.UserModel.HSSFWorkbook workbook = new NPOI.HSSF.UserModel.HSSFWorkbook(new NPOI.POIFS.FileSystem.POIFSFileSystem(input.BaseStream));
if (null == workbook)
{
result = "";
}
NPOI.HSSF.UserModel.HSSFFormulaEvaluator formulaEvaluator = new NPOI.HSSF.UserModel.HSSFFormulaEvaluator(workbook);
NPOI.HSSF.UserModel.HSSFDataFormatter dataFormatter = new NPOI.HSSF.UserModel.HSSFDataFormatter(new CultureInfo("vi-VN"));
NPOI.SS.UserModel.ISheet sheet = workbook.GetSheet(isheetname);
NPOI.SS.UserModel.IRow row = sheet.GetRow(irow);
if (row != null)
{
short minColIndex = row.FirstCellNum;
short maxColIndex = row.LastCellNum;
if (icolumn >= minColIndex || icolumn <= maxColIndex)
{
NPOI.SS.UserModel.ICell cell = row.GetCell(icolumn);
if (cell != null)
{
result = dataFormatter.FormatCellValue(cell, formulaEvaluator);
}
}
}
}
}
catch (Exception ex)
{
string test = ex.Message;
}
return result;
}
public string readCellExcel(string filePath, string isheetname, int irow, int icolumn)
{
string result = "";
try
{
using (StreamReader input = new StreamReader(filePath))
{
NPOI.SS.UserModel.IWorkbook workbook = new NPOI.HSSF.UserModel.HSSFWorkbook(new NPOI.POIFS.FileSystem.POIFSFileSystem(input.BaseStream));
if (null == workbook)
{
result = "";
}
NPOI.SS.UserModel.IFormulaEvaluator formulaEvaluator = new NPOI.HSSF.UserModel.HSSFFormulaEvaluator(workbook);
NPOI.SS.UserModel.DataFormatter dataFormatter = new NPOI.HSSF.UserModel.HSSFDataFormatter(new CultureInfo("vi-VN"));
NPOI.SS.UserModel.ISheet sheet = workbook.GetSheet(isheetname);
NPOI.SS.UserModel.IRow row = sheet.GetRow(irow);
result = dataFormatter.FormatCellValue(row.Cells[icolumn], formulaEvaluator);
/*foreach (NPOI.SS.UserModel.ISheet sheet in workbook)
{
foreach (NPOI.SS.UserModel.IRow row in sheet)
{
foreach (NPOI.SS.UserModel.ICell cell in row)
{
string value = dataFormatter.FormatCellValue(cell, formulaEvaluator);
}
}
}*/
}
}
catch { }
return result;
}
