private IRange GetWorksheetDataHeaderRange(IWorksheet sheet) { if (this._connString.Header) { IRange dataRange = sheet.GetUsedRange(UsedRangeType.Data); return(sheet.Range[dataRange.Row, dataRange.Column, 1, dataRange.Columns.Count]); } return(null); }
private IRange GetWorksheetDataRange(IWorksheet sheet) { IRange dataRange = sheet.GetUsedRange(UsedRangeType.Data); if (this._connString.Header) { dataRange = dataRange.Rows.Count > 1 ? sheet.Range[dataRange.Row + 1, dataRange.Column, dataRange.Rows.Count - 1, dataRange.Columns.Count] : null; } return(dataRange); }
public override void Execute(GrapeCity.Documents.Excel.Workbook workbook) { IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["A1:B2"].Value = new object[, ] { { 1, 2 }, { "aaa", "bbb" } }; worksheet.Range["A2:C3"].Interior.Color = Color.Green; //style used range is A2:C3. var UsedRange_style = worksheet.GetUsedRange(UsedRangeType.Style); UsedRange_style.Interior.Color = Color.LightBlue; }