Spire.XLS API

Spire.XLS namespace

Spire.Xls

AlertStyleType Enumeration

AutoFormatOptions Enumeration

AutoFormatType Enumeration

AverageType Enumeration

AxisLineIdentifierType Enumeration

AxisTextDirectionType Enumeration

AxisType Enumeration

AxisTypes Enumeration

BaseFormatType Enumeration

BookmarkHyperlink Class

BordersLineType Enumeration

BubbleSizeType Enumeration

BuiltInPropertyType Enumeration

BuiltInStyles Enumeration

CategoryType Enumeration

CellBorder Class

CellDataType Enumeration

CellFormatType Enumeration

CellRange Class

CellStyle Class

CellStyleFlag Class

CellStyleObject Class

Chart Class

ChartBackgroundMode Enumeration

ChartBaseUnitType Enumeration

ChartDisplayUnitType Enumeration

ChartExPositionAlignment Enumeration

ChartExSidePosition Enumeration

ChartLinePatternType Enumeration

ChartLineWeightType Enumeration

ChartMarkerType Enumeration

ChartParagraphType Enumeration

ChartPieType Enumeration

ChartPlotEmptyType Enumeration

ChartShadow Class

ChartSheet Class

ChartStyleElements Enumeration

CheckState Enumeration

ColorModel Enumeration

ColorScale Class

ColorType Enumeration

CommentHAlignType Enumeration

CommentVAlignType Enumeration

ComparisonOperatorType Enumeration

CompoundLineType Enumeration

ConditionalFormat Class

ConditionalFormats Class

ConditionalFormatScope Enumeration

ConditionalFormatType Enumeration

ConditionalFormatWrapper Class

ConditionalTopNType Enumeration

ConditionValue Class

ConditionValuePosition Enumeration

ConditionValueType Enumeration

ConnectionDataSourceType Enumeration

ConverterSetting Class

CopyRangeOptions Enumeration

CustomFontData Class

DataBar Class

DataLabelPositionType Enumeration

DataSourceType Enumeration

DBConnection Class

DeleteOption Enumeration

DocumentProperty Class

DropLineStyleType Enumeration

EndLineCap Enumeration

ErrorBarIncludeType Enumeration

ErrorBarType Enumeration

Excel2007DataLabelPos Enumeration

Excel2016Charttype Enumeration

ExcelAddInFunction Class

ExcelCalculationMode Enumeration

ExcelChartType Enumeration

ExcelClearOptions Enumeration

ExcelColors Enumeration

ExcelComboType Enumeration

ExcelComment Class

ExcelCommentObject Class

ExcelFindOptions Enumeration

ExcelFont Class

ExcelGradient Class

ExcelHorizontalAlignment Enumeration

ExcelInterior Class

ExcelPatternType Enumeration

ExcelPicture Class

ExcelQuartileCalculation Enumeration

ExcelSaveType Enumeration

ExcelShapeType Enumeration

ExcelSheetType Enumeration

ExcelTotalsCalculation Enumeration

ExcelTreeMapLabelOption Enumeration

ExcelVersion Enumeration

ExcelVerticalAlignment Enumeration

ExpandCollapseFlags Enumeration

ExportTableOptions Class

ExternalConnection Class

ExternalLink Class

FileFormat Enumeration

FilterConditionType Enumeration

FilterDataType Enumeration

FindType Enumeration

FontCollectionIndex Enumeration

FontUnderlineType Enumeration

FontVertialAlignmentType Enumeration

Format3D Class

GoalSeek Class

GoalSeekResult Class

GradientColorType Enumeration

GradientPatternType Enumeration

GradientPresetType Enumeration

GradientStyleType Enumeration

GradientTextureType Enumeration

GradientVariantsType Enumeration

GroupByType Enumeration

HorizontalAlignType Enumeration

HPageBreak Class

HttpContentType Enumeration

HyperLink Class

HyperLinkType Enumeration

IConditionValue Interface

IconSet Class

IconSetType Enumeration

IgnoreErrorType Enumeration

ImageFormatType Enumeration

ImageType Enumeration

ImportObjectOptions Class

InsertMoveOption Enumeration

InsertOptionsType Enumeration

IPropertyData Interface

LegendPositionType Enumeration

LegendSpacingType Enumeration

LineShapeType Enumeration

LineStyleType Enumeration

MarkerDesigner Class

MeasureUnits Enumeration

MsoPathType Enumeration

OColor Class

OdsPageBackground Class

OdsPageBackgroundImagePositionType Enumeration

OdsPageBackgroundImageType Enumeration

OdsPageBackgroundType Enumeration

OLEDBCommandType Enumeration

OleLinkType Enumeration

OleObjectType Enumeration

OrderBy Enumeration

OrderType Enumeration

PageBreakExtentType Enumeration

PageBreakType Enumeration

PageColRow Structure

PageImagePaintedEventArgs Class

PageImagePaintedHandler Delegate

PageOrientationType Enumeration

PageSetup Class

PagesOrderType Enumeration

PaperSizeType Enumeration

PathFillMode Enumeration

