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