public ExcelDataTable(Excel._Worksheet _mySheet, string _startAddress, string _endAddress)
{
mySheet = _mySheet;
headerRow = new ExcelDataTableRow(this);
startAddress = _startAddress;
endAddress = _endAddress;
recalcXYCoord();
}
public void readTheTableFromExcelSheet()
{
ExcelDataTableRow rw;
//обнулить эту таблицу и прочитать ее снова
clearTheTable();
var arrData = (object[, ])mySheet.Range[startAddress + ":" + endAddress].Value;
// mySheet.Range[startAddress + ":" + endAddress].Value = arrData;
//сначала читаем hearer row
for (long i = 1; i <= columnCount; i++)
{
//r = (Excel.Range)mySheet.Cells[1, i];
ExcelDataTableCell es = new ExcelDataTableCell();
es.value = arrData[1, i];
headerRow.items.Add(es);
}
long arrLen = rowCount;
for (long currentRow = 2 + dataRangeRowShift; currentRow <= arrLen; currentRow++)
{
rw = new ExcelDataTableRow(this);
for (long currentCol = 1; currentCol <= columnCount; currentCol++)
{
//r = (Excel.Range)mySheet.Cells[currentRow, currentCol];
ExcelDataTableCell es = new ExcelDataTableCell();
//es.value = rData.Cells[currentRow, currentCol];
es.value = arrData[currentRow, currentCol];
rw.items.Add(es);
}
dataRows.Add(rw);
}
}
