public static bool TryCreateCell(OpenXmlWorksheet worksheet, string reference, out OpenXmlCell cell)
{
if (ReferenceEncoder.TryDecodeCellReference(reference, out uint column, out bool isColumnFixed, out uint row, out bool isRowFixed))
{
cell = new OpenXmlCell(worksheet, column, isColumnFixed, row, isRowFixed);
return(true);
}
public OpenXmlCell(OpenXmlWorksheet worksheet, uint column, bool isColumnFixed, uint row, bool isRowFixed)
{
this.worksheet = worksheet;
this.column = column;
this.isColumnFixed = isColumnFixed;
this.row = row;
this.isRowFixed = isRowFixed;
}
public OpenXmlCell(OpenXmlWorksheet worksheet, uint column, uint row)
{
this.worksheet = worksheet;
this.column = column;
this.isColumnFixed = false;
this.row = row;
this.isRowFixed = false;
}
public OpenXmlRange(OpenXmlWorksheet worksheet, uint?startColumn, uint?startRow, uint?endColumn, uint?endRow)
{
this.worksheet = worksheet;
this.startColumn = startColumn;
this.isStartColumnFixed = false;
this.startRow = startRow;
this.isStartRowFixed = false;
this.endColumn = endColumn;
this.isEndColumnFixed = false;
this.endRow = endRow;
this.isEndRowFixed = false;
}
public OpenXmlRange(
OpenXmlWorksheet worksheet,
uint?startColumn, bool isStartColumnFixed,
uint?startRow, bool isStartRowFixed,
uint?endColumn, bool isEndColumnFixed,
uint?endRow, bool isEndRowFixed)
{
this.worksheet = worksheet;
this.startColumn = startColumn;
this.isStartColumnFixed = isStartColumnFixed;
this.startRow = startRow;
this.isStartRowFixed = isStartRowFixed;
this.endColumn = endColumn;
this.isEndColumnFixed = isEndColumnFixed;
this.endRow = endRow;
this.isEndRowFixed = isEndRowFixed;
}
public WorksheetCells(OpenXmlWorksheet worksheet)
{
this.worksheet = worksheet;
}
