Returns a value representing this worksheet that can be read by Open Office XML. When setting the color, use an empty-string to set an "auto" color, or a real color otherwise. Otherwise, the property will be set to a color, in the form #RRGGBB (e.g., "FFA500"). If the worksheet is visible but the tab color is set to auto, an empty string will be returned. When retrieving the tab color, if the worksheet is invisible, the value will be null. For proportional fonts, the width of the character 0 (zero) is used. One unit of column width is equal to the width of one character in the Normal style. Specifies the standard (default) width of all the columns in the worksheet. Returns the standard (default) height of all the rows in the worksheet, in points. Returns a collection of slicers that are part of the worksheet. Specifies if headings are visible to the user. Specifies if gridlines are visible to the user. Returns the collection of all the Shape objects on the worksheet. Returns the sheet protection object for a worksheet. The zero-based position of the worksheet within the workbook. Gets the PageLayout object of the worksheet.Ĭollection of PivotTables that are part of the worksheet. Returns a collection of sheet views that are present in the worksheet.Ĭollection of names scoped to the current worksheet. The value of the identifier remains the same even when the worksheet is renamed or moved. Returns a value that uniquely identifies the worksheet in a given workbook.
MICROSOFT EXCEL ADD INS CONSOLIDATE WORKSHEETS MANUAL
This collection only contains manual page breaks. Gets the horizontal page break collection for the worksheet. Gets an object that can be used to manipulate frozen panes on the worksheet. False if Excel doesn't recalculate the sheet. True if Excel recalculates the worksheet when necessary. Gets a collection of worksheet-level custom properties.ĭetermines if Excel should recalculate the worksheet when necessary. This connects the add-in's process to the Office host application's process. The request context associated with the object. Returns a collection of all the Comments objects on the worksheet. Returns a collection of charts that are part of the worksheet. Represents the AutoFilter object of the worksheet.
0 kommentar(er)
