/// <summary> /// The end of a participant report data section is marked /// by a row with "Counts households ..." in the first column. /// </summary> /// <param name="row"></param> /// <returns></returns> protected override bool IsDataRow(ExcelRow row) { return((!row.IsEmpty()) && (!row[0].StartsWith("Counts households", ignoreCase: true, culture: null)) ); }
public static VestaReportSection create( ExcelSheet sheet, int top_row_idx, string marker_text, ReportTypes report_type, int year ) { VestaReportSection retSect = null; ExcelRow r = sheet[top_row_idx + 2]; if (!r.IsEmpty() && (r[EMPTY_SECTION_MARKER_COLUMN]).Trim() != EMPTY_SECTION_MARKER) { switch (report_type) { case ReportTypes.Participant: retSect = new ParticipantReportSection(sheet, top_row_idx, year); break; case ReportTypes.Labels: Tuple <LabelType, RequestType> tu = parse_marker_text(marker_text); LabelType lt = tu.Item1; RequestType rt = tu.Item2; switch (lt) { case LabelType.Bag: retSect = new BagLabelReportSection(sheet, top_row_idx, rt, year); break; case LabelType.Gift: retSect = new GiftLabelReportSection(sheet, top_row_idx, rt, year); break; } break; } } return(retSect); }
protected override bool IsDataRow(ExcelRow row) { return(!row.IsEmpty()); }