ChartSheet Class |
Namespace: Spire.Xls
The ChartSheet type exposes the following members.
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.
(Inherited from
XlsChart
.)
|
![]() |
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.
(Inherited from
XlsChart
.)
|
![]() |
CanChartHaveSeriesLines |
Returns True if chart can have series lines. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
CanChartPercentageLabel |
Returns True if chart can have percentage data labels. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
CategoryAxisTitle |
Title of the category axis.
(Inherited from
XlsChart
.)
|
![]() |
CellImages |
Cell image array. Read-only.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
ChartArea |
Returns an object that represents the complete chart area for the chart.
|
![]() |
Charts |
Returns charts collection. Read-only.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
ChartStartType |
Returns start type of chart type. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
ChartTitle |
Title of the chart.
(Inherited from
XlsChart
.)
|
![]() |
ChartTitleArea |
Gets title text area. Read-only.
|
![]() |
ChartTitleFont |
Returns object that describes chart title area. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
ChartType |
Type of the chart.
(Inherited from
XlsChart
.)
|
![]() |
CheckBoxes |
Returns inner checkboxes collection. Read-only.
|
![]() |
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 |
Represents comments collection for the worksheet. Read-only.
|
![]() |
DataRange |
DataRange for the chart series.
|
![]() |
DataTable |
Returns a DataTable object that represents the chart data table.
|
![]() |
DefaultGridlineColor |
Indicates whether gridline color has default value.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
DefaultLinePattern |
Returns default line pattern for the chart. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
DefaultTextIndex |
Obsolete.
Gets font index from the default font records.
(Inherited from
XlsChart
.)
|
![]() |
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
.)
|
![]() |
DestinationType |
Gets chart type after type change.
(Inherited from
XlsChart
.)
|
![]() |
DisplayAxisFieldButtons |
Gets or sets a value indicating whether [show axis field buttons].
(Inherited from
XlsChart
.)
|
![]() |
DisplayBlanksAs |
Represents the way that blank cells are plotted on a chart.
(Inherited from
XlsChart
.)
|
![]() |
DisplayEntireFieldButtons |
Gets or sets a value indicating whether [show all field buttons].
(Inherited from
XlsChart
.)
|
![]() |
DisplayLegendFieldButtons |
Gets or sets a value indicating whether [show legend field buttons].
(Inherited from
XlsChart
.)
|
![]() |
DisplayValueFieldButtons |
Gets or sets a value indicating whether [show value field buttons].
(Inherited from
XlsChart
.)
|
![]() |
Elevation |
Returns or sets the elevation of the 3-D chart view, in degrees (?0 to +90 degrees).
(Inherited from
XlsChart
.)
|
![]() |
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 |
Returns a Floor object that represents the floor of the 3-D chart
|
![]() |
Font |
Gets font which used for displaying axis text .
(Inherited from
XlsChart
.)
|
![]() |
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
.)
|
![]() ![]() |
GridLineColor |
Grid line color.
(Inherited from
XlsWorksheetBase
.)
![]()
The following code illustrates how to set the grid line color:
<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>
|
![]() |
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.
(Inherited from
XlsChart
.)
|
![]() |
HasChartTitle |
Indicates wheather the chart has title
(Inherited from
XlsChart
.)
|
![]() |
HasDataTable |
True if the chart has a data table.
(Inherited from
XlsChart
.)
|
![]() |
HasFloor |
Gets value indicating whether floor object was created.
(Inherited from
XlsChart
.)
|
![]() |
HasLegend |
True if the chart has a legend object.
(Inherited from
XlsChart
.)
|
![]() |
HasPictures |
Indicates whether tabsheet contains any picture. Read-only.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
HasPivotTable |
Indicates whether contains pivot table.
(Inherited from
XlsChart
.)
|
![]() |
HasPlotArea |
Indicates whether chart has plot area.
(Inherited from
XlsChart
.)
|
![]() |
HasVmlShapes |
Indicates whether worksheet has vml shapes. Read-only.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
HasWalls |
Gets value indicating whether floor object was created.
(Inherited from
XlsChart
.)
|
![]() |
HeaderFooterShapes |
Header / footer shapes collection.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
Height |
Height of the chart in points (1/72 inch).
(Inherited from
XlsChart
.)
|
![]() |
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
.)
|
![]() |
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.
(Inherited from
XlsChart
.)
|
![]() |
IsChart_100 |
Returns True if chart is 100%. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChart3D |
Returns True if chart is 3D. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartBar |
Returns True if chart is a bar chart. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartBubble |
Returns True if chart is a bubble chart. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartCone |
Returns True if chart is a conical shape. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartCylinder |
Returns True if chart is a cylinder shape. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartDoughnut |
Returns True if chart is a doughnut chart. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartExploded |
Returns True if chart is exploded. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartFloor |
Returns True if chart has floor. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartLine |
Returns True if chart is line. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartPie |
Returns True if chart is a pie chart. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartPyramid |
Returns True if chart is a pyramid shape. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartRadar |
Returns True if chart is a radar chart. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartScatter |
Returns True if chart is a scatter chart. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartSmoothedLine |
Returns True if chart has smoothed lines. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartStock |
Returns True if this is a stock chart. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartVeryColor |
Returns True if chart should have a different color for each series value. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartVolume |
Returns True if chart is a stock chart with volume. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsChartWalls |
Returns True if chart has walls. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsClustered |
Returns True if chart is a clustered chart. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsEmbeded |
Gets value indicating whether chart is embeded into worksheet.
(Inherited from
XlsChart
.)
|
![]() |
IsPasswordProtected |
True if the worksheet has been protected with password.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
IsPerspective |
Returns True if chart has perspective. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsPivot3DChart |
Gets a value indicating whether this instance is pivot 3D chart .
(Inherited from
XlsChart
.)
|
![]() |
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.
(Inherited from
XlsChart
.)
|
![]() |
IsSecondaryCategoryAxisAvail |
Obsolete.
Returns True if secondary category axis present. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsSecondaryValueAxisAvail |
Obsolete.
Returns True if secondary value axis present. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
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.
(Inherited from
XlsChart
.)
|
![]() |
IsSeriesLines |
Returns True if chart has series lines. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsSpecialDataLabels |
Returns True if chart needs special data labels serialization.
Read-only.
(Inherited from
XlsChart
.)
|
![]() |
IsStacked |
Returns True if chart is stacked. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
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.
(Inherited from
XlsChart
.)
|
![]() |
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.
(Inherited from
XlsWorksheetBase
.)
![]()
The following code illustrates how to set the left visible column:
<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>
|
![]() |
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.
(Inherited from
XlsChart
.)
|
![]() |
NeedDropBar |
Returns True if chart needs drop bars to be saved. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
NeedMarkerFormat |
Returns True if chart needs marker format to be saved. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
NoPlotArea |
Returns True if chart has no plot area. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
OvalShapes |
Gets the oval shapes in the worksheet.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
PageSetup |
Page setup for the chart.
|
![]() |
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).
(Inherited from
XlsChart
.)
|
![]() |
Pictures |
Pictures collection. Read-only.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
PivotChartType |
Gets or sets the type of the pivot chart.
(Inherited from
XlsChart
.)
|
![]() |
PivotTable |
Gets or sets the pivot source.
(Inherited from
XlsChart
.)
|
![]() |
PlotArea |
Returns a PlotArea object that represents the plot area of a chart.
|
![]() |
PlotVisibleOnly |
True if only visible cells are plotted. False if both visible and hidden cells are plotted.
(Inherited from
XlsChart
.)
|
![]() |
PrimaryCategoryAxis |
Returns primary category axis.
|
![]() |
PrimarySerieAxis |
Returns primary series axis.
|
![]() |
PrimaryValueAxis |
Returns primary value axis.
|
![]() |
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.
(Inherited from
XlsChart
.)
|
![]() |
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
.)
|
![]() |
ScrollBarShapes |
Gets the scroll bar shapes associated with the worksheet.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
SecondaryCategoryAxis |
Returns secondary category axis.
|
![]() |
SecondaryCategoryAxisTitle |
Title of the secondary category axis.
(Inherited from
XlsChart
.)
|
![]() |
SecondaryValueAxis |
Returns secondary value axis.
|
![]() |
SecondaryValueAxisTitle |
Title of the secondary value axis.
(Inherited from
XlsChart
.)
|
![]() |
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.
|
![]() |
SeriesAxisTitle |
Title of the series axis.
(Inherited from
XlsChart
.)
|
![]() |
SeriesDataFromRange |
True if series are in rows in DataRange;
False otherwise.
(Inherited from
XlsChart
.)
|
![]() |
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].
(Inherited from
XlsChart
.)
|
![]() |
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
.)
|
![]() |
SpinnerShapes |
Gets the spinner shapes in the worksheet.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
Style |
Style index for Excel 2007 chart.
(Inherited from
XlsChart
.)
|
![]() |
SupportWallsAndFloor |
Indicates whether this chart supports walls and floor. Read-only.
(Inherited from
XlsChart
.)
|
![]() |
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.
|
![]() ![]() |
TopVisibleRow |
Gets/sets top visible row of the worksheet.
(Inherited from
XlsWorksheetBase
.)
![]()
The following code illustrates how to set the top visible row:
<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>
|
![]() |
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.
(Inherited from
XlsChart
.)
|
![]() |
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.
|
![]() |
WallsAndGridlines2D |
True if gridlines are drawn two-dimensionally on a 3-D chart.
(Inherited from
XlsChart
.)
|
![]() |
Width |
Width of the chart in points (1/72 inch).
(Inherited from
XlsChart
.)
|
![]() |
Workbook |
Workbook which contains the chart.
|
![]() |
XPos |
X coordinate of the upper-left corner
of the chart in points (1/72 inch).
(Inherited from
XlsChart
.)
|
![]() |
YPos |
Y coordinate of the upper-left corner
of the chart in points (1/72 inch).
(Inherited from
XlsChart
.)
|
![]() |
Zoom |
Zoom factor of document.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
ZoomToFit |
Gets or sets zoomToFit value.
(Inherited from
XlsChart
.)
|
Name | Description | |
---|---|---|
![]() |
Activate |
Makes the current sheet the active sheet. Equivalent to clicking the
sheet's tab in MS Excel.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
AddReference |
Increase the quantity of reference. User must use this method when
new wrapper on object is created or reference on object stored.
(Inherited from
XlsObject
.)
|
![]() |
AddTextEffectShape |
Adds a text effect shape to the worksheet.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
CheckDisposed |
Checks whether object was disposed and throws exception if it was.
(Inherited from
XlsObject
.)
|
![]() |
CheckForSupportGridLine |
Chacks for existing gridlines in chart.
(Inherited from
XlsChart
.)
|
![]() |
ClearCellImageCache |
Clear Cell image array cache,not delete CellImage in cell.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
Clone(Object) |
Clones current instance.
(Inherited from
XlsChart
.)
|
![]() |
Clone(Dictionary String, String , Object, Dictionary Int32, Int32 ) |
Obsolete.
Clones current instance.
(Inherited from
XlsChart
.)
|
![]() |
Dispose |
Dispose object and free resources.
(Inherited from
XlsObject
.)
|
![]() |
Equals |
Determines whether the specified object is equal to the current object.
(Inherited from
Object
.)
|
![]() |
Finalize |
Destructor. Call dispose method of current object.
(Inherited from
XlsObject
.)
|
![]() |
FindParent(Type) |
This method is used to find parent with specific type.
(Inherited from
XlsObject
.)
|
![]() |
FindParent( Type ) |
Find parent of object.
(Inherited from
XlsObject
.)
|
![]() |
FindParent(Type, Boolean) |
This method is used to find parent with specific type.
(Inherited from
XlsObject
.)
|
![]() |
FindParents |
Finds parent objects.
(Inherited from
XlsObject
.)
|
![]() |
GetHashCode |
Serves as the default hash function.
(Inherited from
Object
.)
|
![]() |
GetType |
Gets the
Type
of the current instance.
(Inherited from
Object
.)
|
![]() |
InitializeCollections |
Initializes the collections used by the derived class.
(Inherited from
XlsChart
.)
|
![]() |
MemberwiseClone |
Creates a shallow copy of the current
Object
.
(Inherited from
Object
.)
|
![]() |
MoveChartsheet |
Moves chartsheet into new position.
(Inherited from
XlsChart
.)
|
![]() |
MoveSheet |
Moves sheet into new position, including chartsheet and worksheet.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
OnDispose |
Method which can be overriden by users to take any specific actions when
object is disposed.
(Inherited from
XlsObject
.)
|
![]() ![]() |
Protect(String) |
Protects worksheet with password.protect the sheet except select lock/unlock cells.
(Inherited from
XlsWorksheetBase
.)
![]()
The following code illustrates how to protect the sheet except select lock/unlock cells:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Protects the first worksheet's content with password</para><para>worksheet.Protect("123456");</para><para>//Save to file</para><para>workbook.SaveToFile("Protect.xlsx");</para>
|
![]() |
Protect(String, SheetProtectionType) |
Protects worksheet with password.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
ReleaseReference |
Decrease quantity of Reference. User must call this method
when freeing resources.
(Inherited from
XlsObject
.)
|
![]() |
Select |
Selects current tab sheet.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
SelectTab |
Adds sheet tab to the selected tab.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
SetChanged |
This method should be called after any changes in the worksheet.
Sets Saved property of the parent workbook to false.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
SetParent |
Sets parent of the object.
(Inherited from
XlsObject
.)
|
![]() |
SetToDefaultGridlines |
Sets to default chart grid lines on chart type or serie type changing.
(Inherited from
XlsChart
.)
|
![]() |
ToString |
Returns a string that represents the current object.
(Inherited from
Object
.)
|
![]() |
ToSVGStream |
Convert chart to Svg stream
|
![]() |
Unprotect |
Unprotects this wokrsheet.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
Unprotect(String) |
Unprotects this worksheet using specified password.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
Unselect |
Unselects current tab sheet if possible.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
Unselect(Boolean) |
Unselects current tab sheet if possible.
(Inherited from
XlsWorksheetBase
.)
|
Name | Description | |
---|---|---|
![]() |
m_bIsDisposed |
Flag which indicates if the object was disposed or not.
(Inherited from
XlsObject
.)
|
![]() |
m_book |
Represents the workbook object.
(Inherited from
XlsChart
.)
|
![]() |
m_iFirstColumn |
The first column index, initialized to the default minimum column index.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
m_iFirstRow |
One field from Worksheet dimension records.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
m_iLastColumn |
One field from Worksheet dimension records.
(Inherited from
XlsWorksheetBase
.)
|
![]() |
m_iLastRow |
One field from Worksheet dimension records
(Inherited from
XlsWorksheetBase
.)
|