public void WriteInPlace(object line)
{
Range range = ExcelUtil.GetRange(Row, Col, this.WorksheetInstance);
range.NumberFormat = "@";
range.Value2 = line;
}
public string ReadLineCellText()
{
Range range = ExcelUtil.GetRange(Row, Col, this.WorksheetInstance);
if (range.Text != null)
{
MoveNext();
return(range.Text.ToString().Trim());
}
else
{
MoveNext();
return(string.Empty);
}
}
public static void RangeDeleteRows(int row, int col, Worksheet ws)
{
Range cols = ExcelUtil.GetRange(row, col, ws);
DeleteRows(cols, col);
}