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); } }