using (FileStream fs = File.Open(path, FileMode.Open)) //path:读取文件的路径
{
workbook = new XSSFWorkbook(fs);
}
for (int i = 0; i < objs.count; i++)
{
grids = objs.grids[i];
string sheetName = grids.name;
worksheet = workbook.GetSheet(sheetName);
row = worksheet.GetRow(grids.row); //这边 GetRow方法 总是会返回null,而我在计算行的时候 这一行总是有值的
cell = row.GetCell(grids.col);
cell.SetCellFormula(grids.gs);
cell.SetCellValue(grids.gs);
}
获取行的时候要先创建行,然后再创建列,每一行都必须这么操作