XlsChart Properties

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

Name

Description

ArcShapes

Gets the collection of arc shapes in the worksheet.

(Inherited from XlsWorksheetBase .)

AutoScaling

True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart.

ButtonShapes

Gets the collection of button shapes in the worksheet.

(Inherited from XlsWorksheetBase .)

CanChartBubbleLabel

Returns True if chart can have bubble data labels. Read-only.

CanChartHaveSeriesLines

Returns True if chart can have series lines. Read-only.

CanChartPercentageLabel

Returns True if chart can have percentage data labels. Read-only.

CategoryAxisTitle

Title of the category axis.

CellImages

Cell image array. Read-only.

(Inherited from XlsWorksheetBase .)

ChartArea

Returns an object that represents the complete chart area for the chart. Read-only.

Charts

Returns charts collection. Read-only.

(Inherited from XlsWorksheetBase .)

ChartStartType

Returns start type of chart type. Read-only.

ChartTitle

Title of the chart.

ChartTitleFont

Returns object that describes chart title area. Read-only.

ChartType

Type of the chart.

CheckBoxes

Returns inner checkboxes collection. Read-only.

(Inherited from XlsWorksheetBase .)

CodeName

Name used by macros to access workbook items.

(Inherited from XlsWorksheetBase .)

ComboBoxes

Returns collection with all comboboxes inside this worksheet. Read-only.

(Inherited from XlsWorksheetBase .)

Comments

Returns comments collection for this worksheet. Read-only.

(Inherited from XlsWorksheetBase .)

DataRange

DataRange for the chart series.

DataTable

Represents charts dataTable object.

DefaultGridlineColor

Indicates whether gridline color has default value.

(Inherited from XlsWorksheetBase .)

DefaultLinePattern

Returns default line pattern for the chart. Read-only.

DefaultTextIndex

Obsolete.

Gets font index from the default font records.

DepthPercent

Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).

DestinationType

Gets chart type after type change.

DisplayAxisFieldButtons

Gets or sets a value indicating whether [show axis field buttons].

DisplayBlanksAs

Represents the way that blank cells are plotted on a chart.

DisplayEntireFieldButtons

Gets or sets a value indicating whether [show all field buttons].

DisplayLegendFieldButtons

Gets or sets a value indicating whether [show legend field buttons].

DisplayValueFieldButtons

Gets or sets a value indicating whether [show value field buttons].

Elevation

Returns or sets the elevation of the 3-D chart view, in degrees (?0 to +90 degrees).

FirstColumn

Gets or sets index of the first column of the worksheet.

(Inherited from XlsWorksheetBase .)

FirstDataColumn

Gets index of the first data column of the worksheet.

(Inherited from XlsWorksheetBase .)

FirstDataRow

Gets index of the first data row of the worksheet.

(Inherited from XlsWorksheetBase .)

FirstRow

Gets / sets index of the first row of the worksheet.

(Inherited from XlsWorksheetBase .)

Floor

Represents chart floor. Read-only.

Font

Gets font which used for displaying axis text .

GapDepth

Returns or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.( 0 - 500 )

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 .)

GroupBoxes

Gets the group boxes in the worksheet.

(Inherited from XlsWorksheetBase .)

GroupShapeCollection

Get group shapes in worksheet.

(Inherited from XlsWorksheetBase .)

HasChartArea

Indicates whether chart has chart area.

HasChartTitle

Indicates wheather the chart has title

HasDataTable

True if the chart has a data table.

HasFloor

Gets value indicating whether floor object was created.

HasLegend

True if the chart has a legend object.

HasPictures

Indicates whether tabsheet contains any picture. Read-only.

(Inherited from XlsWorksheetBase .)

HasPivotTable

Indicates whether contains pivot table.

HasPlotArea

Indicates whether chart has plot area.

HasVmlShapes

Indicates whether worksheet has vml shapes. Read-only.

(Inherited from XlsWorksheetBase .)

HasWalls

Gets value indicating whether floor object was created.

HeaderFooterShapes

Header / footer shapes collection.

(Inherited from XlsWorksheetBase .)

Height

Height of the chart in points (1/72 inch).

HeightPercent

Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).

Index

Returns the index number of the object within the collection of objects.

