public ExcelCells(IGxError errAccess, ExcelDocument document, object workBook, object selectedSheet, int rowPos, int colPos, int height, int width, bool readOnly)
{
doc = document;
m_errAccess = errAccess;
pWidth = width;
pHeight = height;
cntCells = 0;
pColPos = colPos;
pSelectedSheet = (ExcelWorksheet)selectedSheet;
this.readOnly = readOnly;
try
{
pCellsRange = getExcelCell(rowPos, pColPos, pColPos + (pWidth - 1), rowPos + (pHeight - 1));
pCells = new ExcelRange[width * height + 1];
string address = pCellsRange.Address;
int startRow = pCellsRange.Start.Row;
int endRow = pCellsRange.End.Row;
int startCol = pCellsRange.Start.Column;
int endCol = pCellsRange.End.Column;
for (int i = startRow; i <= endRow; i++)
{
for (int j = startCol; j <= endCol; j++)
{
cntCells++;
pCells[cntCells] = pCellsRange[i, j];
}
}
pCellsRange.Address = address;
}
catch (Exception e)
{
GXLogging.Error(log, "ExcelCells error", e);
m_errAccess.setErrDes("Invalid cell coordinates");
m_errAccess.setErrCod((short)8);
}
}
public ExcelCells(IGxError errAccess, ExcelDocument doc, object workBook, object selectedSheet, int rowPos, int colPos, int height, int width)
: this(errAccess, doc, workBook, selectedSheet, rowPos, colPos, height, width, false)
{
}