ExpertXls Excel Library for .NET

Library API

ExpertXls.ExcelLib

ExcelCellAlignment Class

ExcelCellBorder Class

ExcelCellBorderIndex Enumeration

ExcelCellBordersCollection Class

ExcelCellFill Class

ExcelCellFillGradient Class

ExcelCellFillPattern Class

ExcelCellFillPatternType Enumeration

ExcelCellFillSolid Class

ExcelCellFillType Enumeration

ExcelCellHorizontalAlignmentType Enumeration

ExcelCellLineStyle Enumeration

ExcelCellNumber Class

ExcelCellProtection Class

ExcelCellStyle Class

ExcelCellStylesCollection Class

ExcelCellTextDirectionType Enumeration

ExcelCellUnderlineType Enumeration

ExcelCellVerticalAlignmentType Enumeration

ExcelChart Class

ExcelChartArea Class

ExcelChartAxisLabelPosition Enumeration

ExcelChartCategoryAxis Class

ExcelChartCategoryAxisType Enumeration

ExcelChartDataPoint Class

ExcelChartDataPointLabel Class

ExcelChartDataPointsCollection Class

ExcelChartDataTable Class

ExcelChartFormattedText Class

ExcelChartInterior Class

ExcelChartLegend Class

ExcelChartLegendEntriesCollection Class

ExcelChartLegendEntry Class

ExcelChartLegendPosition Enumeration

ExcelChartLine Class

ExcelChartLineType Enumeration

ExcelChartLineWeightType Enumeration

ExcelChartRotation3D Class

ExcelChartsCollection Class

ExcelChartSeries Class

ExcelChartSeriesAxis Class

ExcelChartSeriesCollection Class

ExcelChartTickMarkType Enumeration

ExcelChartTimeUnit Enumeration

ExcelChartType Enumeration

ExcelChartValueAxis Class

ExcelChartValueDisplayUnits Enumeration

ExcelChartWorksheet Class

ExcelChartWorksheetPageSetup Class

ExcelChartWorksheetsCollection Class

ExcelColorsPalette Class

ExcelComment Class

ExcelCommentsCollection Class

ExcelDataValidator Class

ExcelDataValidatorDataType Enumeration

ExcelDataValidatorErrorStyle Enumeration

ExcelDataValidatorOperator Enumeration

ExcelDeleteShiftDirection Enumeration

ExcelDocumentProperties Class

ExcelDocumentSecurity Class

ExcelFont Class

ExcelGradientColors Enumeration

ExcelGradientDirection Enumeration

ExcelGradientVariants Enumeration

ExcelGroupBy Enumeration

ExcelHyperlink Class

ExcelHyperlinksCollection Class

ExcelHyperlinkType Enumeration

ExcelLibException Class

ExcelNamedRange Class

ExcelNamedRangesCollection Class

ExcelNamedRangeScopeType Enumeration

ExcelPageBreak Class

ExcelPageBreaksCollection Class

ExcelPageBreakType Enumeration

ExcelPageOrientation Enumeration

ExcelPagePaperSize Enumeration

ExcelPagePrintCommLocation Enumeration

ExcelPagePrintErrorsMode Enumeration

ExcelPagePrintOrder Enumeration

ExcelPageSetup Class

ExcelPicture Class

ExcelPicturePlacement Enumeration

ExcelPicturesCollection Class

ExcelProtectionAllowFlags Enumeration

ExcelRange Class

ExcelRangesCollection Class

ExcelShapeFill Class

ExcelShapeFillGradient Class

ExcelShapeFillPattern Class

ExcelShapeFillPatternType Enumeration

ExcelShapeFillPicture Class

ExcelShapeFillPresetGradientType Enumeration

ExcelShapeFillSolid Class

ExcelShapeFillTexture Class

ExcelShapeFillTextureType Enumeration

ExcelShapeFillType Enumeration

ExcelUnitsConverter Class

ExcelWorkbook Class

ExcelWorkbookDefaultSettings Class

ExcelWorkbookFormat Enumeration

ExcelWorksheet Class

ExcelWorksheetPageSetup Class

ExcelWorksheetsCollection Class

ExcelWorksheetSecurity Class

ExcelProtectionAllowFlags Enumeration

The allowed operations for a protected worksheet.

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 7.0.0

Syntax

Copy

[FlagsAttribute]
public enum ExcelProtectionAllowFlags

<FlagsAttribute>
Public Enumeration ExcelProtectionAllowFlags

Members

Member name	Value	Description
NoProtection	0	The worksheet has no protection options.
AllowDefault	17408	The default protection allow selection of locked and unlocked cells
AllowNone	16384	No operation is allowed on a protected worksheet except selecting unlocked cells.
AllowEditObjects	1	Allow edit objects.
AllowEditScenarios	2	Allow edit scenarios.
AllowFormatCells	4	Allow format cells.
AllowFormatColumns	8	Allow format columns.
AllowFormatRows	16	Allow format rows.
AllowInsertColumns	32	Allow insert columns.
AllowInsertRows	64	Allow insert rows.
AllowInsertHyperlinks	128	Allow insert hyperlinks.
AllowDeleteColumns	256	Allow delete columns
AllowDeleteRows	512	Allow delete rows
AllowSelectLockedCells	1024	Allow select locked cells.
AllowSort	2048	Allow sort.
AllowUseAutoFilter	4096	Allow use Auto Filter
AllowUsePivotTable	8192	Allow use Pivot Tables.
AllowSelectUnlockedCells	16384	Allow select unlocked cells.
AllowAll	32767	All operations are allowed for a protected worksheet.

Reference

ExpertXls.ExcelLib Namespace