private CellPosition FindLastRow(CellRange range, CellPosition headerStart) { var result = headerStart; for (int row = headerStart.Row; row <= range.LastRow + 1; row++) { var currentCell = range[row, headerStart.Column].Value; if (string.IsNullOrWhiteSpace(currentCell)) { result.Row = row; break; } } return result; }
//public void OpenPdf() //{ // Process.Start(this.PdfFullFileRoot); //} private CellPosition FindHeader(CellRange range, string startValue) { var headerStart = new CellPosition(0, 0); for (int row = range.Row; row <= range.LastRow; row++) { for (int col = range.Column; col <= range.LastColumn; col++) { var currentCell = range[row, col].Value; if (currentCell == startValue) { headerStart = new CellPosition(row, col); break; } } } return headerStart; }