PivotAutoFomatTypes Enumeration

PivotBuiltInStyles Enumeration

PivotCache Class

PivotDataType Enumeration

PivotField Class

PivotFieldFormatType Enumeration

PivotFieldSortType Enumeration

PivotGroupByTypes Enumeration

PivotItemType Enumeration

PivotLabelFilterType Enumeration

PivotPageAreaFieldsOrderType Enumeration

PivotTable Class

PivotTableElement Enumeration

PivotTableFields Class

PivotTableLayoutType Enumeration

PivotValueFilterType Enumeration

PresetTextEffect Enumeration

PrintCommentType Enumeration

PrintErrorsType Enumeration

PrintingPageType Enumeration

PropertyType Enumeration

PrstGeomShapeType Enumeration

QueryTableXls Class

ReadingOrderType Enumeration

RectangleShapeType Enumeration

RectangleStyleType Enumeration

ReferRangeArea Class

RenameStrategy Enumeration

ResizeBehaveType Enumeration

RichText Class

RichTextObject Class

SaveShapeTypeOption Class

SelectionType Enumeration

ShapeArrowLengthType Enumeration

ShapeArrowStyleType Enumeration

ShapeArrowWidthType Enumeration

ShapeDashLineStyleType Enumeration

ShapeFillType Enumeration

ShapeGlow Class

ShapeLayerChangeType Enumeration

ShapeLineStyleType Enumeration

ShapeReflection Class

SheetProtectionType Enumeration

SlicerCacheCrossFilterType Enumeration

SortComparsionType Enumeration

SortedWayType Enumeration

SortOrientationType Enumeration

Sparkline Class

SparklineCollection Class

SparklineEmptyCells Enumeration

SparklineGroup Class

SparklineGroupCollection Class

SparklineType Enumeration

SpartlineVerticalAxisType Enumeration

SplitType Enumeration

StyleEntryModifierEnum Enumeration

SubtotalTypes Enumeration

TableBuiltInStyles Enumeration

TextDirection Enumeration

TextRotationType Enumeration

TextSaveOptions Class

TextVerticalValue Enumeration

ThemeColorType Enumeration

TickLabelPositionType Enumeration

TickMarkType Enumeration

TopBottomType Enumeration

TopFormatType Enumeration

TrendLineType Enumeration

UnknownVariableAction Enumeration

Validation Class

ValidationComparisonOperator Enumeration

VariableTypeAction Enumeration

VerticalAlignType Enumeration

ViewMode Enumeration

VPageBreak Class

WebQueryConnection Class

Workbook Class

Worksheet Class

WorksheetCopyType Enumeration

WorksheetVisibility Enumeration

XlsConditionValue Class

XlsDocumentProperty Class

XlsSlicer Class

XlsSlicerCache Class

XlsSlicerCacheItem Class

XlsSlicerCacheItemCollection Class

XlsSlicerCollection Class

XLSXBorderJoinType Enumeration

XLSXChartBevelType Enumeration

XLSXChartLightingType Enumeration

XLSXChartMaterialType Enumeration

XLSXChartPrespectiveType Enumeration

XLSXChartShadowInnerType Enumeration

XLSXChartShadowOuterType Enumeration

XLSXPivotItemType Enumeration

XmlOpenType Enumeration

SheetProtectionType Enumeration

Represents sheet protection flags enums.

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

C++

ASP.NET

Copy

[FlagsAttribute]
public enum SheetProtectionType

<FlagsAttribute>
Public Enumeration SheetProtectionType

[FlagsAttribute]
public enum class SheetProtectionType

[<FlagsAttribute>]
type SheetProtectionType

Members

Member name	Value	Description
None	0	Not allows the user to do any thing on a protected worksheet.
Objects	1	True to protect shapes.
Scenarios	2	True to protect scenarios.
FormattingCells	4	True allows the user to format any cell on a protected worksheet.
FormattingColumns	8	True allows the user to format any column on a protected worksheet.
FormattingRows	16	True allows the user to format any row on a protected.
InsertingColumns	32	True allows the user to insert columns on the protected worksheet.
InsertingRows	64	True allows the user to insert rows on the protected worksheet.
InsertingHyperlinks	128	True allows the user to insert hyperlinks on the worksheet.
DeletingColumns	256	True allows the user to delete columns on the protected worksheet, where every cell in the column to be deleted is unlocked.
DeletingRows	512	True allows the user to delete rows on the protected worksheet, where every cell in the row to be deleted is unlocked.
LockedCells	1024	True allows the user to select locked cells on the protected worksheet.
Sorting	2048	True allows the user to sort on the protected worksheet.
Filtering	4096	True allows the user to set filters on the protected worksheet. Users can change filter criteria but can not enable or disable an auto filter.
UsingPivotTables	8192	True allows the user to use pivot table reports on the protected worksheet.
UnLockedCells	16384	True allows the user to select locked cells on the protected worksheet.
Content	32768	Represents all flags
All	65535	Allows the user to do any thing on a protected worksheet.

Reference

Spire.Xls Namespace