(Inherited from XlsWorksheetBase .)

IsCategoryAxisAvail

Indicates whether chart has a category axis. Read-only.

IsChart_100

Returns True if chart is 100%. Read-only.

IsChart3D

Returns True if chart is 3D. Read-only.

IsChartBar

Returns True if chart is a bar chart. Read-only.

IsChartBubble

Returns True if chart is a bubble chart. Read-only.

IsChartCone

Returns True if chart is a conical shape. Read-only.

IsChartCylinder

Returns True if chart is a cylinder shape. Read-only.

IsChartDoughnut

Returns True if chart is a doughnut chart. Read-only.

IsChartExploded

Returns True if chart is exploded. Read-only.

IsChartFloor

Returns True if chart has floor. Read-only.

IsChartLine

Returns True if chart is line. Read-only.

IsChartPie

Returns True if chart is a pie chart. Read-only.

IsChartPyramid

Returns True if chart is a pyramid shape. Read-only.

IsChartRadar

Returns True if chart is a radar chart. Read-only.

IsChartScatter

Returns True if chart is a scatter chart. Read-only.

IsChartSmoothedLine

Returns True if chart has smoothed lines. Read-only.

IsChartStock

Returns True if this is a stock chart. Read-only.

IsChartVeryColor

Returns True if chart should have a different color for each series value. Read-only.

IsChartVolume

Returns True if chart is a stock chart with volume. Read-only.

IsChartWalls

Returns True if chart has walls. Read-only.

IsClustered

Returns True if chart is a clustered chart. Read-only.

IsEmbeded

Gets value indicating whether chart is embeded into worksheet.

IsPasswordProtected

True if the worksheet has been protected with password.

(Inherited from XlsWorksheetBase .)

IsPerspective

Returns True if chart has perspective. Read-only.

IsPivot3DChart

Gets a value indicating whether this instance is pivot 3D chart .

IsRightToLeft

Indicates whether worksheet is displayed right to left.

(Inherited from XlsWorksheetBase .)

IsRowColHeadersVisible

Gets or sets whether the worksheet will display row and column headers. Default is true.

(Inherited from XlsWorksheetBase .)

IsSecondaryAxes

Obsolete.

Returns True if at least one of the secondary axes is present. Read-only.

IsSecondaryCategoryAxisAvail

Obsolete.

Returns True if secondary category axis present. Read-only.

IsSecondaryValueAxisAvail

Obsolete.

Returns True if secondary value axis present. Read-only.

IsSelected

Indicates whether tab of this sheet is selected. Read-only.

(Inherited from XlsWorksheetBase .)

IsSeriesAxisAvail

Obsolete.

Indicates if chart has a series axis. Read-only.

IsSeriesLines

Returns True if chart has series lines. Read-only.

IsSpecialDataLabels

Returns True if chart needs special data labels serialization. Read-only.

IsStacked

Returns True if chart is stacked. Read-only.

IsTransitionEvaluation

Gets or sets a value indicating whether transition evaluation is enabled.

(Inherited from XlsWorksheetBase .)

IsValueAxisAvail

Indicates whehter chart has a value axis. Read-only.

LabelShapes

Gets the collection of label shapes in the worksheet.

(Inherited from XlsWorksheetBase .)

LastColumn

Gets or sets index of the last column of the worksheet.

(Inherited from XlsWorksheetBase .)

LastDataColumn

Gets index of the last data column of the worksheet.

(Inherited from XlsWorksheetBase .)

LastDataRow

Gets index of the last data row of the worksheet.

(Inherited from XlsWorksheetBase .)

LastRow

Gets or sets one-based index of the last row of the worksheet.

(Inherited from XlsWorksheetBase .)

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 .)

Legend

Represents chart legend.

Lines

Gets the lines of the chart.

(Inherited from XlsWorksheetBase .)

ListBoxes

Gets the list of list boxes in the workbook.

(Inherited from XlsWorksheetBase .)

Name

Returns or sets the name of the object. Read / write String.

(Inherited from XlsWorksheetBase .)

NeedDataFormat

Returns True if chart needs data format to be saved. Read-only.

NeedDropBar

Returns True if chart needs drop bars to be saved. Read-only.

