ExcelChartDataRange
OfficeIMO.Excel
Represents the workbook range used for chart data (categories + series values).
Inheritance
- object
- ExcelChartDataRange
Usage
Explore 6 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 4
- Property ExcelChart.DataRange
- Method ExcelChartDataRange.WithSize
- Property ExcelModernChart.DataRange
- Method ExcelSheet.WriteChartData
Accepted by parameters 2
- Method ExcelChart.UpdateData
- Method ExcelSheet.AddChart
Constructors
public ExcelChartDataRange(string sheetName, int startRow, int startColumn, int categoryCount, int seriesCount, bool hasHeaderRow = true) #Creates a chart data range descriptor for categories and series values.
Parameters
- sheetName string
- startRow int
- startColumn int
- categoryCount int
- seriesCount int
- hasHeaderRow bool = true
public ExcelChartDataRange(string sheetName, int startRow, int startColumn, int categoryCount, int seriesCount, bool hasHeaderRow, ExcelChartDataOrientation orientation) #Creates a chart data range descriptor for categories and series values.
Parameters
- sheetName string
- startRow int
- startColumn int
- categoryCount int
- seriesCount int
- hasHeaderRow bool
- orientation OfficeIMO.Excel.ExcelChartDataOrientation
Methods
public string SeriesNameCellA1(int seriesIndex) #Gets the header cell for the specified series (A1), or empty when no series-name header is used.
Parameters
- seriesIndex int
Returns
stringpublic string SeriesValuesRangeA1(int seriesIndex) #Gets the series values range as an A1 reference for the specified series.
Parameters
- seriesIndex int
Returns
stringpublic ExcelChartDataRange WithSize(int categoryCount, int seriesCount) #Returns a new range with updated category and series counts.
Parameters
- categoryCount int
- seriesCount int
Returns
ExcelChartDataRangeInherited Methods
Properties
public string SheetName { get; } #Gets the worksheet name that owns the data range.
public int StartRow { get; } #Gets the 1-based starting row of the data range.
public int StartColumn { get; } #Gets the 1-based starting column of the data range.
public bool HasHeaderRow { get; } #Gets whether the data range includes series-name headers.
public ExcelChartDataOrientation Orientation { get; } #Gets the orientation of the chart data range.
public int CategoryStartRow { get; } #Gets the first row index that contains category values.
public int CategoryEndRow { get; } #Gets the last row index that contains category values.
public int CategoryStartColumn { get; } #Gets the first column index that contains category values.
public int CategoryEndColumn { get; } #Gets the last column index that contains category values.
public int SeriesStartRow { get; } #Gets the first row index that contains series values.
public int SeriesEndRow { get; } #Gets the last row index that contains series values.
public int SeriesStartColumn { get; } #Gets the first column index that contains series values.
public int SeriesEndColumn { get; } #Gets the last column index that contains series values.
public string DataRangeA1 { get; } #Gets the data range (headers + categories + values) as an A1 reference.
public string CategoriesRangeA1 { get; } #Gets the categories range as an A1 reference.