private void AutoAppend(Worksheet sheet, int row, int col) { if (sheet.RowCount < row + 1) { sheet.AppendRows(row - sheet.RowCount + 1); } if (sheet.ColumnCount < col + 1) { sheet.AppendCols(col - sheet.ColumnCount + 1); } }