2022 April Release

Struct FSCPOI@1.1001:Sheet Permanent link for this heading

A single sheet within the workbook

Additional Information

Properties Permanent link for this heading

Type

Property

Name

boolean

autobreaks

Display Automatic Page Breaks

boolean

autofilters

Enable Automatic Filters

boolean

autosizecolwidth

Adjust Column Width Automatically

boolean

autosizerowheight

Adjust Row Height Automatically

integer[]

colwidths

Defined Column Widths

integer

defaultcolwidth

Default Column Width (in Characters)

integer

defaultrowheight

Default Row Height (in Points)

integer

freezepanecolindex

Column Index for Freeze Pane

integer

freezepanerowindex

Row Index for Freeze Pane

boolean

keepformatting

Keep Formatting if Worksheet Already Exists

boolean

printlandscape

Landscape

PrintPaperSize

printpapersize

Paper Size

ComponentObject[]

sheetcoltypes

Column Types

string[]

sheetheadings

Column Headings

CellFormat[]

sheetheadingsformats

Formats of Column Headings

boolean

sheethidden

Hide Worksheet

string

sheetname

Worksheet Name

SheetRow[]

sheetrows

Worksheet Rows

Properties Permanent link for this heading


Display Automatic Page Breaks (FSCPOI@1.1001:autobreaks) Permanent link for this heading

If true automatic page breaks are displayed on the sheet.

boolean FSCPOI@1.1001:autobreaks

Additional Information


Enable Automatic Filters (FSCPOI@1.1001:autofilters) Permanent link for this heading

If true automatic filters are applied to the sheet's headings.

boolean FSCPOI@1.1001:autofilters

Additional Information


Adjust Column Width Automatically (FSCPOI@1.1001:autosizecolwidth) Permanent link for this heading

true if the width of all columns is automatically calculated after all values are written to the sheet.

boolean FSCPOI@1.1001:autosizecolwidth

Additional Information


Adjust Row Height Automatically (FSCPOI@1.1001:autosizerowheight) Permanent link for this heading

true if the height of all rows is automatically calculated after all values are written to the sheet.

boolean FSCPOI@1.1001:autosizerowheight

Additional Information


Defined Column Widths (FSCPOI@1.1001:colwidths) Permanent link for this heading

A list of integers, which defines the individual width of the columns in characters. If an entry is 0 and autosizecolwidth is true, the width is calculated from the values in the column, otherwise the default width is used.

unsigned integer[] FSCPOI@1.1001:colwidths

Additional Information


Default Column Width (in Characters) (FSCPOI@1.1001:defaultcolwidth) Permanent link for this heading

The default width of a column in characters.

unsigned integer FSCPOI@1.1001:defaultcolwidth

Additional Information


Default Row Height (in Points) (FSCPOI@1.1001:defaultrowheight) Permanent link for this heading

The default height of a row in points.

unsigned integer FSCPOI@1.1001:defaultrowheight

Additional Information


Column Index for Freeze Pane (FSCPOI@1.1001:freezepanecolindex) Permanent link for this heading

Index of the column that marks the end of the freeze pane. Use 1 to freeze the first column.

unsigned integer FSCPOI@1.1001:freezepanecolindex

Additional Information


Row Index for Freeze Pane (FSCPOI@1.1001:freezepanerowindex) Permanent link for this heading

Index of the row that marks the end of the freeze pane. Use 1 to freeze the sheet's headings.

unsigned integer FSCPOI@1.1001:freezepanerowindex

Additional Information


Keep Formatting if Worksheet Already Exists (FSCPOI@1.1001:keepformatting) Permanent link for this heading

If true and the sheet already exists in a workbook, the formatting of the heading row and the first value row is used for the heading and all value rows. If sheetheadingsformats is specified for a sheet's heading this format is used. If rowcellformats is specified for a sheet's cell this format is used.

boolean FSCPOI@1.1001:keepformatting

Additional Information


Landscape (FSCPOI@1.1001:printlandscape) Permanent link for this heading

true if the sheet should be printed in landscape mode.

boolean FSCPOI@1.1001:printlandscape

Additional Information


Paper Size (FSCPOI@1.1001:printpapersize) Permanent link for this heading

The desired paper size.

PrintPaperSize FSCPOI@1.1001:printpapersize

Additional Information


Column Types (FSCPOI@1.1001:sheetcoltypes) Permanent link for this heading

A list of type definitions, which define what type a value is representing. e.g. #STRING, #INTEGER, ...

unique ComponentObject[] FSCPOI@1.1001:sheetcoltypes

Additional Information


Column Headings (FSCPOI@1.1001:sheetheadings) Permanent link for this heading

A list of strings which make the sheet's headings, which is written in the first row of the sheet.

string[] FSCPOI@1.1001:sheetheadings

Additional Information


Formats of Column Headings (FSCPOI@1.1001:sheetheadingsformats) Permanent link for this heading

Formats for the sheet's headings.

unique CellFormat[] FSCPOI@1.1001:sheetheadingsformats

Additional Information


Hide Worksheet (FSCPOI@1.1001:sheethidden) Permanent link for this heading

true if the sheet is hidden within the workbook.

boolean FSCPOI@1.1001:sheethidden

Additional Information


Worksheet Name (FSCPOI@1.1001:sheetname) Permanent link for this heading

The sheet's name. If there is already a sheet with the given name within the source workbook document, the new sheet overwrites the existing one.

string FSCPOI@1.1001:sheetname

Additional Information


Worksheet Rows (FSCPOI@1.1001:sheetrows) Permanent link for this heading

A list of rows within a sheet.

unique SheetRow[] FSCPOI@1.1001:sheetrows

Additional Information