SpreadsheetDocument

Properties:

Areas
BackgroundPicture
BlackAndWhite
BlackAndWhiteView
BottomMargin
Collate
Copies
CurrentArea
Drawings
DuplexPrinting
EmbeddedTables
FitToPage
FixedBackground
FixedLeft
FixedTop
Footer
FooterSize
Header
HeaderSize
LeftMargin
Output
PageHeight
PageOrientation
PagePlacementAlternation
PageSize
PageWidth
Parameters
PerPage
PrintAccuracy
PrintArea
PrinterName
PrintParametersKey
PrintScale
Protection
ReadOnly
RepeatOnColumnPrint
RepeatOnRowPrint
RightMargin
SaveViewProperties
SelectedAreas
ShowGrid
ShowGroups
ShowHeaders
StepDirection
TableHeight
TableWidth
Template
TemplateLanguageCode
TopMargin
TotalsBelow
TotalsRight
UsedFileName
WindowOptionsKey

Methods:

Area
BeginWriting
CheckAttachment
CheckPut
Clear
ColumnGroupLevelCount
DeleteArea
EndColumnAutoGrouping
EndColumnGroup
EndRowAutoGrouping
EndRowGroup
FindText
FindValue
GetArea
Hide
InsertArea
Join
PageCount
Print
Put
PutHorizontalPageBreak
PutVerticalPageBreak
Read
RowGroupLevelCount
Show
ShowColumnGroupLevel
ShowRowGroupLevel
StartColumnAutoGrouping
StartColumnGroup
StartRowAutoGrouping
StartRowGroup
Write

Constructors:

Default

Description:

You can use it to access properties and methods of a spreadsheet document in general. Using this object you can manage general characteristics of a spreadsheet document, as well as link other spreadsheet documents to this one, group rows and columns of a spreadsheet document.
For a spreadsheet document, default language is set by the system.

Availability:

Thin client, web-client, server, thick client, external connection, Mobile application (client), Mobile application (server).
Serializable. Can be used in attributes of managed form. The given object may be serialized to/from XDTO. The XDTO type correspoding to this object is defined in {http://v8.1c.ru/8.2/data/spreadsheet} namespace. XDTO type name: SpreadsheetDocument.

    

1C:Enterprise Developer's Community