Skip to content

Latest commit

 

History

History
41 lines (37 loc) · 3.29 KB

File metadata and controls

41 lines (37 loc) · 3.29 KB

Worksheet

Properties

Name Type Description Notes
index int Gets the index of sheet in the worksheets collection.
pictures LinkElement [optional]
charts LinkElement [optional]
comments LinkElement [optional]
hyperlinks LinkElement [optional]
is_visible bool Represents if the worksheet is visible. [optional]
view_type str Gets and sets the view type. [optional]
type str Represents worksheet type [optional]
is_gridlines_visible bool Gets or sets a value indicating whether the gridelines are visible.Default is true. [optional]
is_row_column_headers_visible bool Gets or sets a value indicating whether the worksheet will display row and column headers.Default is true. [optional]
is_page_break_preview bool Indications the specified worksheet is shown in normal view or page break preview. [optional]
display_zeros bool True if zero values are displayed. [optional]
transition_evaluation bool Flag indicating whether the Transition Formula Evaluation (Lotus compatibility) option is enabled. [optional]
display_right_to_left bool Indicates if the specified worksheet is displayed from right to left instead of from left to right. Default is false. [optional]
first_visible_column int Represents first visible column index. [optional]
ole_objects LinkElement [optional]
is_outline_shown bool Indicates whether show outline. [optional]
name str Gets or sets the name of the worksheet. [optional]
auto_shapes LinkElement [optional]
cells LinkElement [optional]
validations LinkElement [optional]
zoom int Represents the scaling factor in percent. It should be btween 10 and 400. [optional]
conditional_formattings LinkElement [optional]
is_selected bool Indicates whether this worksheet is selected when the workbook is opened. [optional]
tab_color Color Represents worksheet tab color. [optional]
first_visible_row int Represents first visible row index. [optional]
transition_entry bool Flag indicating whether the Transition Formula Entry (Lotus compatibility) option is enabled. [optional]
visibility_type str Indicates the state for this sheet visibility [optional]
is_ruler_visible bool Indicates whether the ruler is visible. Only apply for page break preview. [optional]
links list[Link] [optional]
is_protected bool Indicates if the worksheet is protected.
merged_cells LinkElement [optional]

[Back to Model list] [Back to API list] [Back to README]