NeedMarkerFormat

Returns True if chart needs marker format to be saved. Read-only.

NoPlotArea

Returns True if chart has no plot area. Read-only.

OvalShapes

Gets the oval shapes in the worksheet.

(Inherited from XlsWorksheetBase .)

PageSetup

Page setup for the chart. Read-only.

Parent

Reference to Parent object. Read-only.

(Inherited from XlsObject .)

ParentWorkbook

Returns parent workbook. Read-only.

(Inherited from XlsWorksheetBase .)

Perspective

Returns or sets the perspective for the 3-D chart view (0 to 100).

Pictures

Pictures collection. Read-only.

(Inherited from XlsWorksheetBase .)

PivotChartType

Gets or sets the type of the pivot chart.

PivotTable

Gets or sets the pivot source.

PlotArea

Returns plot area frame format. Read-only.

PlotVisibleOnly

True if only visible cells are plotted. False if both visible and hidden cells are plotted.

PrimaryCategoryAxis

Primary category axis. Read-only.

PrimarySerieAxis

Primary serie axis. Read-only.

PrimaryValueAxis

Primary value axis. Read-only.

ProtectContents

Indicates is current sheet is protected.

(Inherited from XlsWorksheetBase .)

ProtectDrawingObjects

True if objects are protected. Read only.

(Inherited from XlsWorksheetBase .)

Protection

Gets protected options. Read-only. For sets protection options use "Protect" method.

(Inherited from XlsWorksheetBase .)

ProtectScenarios

True if the scenarios of the current sheet are protected. Read only.

(Inherited from XlsWorksheetBase .)

PrstGeomShapes

Gets the collection of preset geometric shapes.

(Inherited from XlsWorksheetBase .)

QueryTables

Gets the collection of query tables in the worksheet.

(Inherited from XlsWorksheetBase .)

RadioButtons

Returns inner radiobutton collection. Read-only.

(Inherited from XlsWorksheetBase .)

RealIndex

Index of the worksheet in the workbook (not necessary in Worksheets collection)

(Inherited from XlsWorksheetBase .)

RectangleShapes

Gets the rectangle shapes in the worksheet.

(Inherited from XlsWorksheetBase .)

ReferenceCount

Get quantity of instance references.

(Inherited from XlsObject .)

RightAngleAxes

True if the chart axes are at right angles, independent of chart rotation or elevation.

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).

ScrollBarShapes

Gets the scroll bar shapes associated with the worksheet.

(Inherited from XlsWorksheetBase .)

SecondaryCategoryAxis

Secondary category axis. Read-only.

SecondaryCategoryAxisTitle

Title of the secondary category axis.

SecondaryValueAxis

Secondary value axis. Read-only.

SecondaryValueAxisTitle

Title of the secondary value axis.

SeriesAxisTitle

Title of the series axis.

SeriesDataFromRange

True if series are in rows in DataRange; False otherwise.

Shapes

Shapes collection.

(Inherited from XlsWorksheetBase .)

SheetId

Gets or sets sheetId for this sheet.

(Inherited from XlsWorksheetBase .)

ShowReportFilterFieldButtons

Gets or sets a value indicating whether [show report filter field buttons].

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.

SpinnerShapes

Gets the spinner shapes in the worksheet.

(Inherited from XlsWorksheetBase .)

Style

Style index for Excel 2007 chart.

SupportWallsAndFloor

Indicates whether this chart supports walls and floor. Read-only.

TabColor

Tab color.

(Inherited from XlsWorksheetBase .)

TabColorObject

Tab color.

(Inherited from XlsWorksheetBase .)

TabKnownColor

Tab excel color.

(Inherited from XlsWorksheetBase .)

TextBoxes

Returns inner textboxes collection. Read-only.

(Inherited from XlsWorksheetBase .)

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 .)

TypedArcs

Returns inner Arcs collection. Read-only.

(Inherited from XlsWorksheetBase .)

TypedButtons

Returns inner buttons collection. Read-only.

(Inherited from XlsWorksheetBase .)

TypedCheckBoxes

Returns inner checkboxes collection. Read-only.

(Inherited from XlsWorksheetBase .)

TypedComboBoxes

Returns inner comboboxes collection. Read-only.