/* sheetName 工作簿名称
location 单元格名称 如A4,B6,E7
*/
private string GetOtherSheetStringValue(IWorkbook wk, String sheetName, String location)
{
ISheet sheet = wk.GetSheet(sheetName);
var cr = new CellReference(location);
var row = sheet.GetRow(cr.Row);
var cell = row.GetCell(cr.Col);
string result = cell.StringCellValue;
return result;
}
NPOI查询sheet中的某个单元格的值
最新推荐文章于 2021-03-19 14:29:14 发布