Export (0) Print
Expand All

ProtectedRanges class

Defines the ProtectedRanges Class. When the object is serialized out as xml, its qualified name is x:protectedRanges.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

public class ProtectedRanges : OpenXmlCompositeElement

[ISO/IEC 29500-1 1st Edition]

protectedRanges (Protected Ranges)

This collection specifies all protected ranges on this worksheet.


This example demonstrates that A1:C5 have been protected, with no password specified.

  <protectedRange sqref="A1:C5" name="Range1"/>

end example]

Parent Elements

worksheet (§

Child Elements


protectedRange (Protected Range)


[Note: The W3C XML Schema definition of this element’s content model (CT_ProtectedRanges) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

© 2014 Microsoft