Click or drag to resize

ChartSheet Properties

The ChartSheet type exposes the following members.

Properties
Name Description
Public property ArcShapes
Gets the collection of arc shapes in the worksheet.
(Inherited from XlsWorksheetBase .)
Public property AutoScaling
True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart.
(Inherited from XlsChart .)
Public property ButtonShapes
Gets the collection of button shapes in the worksheet.
(Inherited from XlsWorksheetBase .)
Public property CanChartBubbleLabel
Returns True if chart can have bubble data labels. Read-only.
(Inherited from XlsChart .)
Public property CanChartHaveSeriesLines
Returns True if chart can have series lines. Read-only.
(Inherited from XlsChart .)
Public property CanChartPercentageLabel
Returns True if chart can have percentage data labels. Read-only.
(Inherited from XlsChart .)
Public property CategoryAxisTitle
Title of the category axis.
(Inherited from XlsChart .)
Public property CellImages
Cell image array. Read-only.
(Inherited from XlsWorksheetBase .)
Public property ChartArea
Returns an object that represents the complete chart area for the chart.
Public property Charts
Returns charts collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property ChartStartType
Returns start type of chart type. Read-only.
(Inherited from XlsChart .)
Public property ChartTitle
Title of the chart.
(Inherited from XlsChart .)
Public property ChartTitleArea
Gets title text area. Read-only.
Public property ChartTitleFont
Returns object that describes chart title area. Read-only.
(Inherited from XlsChart .)
Public property ChartType
Type of the chart.
(Inherited from XlsChart .)
Public property CheckBoxes
Returns inner checkboxes collection. Read-only.
Public property CodeName
Name used by macros to access workbook items.
(Inherited from XlsWorksheetBase .)
Public property ComboBoxes
Returns collection with all comboboxes inside this worksheet. Read-only.
(Inherited from XlsWorksheetBase .)
Public property Comments
Represents comments collection for the worksheet. Read-only.
Public property DataRange
DataRange for the chart series.
Public property DataTable
Returns a DataTable object that represents the chart data table.
Public property DefaultGridlineColor
Indicates whether gridline color has default value.
(Inherited from XlsWorksheetBase .)
Public property DefaultLinePattern
Returns default line pattern for the chart. Read-only.
(Inherited from XlsChart .)
Public property DefaultTextIndex Obsolete.
Gets font index from the default font records.
(Inherited from XlsChart .)
Public property DepthPercent
Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
(Inherited from XlsChart .)
Public property DestinationType
Gets chart type after type change.
(Inherited from XlsChart .)
Public property DisplayAxisFieldButtons
Gets or sets a value indicating whether [show axis field buttons].
(Inherited from XlsChart .)
Public property DisplayBlanksAs
Represents the way that blank cells are plotted on a chart.
(Inherited from XlsChart .)
Public property DisplayEntireFieldButtons
Gets or sets a value indicating whether [show all field buttons].
(Inherited from XlsChart .)
Public property DisplayLegendFieldButtons
Gets or sets a value indicating whether [show legend field buttons].
(Inherited from XlsChart .)
Public property DisplayValueFieldButtons
Gets or sets a value indicating whether [show value field buttons].
(Inherited from XlsChart .)
Public property Elevation
Returns or sets the elevation of the 3-D chart view, in degrees (?0 to +90 degrees).
(Inherited from XlsChart .)
Public property FirstColumn
Gets or sets index of the first column of the worksheet.
(Inherited from XlsWorksheetBase .)
Public property FirstDataColumn
Gets index of the first data column of the worksheet.
(Inherited from XlsWorksheetBase .)
Public property FirstDataRow
Gets index of the first data row of the worksheet.
(Inherited from XlsWorksheetBase .)
Public property FirstRow
Gets / sets index of the first row of the worksheet.
(Inherited from XlsWorksheetBase .)
Public property Floor
Returns a Floor object that represents the floor of the 3-D chart
Public property Font
Gets font which used for displaying axis text .
(Inherited from XlsChart .)
Public property GapDepth
Returns or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.( 0 - 500 )
(Inherited from XlsChart .)
Public property Code example GridLineColor
Grid line color.
Examples
The following code illustrates how to set the grid line color:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Set grid lines color</para><para>worksheet.GridLineColor = ExcelColors.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("GridLineColor.xlsx");</para>
(Inherited from XlsWorksheetBase .)
Public property GroupBoxes
Gets the group boxes in the worksheet.
(Inherited from XlsWorksheetBase .)
Public property GroupShapeCollection
Get group shapes in worksheet.
(Inherited from XlsWorksheetBase .)
Public property HasChartArea
Indicates whether chart has chart area.
(Inherited from XlsChart .)
Public property HasChartTitle
Indicates wheather the chart has title
(Inherited from XlsChart .)
Public property HasDataTable
True if the chart has a data table.
(Inherited from XlsChart .)
Public property HasFloor
Gets value indicating whether floor object was created.
(Inherited from XlsChart .)
Public property HasLegend
True if the chart has a legend object.
(Inherited from XlsChart .)
Public property HasPictures
Indicates whether tabsheet contains any picture. Read-only.
(Inherited from XlsWorksheetBase .)
Public property HasPivotTable
Indicates whether contains pivot table.
(Inherited from XlsChart .)
Public property HasPlotArea
Indicates whether chart has plot area.
(Inherited from XlsChart .)
Public property HasVmlShapes
Indicates whether worksheet has vml shapes. Read-only.
(Inherited from XlsWorksheetBase .)
Public property HasWalls
Gets value indicating whether floor object was created.
(Inherited from XlsChart .)
Public property HeaderFooterShapes
Header / footer shapes collection.
(Inherited from XlsWorksheetBase .)
Public property Height
Height of the chart in points (1/72 inch).
(Inherited from XlsChart .)
Public property HeightPercent
Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
(Inherited from XlsChart .)
Public property Index
Returns the index number of the object within the collection of objects.
(Inherited from XlsWorksheetBase .)
Public property IsCategoryAxisAvail
Indicates whether chart has a category axis. Read-only.
(Inherited from XlsChart .)
Public property IsChart_100
Returns True if chart is 100%. Read-only.
(Inherited from XlsChart .)
Public property IsChart3D
Returns True if chart is 3D. Read-only.
(Inherited from XlsChart .)
Public property IsChartBar
Returns True if chart is a bar chart. Read-only.
(Inherited from XlsChart .)
Public property IsChartBubble
Returns True if chart is a bubble chart. Read-only.
(Inherited from XlsChart .)
Public property IsChartCone
Returns True if chart is a conical shape. Read-only.
(Inherited from XlsChart .)
Public property IsChartCylinder
Returns True if chart is a cylinder shape. Read-only.
(Inherited from XlsChart .)
Public property IsChartDoughnut
Returns True if chart is a doughnut chart. Read-only.
(Inherited from XlsChart .)
Public property IsChartExploded
Returns True if chart is exploded. Read-only.
(Inherited from XlsChart .)
Public property IsChartFloor
Returns True if chart has floor. Read-only.
(Inherited from XlsChart .)
Public property IsChartLine
Returns True if chart is line. Read-only.
(Inherited from XlsChart .)
Public property IsChartPie
Returns True if chart is a pie chart. Read-only.
(Inherited from XlsChart .)
Public property IsChartPyramid
Returns True if chart is a pyramid shape. Read-only.
(Inherited from XlsChart .)
Public property IsChartRadar
Returns True if chart is a radar chart. Read-only.
(Inherited from XlsChart .)
Public property IsChartScatter
Returns True if chart is a scatter chart. Read-only.
(Inherited from XlsChart .)
Public property IsChartSmoothedLine
Returns True if chart has smoothed lines. Read-only.
(Inherited from XlsChart .)
Public property IsChartStock
Returns True if this is a stock chart. Read-only.
(Inherited from XlsChart .)
Public property IsChartVeryColor
Returns True if chart should have a different color for each series value. Read-only.
(Inherited from XlsChart .)
Public property IsChartVolume
Returns True if chart is a stock chart with volume. Read-only.
(Inherited from XlsChart .)
Public property IsChartWalls
Returns True if chart has walls. Read-only.
(Inherited from XlsChart .)
Public property IsClustered
Returns True if chart is a clustered chart. Read-only.
(Inherited from XlsChart .)
Public property IsEmbeded
Gets value indicating whether chart is embeded into worksheet.
(Inherited from XlsChart .)
Public property IsPasswordProtected
True if the worksheet has been protected with password.
(Inherited from XlsWorksheetBase .)
Public property IsPerspective
Returns True if chart has perspective. Read-only.
(Inherited from XlsChart .)
Public property IsPivot3DChart
Gets a value indicating whether this instance is pivot 3D chart .
(Inherited from XlsChart .)
Public property IsRightToLeft
Indicates whether worksheet is displayed right to left.
(Inherited from XlsWorksheetBase .)
Public property IsRowColHeadersVisible
Gets or sets whether the worksheet will display row and column headers. Default is true.
(Inherited from XlsWorksheetBase .)
Public property IsSecondaryAxes Obsolete.
Returns True if at least one of the secondary axes is present. Read-only.
(Inherited from XlsChart .)
Public property IsSecondaryCategoryAxisAvail Obsolete.
Returns True if secondary category axis present. Read-only.
(Inherited from XlsChart .)
Public property IsSecondaryValueAxisAvail Obsolete.
Returns True if secondary value axis present. Read-only.
(Inherited from XlsChart .)
Public property IsSelected
Indicates whether tab of this sheet is selected. Read-only.
(Inherited from XlsWorksheetBase .)
Public property IsSeriesAxisAvail Obsolete.
Indicates if chart has a series axis. Read-only.
(Inherited from XlsChart .)
Public property IsSeriesLines
Returns True if chart has series lines. Read-only.
(Inherited from XlsChart .)
Public property IsSpecialDataLabels
Returns True if chart needs special data labels serialization. Read-only.
(Inherited from XlsChart .)
Public property IsStacked
Returns True if chart is stacked. Read-only.
(Inherited from XlsChart .)
Public property IsTransitionEvaluation
Gets or sets a value indicating whether transition evaluation is enabled.
(Inherited from XlsWorksheetBase .)
Public property IsValueAxisAvail
Indicates whehter chart has a value axis. Read-only.
(Inherited from XlsChart .)
Public property LabelShapes
Gets the collection of label shapes in the worksheet.
(Inherited from XlsWorksheetBase .)
Public property LastColumn
Gets or sets index of the last column of the worksheet.
(Inherited from XlsWorksheetBase .)
Public property LastDataColumn
Gets index of the last data column of the worksheet.
(Inherited from XlsWorksheetBase .)
Public property LastDataRow
Gets index of the last data row of the worksheet.
(Inherited from XlsWorksheetBase .)
Public property LastRow
Gets or sets one-based index of the last row of the worksheet.
(Inherited from XlsWorksheetBase .)
Public property Code example LeftVisibleColumn
Gets/sets left visible column of the worksheet.
Examples
The following code illustrates how to set the left visible column:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Set left visible column</para><para>worksheet.LeftVisibleColumn = 3;</para><para>//Get left visible column</para><para>Console.Write(worksheet.LeftVisibleColumn);</para><para>//Save to file</para><para>workbook.SaveToFile("LeftVisibleColumn.xlsx");</para>
(Inherited from XlsWorksheetBase .)
Public property Legend
Represents chart legend.
Public property Lines
Gets the lines of the chart.
(Inherited from XlsWorksheetBase .)
Public property ListBoxes
Gets the list of list boxes in the workbook.
(Inherited from XlsWorksheetBase .)
Public property Name
Returns or sets the name of the object. Read / write String.
(Inherited from XlsWorksheetBase .)
Public property NeedDataFormat
Returns True if chart needs data format to be saved. Read-only.
(Inherited from XlsChart .)
Public property NeedDropBar
Returns True if chart needs drop bars to be saved. Read-only.
(Inherited from XlsChart .)
Public property NeedMarkerFormat
Returns True if chart needs marker format to be saved. Read-only.
(Inherited from XlsChart .)
Public property NoPlotArea
Returns True if chart has no plot area. Read-only.
(Inherited from XlsChart .)
Public property OvalShapes
Gets the oval shapes in the worksheet.
(Inherited from XlsWorksheetBase .)
Public property PageSetup
Page setup for the chart.
Public property Parent
Reference to Parent object. Read-only.
(Inherited from XlsObject .)
Public property ParentWorkbook
Returns parent workbook. Read-only.
(Inherited from XlsWorksheetBase .)
Public property Perspective
Returns or sets the perspective for the 3-D chart view (0 to 100).
(Inherited from XlsChart .)
Public property Pictures
Pictures collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property PivotChartType
Gets or sets the type of the pivot chart.
(Inherited from XlsChart .)
Public property PivotTable
Gets or sets the pivot source.
(Inherited from XlsChart .)
Public property PlotArea
Returns a PlotArea object that represents the plot area of a chart.
Public property PlotVisibleOnly
True if only visible cells are plotted. False if both visible and hidden cells are plotted.
(Inherited from XlsChart .)
Public property PrimaryCategoryAxis
Returns primary category axis.
Public property PrimarySerieAxis
Returns primary series axis.
Public property PrimaryValueAxis
Returns primary value axis.
Public property ProtectContents
Indicates is current sheet is protected.
(Inherited from XlsWorksheetBase .)
Public property ProtectDrawingObjects
True if objects are protected. Read only.
(Inherited from XlsWorksheetBase .)
Public property Protection
Gets protected options. Read-only. For sets protection options use "Protect" method.
(Inherited from XlsWorksheetBase .)
Public property ProtectScenarios
True if the scenarios of the current sheet are protected. Read only.
(Inherited from XlsWorksheetBase .)
Public property PrstGeomShapes
Gets the collection of preset geometric shapes.
(Inherited from XlsWorksheetBase .)
Public property QueryTables
Gets the collection of query tables in the worksheet.
(Inherited from XlsWorksheetBase .)
Public property RadioButtons
Returns inner radiobutton collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property RealIndex
Index of the worksheet in the workbook (not necessary in Worksheets collection)
(Inherited from XlsWorksheetBase .)
Public property RectangleShapes
Gets the rectangle shapes in the worksheet.
(Inherited from XlsWorksheetBase .)
Protected property ReferenceCount
Get quantity of instance references.
(Inherited from XlsObject .)
Public property RightAngleAxes
True if the chart axes are at right angles, independent of chart rotation or elevation.
(Inherited from XlsChart .)
Public property Rotation
Returns or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).(0 to 360 degrees).
(Inherited from XlsChart .)
Public property ScrollBarShapes
Gets the scroll bar shapes associated with the worksheet.
(Inherited from XlsWorksheetBase .)
Public property SecondaryCategoryAxis
Returns secondary category axis.
Public property SecondaryCategoryAxisTitle
Title of the secondary category axis.
(Inherited from XlsChart .)
Public property SecondaryValueAxis
Returns secondary value axis.
Public property SecondaryValueAxisTitle
Title of the secondary value axis.
(Inherited from XlsChart .)
Public property Series
Returns an object that represents either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group.
Public property SeriesAxisTitle
Title of the series axis.
(Inherited from XlsChart .)
Public property SeriesDataFromRange
True if series are in rows in DataRange; False otherwise.
(Inherited from XlsChart .)
Public property Shapes
Shapes collection.
(Inherited from XlsWorksheetBase .)
Public property SheetId
Gets or sets sheetId for this sheet.
(Inherited from XlsWorksheetBase .)
Public property ShowReportFilterFieldButtons
Gets or sets a value indicating whether [show report filter field buttons].
(Inherited from XlsChart .)
Public property SizeWithWindow
True if Microsoft Excel resizes the chart to match the size of the chart sheet window. False if the chart size isn't attached to the window size. Applies only to chart sheets.
(Inherited from XlsChart .)
Public property SpinnerShapes
Gets the spinner shapes in the worksheet.
(Inherited from XlsWorksheetBase .)
Public property Style
Style index for Excel 2007 chart.
(Inherited from XlsChart .)
Public property SupportWallsAndFloor
Indicates whether this chart supports walls and floor. Read-only.
(Inherited from XlsChart .)
Public property TabColor
Tab color.
(Inherited from XlsWorksheetBase .)
Public property TabColorObject
Tab color.
(Inherited from XlsWorksheetBase .)
Public property TabKnownColor
Tab excel color.
(Inherited from XlsWorksheetBase .)
Public property TextBoxes
Returns inner textboxes collection. Read-only.
Public property Code example TopVisibleRow
Gets/sets top visible row of the worksheet.
Examples
The following code illustrates how to set the top visible row:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Set top visible row</para><para>worksheet.TopVisibleRow = 5;</para><para>//Get top visible row</para><para>Console.Write(worksheet.TopVisibleRow);</para><para>//Save to file</para><para>workbook.SaveToFile("TopVisibleRow.xlsx");</para>
(Inherited from XlsWorksheetBase .)
Public property TypedArcs
Returns inner Arcs collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedButtons
Returns inner buttons collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedCheckBoxes
Returns inner checkboxes collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedComboBoxes
Returns inner comboboxes collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedGroupBoxes
Returns inner gourpboxes collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedLabels
Returns inner labels collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedLines
Returns inner lines collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedListBoxes
Returns inner listboxes collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedOvals
Returns inner ovals collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedPictures
Returns inner pictures collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedRadioButtons
Returns inner radiobutton collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedRects
Returns inner rects collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedScollBars
Returns inner scollbars collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedSpinners
Returns inner spinners collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property TypedTextBoxes
Returns inner textboxes collection. Read-only.
(Inherited from XlsWorksheetBase .)
Public property UnknownVmlShapes
Indicates whether worksheet contains some unknown vml shapes.
(Inherited from XlsWorksheetBase .)
Public property ValueAxisTitle
Title of the value axis.
(Inherited from XlsChart .)
Public property Visibility
Controls end user visibility of worksheet.
(Inherited from XlsWorksheetBase .)
Public property VmlShapesCount
Returns number of known vml shapes. Read-only.
(Inherited from XlsWorksheetBase .)
Public property Walls
Represents chart walls.
Public property WallsAndGridlines2D
True if gridlines are drawn two-dimensionally on a 3-D chart.
(Inherited from XlsChart .)
Public property Width
Width of the chart in points (1/72 inch).
(Inherited from XlsChart .)
Public property Workbook
Workbook which contains the chart.
Public property XPos
X coordinate of the upper-left corner of the chart in points (1/72 inch).
(Inherited from XlsChart .)
Public property YPos
Y coordinate of the upper-left corner of the chart in points (1/72 inch).
(Inherited from XlsChart .)
Public property Zoom
Zoom factor of document.
(Inherited from XlsWorksheetBase .)
Public property ZoomToFit
Gets or sets zoomToFit value.
(Inherited from XlsChart .)
Top
See Also