Struct FSCPOI@1.1001:Sheet

A single sheet within the workbook

Properties

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

Display Automatic Page Breaks (FSCPOI@1.1001:autobreaks)

If true automatic page breaks are displayed on the sheet.

boolean FSCPOI@1.1001:autobreaks

Enable Automatic Filters (FSCPOI@1.1001:autofilters)

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

boolean FSCPOI@1.1001:autofilters

Adjust Column Width Automatically (FSCPOI@1.1001:autosizecolwidth)

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

boolean FSCPOI@1.1001:autosizecolwidth

Adjust Row Height Automatically (FSCPOI@1.1001:autosizerowheight)

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

boolean FSCPOI@1.1001:autosizerowheight

Defined Column Widths (FSCPOI@1.1001:colwidths)

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

Default Column Width (in Characters) (FSCPOI@1.1001:defaultcolwidth)

The default width of a column in characters.

unsigned integer FSCPOI@1.1001:defaultcolwidth

Default Row Height (in Points) (FSCPOI@1.1001:defaultrowheight)

The default height of a row in points.

unsigned integer FSCPOI@1.1001:defaultrowheight

Column Index for Freeze Pane (FSCPOI@1.1001:freezepanecolindex)

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

Row Index for Freeze Pane (FSCPOI@1.1001:freezepanerowindex)

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

Keep Formatting if Worksheet Already Exists (FSCPOI@1.1001:keepformatting)

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

Landscape (FSCPOI@1.1001:printlandscape)

true if the sheet should be printed in landscape mode.

boolean FSCPOI@1.1001:printlandscape

Paper Size (FSCPOI@1.1001:printpapersize)

The desired paper size.

PrintPaperSize FSCPOI@1.1001:printpapersize

Column Types (FSCPOI@1.1001:sheetcoltypes)

A list of type definitions, which define what type a value is representing. Possible values for types include: #STRING, #INTEGER, #GENERAL, #FLOAT, #BOOLEAN, #DATETIME, #FORMULA, #Currency.

unique ComponentObject[] FSCPOI@1.1001:sheetcoltypes

Additional Information

Object Classes Allowed: TypeDefinition, AttributeDefinition

Column Headings (FSCPOI@1.1001:sheetheadings)

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

Formats of Column Headings (FSCPOI@1.1001:sheetheadingsformats)

Formats for the sheet's headings.

unique CellFormat[] FSCPOI@1.1001:sheetheadingsformats

Hide Worksheet (FSCPOI@1.1001:sheethidden)

true if the sheet is hidden within the workbook.

boolean FSCPOI@1.1001:sheethidden

Worksheet Name (FSCPOI@1.1001:sheetname)

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

Worksheet Rows (FSCPOI@1.1001:sheetrows)

A list of rows within a sheet.

SheetRow[] FSCPOI@1.1001:sheetrows