WorksheetCollection Class

WorksheetCollection class

Encapsulates a collection of objects.

type WorksheetCollection struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
GetWebExtensionTaskPanes	Gets the list of task panes.
GetWebExtensions	Gets the list of task panes.
GetThreadedCommentAuthors	Gets the list of threaded comment authors.
IsRefreshAllConnections	Indicates whether refresh all connections on opening file in MS Excel.
SetIsRefreshAllConnections	Indicates whether refresh all connections on opening file in MS Excel.
CreateRange	Creates a Range object from an address of the range.
CreateUnionRange	Creates a Range object from an address of the range.
GetNames	Gets the collection of all the Name objects in the spreadsheet.
Get_Int	Gets the Worksheet element at the specified index.
Get_String	Gets the Worksheet element with the specified name.
GetSheetByCodeName	Gets the worksheet by the code name.
GetActiveSheetName	Represents the name of active worksheet when the spreadsheet is opened.
SetActiveSheetName	Represents the name of active worksheet when the spreadsheet is opened.
GetActiveSheetIndex	Represents the index of active worksheet when the spreadsheet is opened.
SetActiveSheetIndex	Represents the index of active worksheet when the spreadsheet is opened.
SortNames	Sorts the defined names.
Insert_Int_SheetType	Insert a worksheet.
Insert_Int_SheetType_String	Insert a worksheet.
Add_SheetType	Adds a worksheet to the collection.
SwapSheet	Swaps the two sheets.
Add	Adds a worksheet to the collection.
Add_String	Adds a worksheet to the collection.
RegisterAddInFunction_String_String_Bool	Adds addin function into the workbook
RegisterAddInFunction_Int_String	Adds addin function into the workbook
RemoveAt_String	Removes the element at a specified name.
RemoveAt_Int	Removes the element at a specified index.
Clear	Clear all worksheets.
AddCopy_String	Adds a worksheet to the collection and copies data from an existed worksheet.
AddCopy_Int	Adds a worksheet to the collection and copies data from an existed worksheet.
GetDxfs	Gets the master differential formatting records.
GetRangeByName_String	Gets Range object by pre-defined name.
GetRangeByName_String_Int_Bool	Gets Range by pre-defined name or table’s name
GetNamedRanges	Gets all pre-defined named ranges in the spreadsheet.
GetNamedRangesAndTables	Gets all pre-defined named ranges in the spreadsheet.
GetXmlMaps	Gets and sets the XML maps in the workbook.
SetXmlMaps	Gets and sets the XML maps in the workbook.
GetBuiltInDocumentProperties	Returns a DocumentProperty collection that represents all the built-in document properties of the spreadsheet.
GetCustomDocumentProperties	Returns a DocumentProperty collection that represents all the custom document properties of the spreadsheet.
GetOleSize	Gets and Sets displayed size when Workbook file is used as an Ole object.
SetOleSize_Object	Gets and Sets displayed size when Workbook file is used as an Ole object.
SetOleSize_Int_Int_Int_Int	Sets displayed size when Workbook file is used as an Ole object.
GetExternalLinks	Represents external links in a workbook.
GetTableStyles	Gets TableStyles object.
ClearPivottables	Clears pivot tables from the spreadsheet.
GetRevisionLogs	Represents revision logs.
RefreshAll	Refresh all pivot tables and charts with pivot source.
RefreshPivotTables	Refreshes all the PivotTables in the Excel file.
RefreshPivotTables_PivotTableRefreshOption	Refreshes all the PivotTables in the Excel file.
GetCount