OfficeIMO

API Reference

Class

ExcelWorksheetSnapshot

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Immutable worksheet inspection snapshot.

Inheritance

  • Object
  • ExcelWorksheetSnapshot

Constructors

public ExcelWorksheetSnapshot() #

Properties

public String Name { get; set; } #

Worksheet name.

public Int32 Index { get; set; } #

Zero-based worksheet index in workbook order.

public Boolean Hidden { get; set; } #

Whether the worksheet is hidden.

public Boolean RightToLeft { get; set; } #

Whether the worksheet is displayed right-to-left.

public String TabColorArgb { get; set; } #

Worksheet tab color in ARGB hexadecimal form, when present.

public Int32 FrozenRowCount { get; set; } #

Number of frozen rows detected on the worksheet.

public Int32 FrozenColumnCount { get; set; } #

Number of frozen columns detected on the worksheet.

public String UsedRangeA1 { get; set; } #

Used-range address in A1 notation.

public IReadOnlyList<ExcelCellSnapshot> Cells { get; } #

Non-empty cells discovered during inspection.

public IReadOnlyList<ExcelMergedRangeSnapshot> MergedRanges { get; } #

Merged ranges discovered during inspection.

public IReadOnlyList<ExcelColumnSnapshot> Columns { get; } #

Explicit column definitions discovered during inspection.

public IReadOnlyList<ExcelRowSnapshot> Rows { get; } #

Explicit row definitions discovered during inspection.

public IReadOnlyList<ExcelDataValidationSnapshot> Validations { get; } #

Worksheet data validations discovered during inspection.

public ExcelAutoFilterSnapshot AutoFilter { get; set; } #

Worksheet-level auto filter discovered during inspection, when present.

public ExcelWorksheetProtectionSnapshot Protection { get; set; } #

Worksheet protection discovered during inspection, when present.

public IReadOnlyList<ExcelTableSnapshot> Tables { get; } #

Tables discovered on the worksheet.