 | WorkbookShortener Class |
Class to provide access to the current worksheet with a shortened syntax. Note: The WS object can be null if the workbook was created without a worksheet. The object will be available as soon as the current worksheet is defined
Inheritance HierarchyNamespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 3.2.1+e0edc719a6aeecf6c989e5a57750c75d6f3175bb
SyntaxC#
public class Shortener
The WorkbookShortener type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | WorkbookShortener | Initializes a new instance of the WorkbookShortener class |
Methods| Name | Description | |
|---|---|---|
| Down | Moves the cursor one row down |
| Down(Int32, Boolean) | Moves the cursor the number of defined rows down |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| Formula(String) | Sets a formula into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction) |
| Formula(String, Style) | Sets a formula with style into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction) |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| Left | Moves the cursor one column to the left |
| Left(Int32, Boolean) | Moves the cursor the number of defined columns to the left |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
 | NullCheck | Internal method to check whether the worksheet is null |
| Right | Moves the cursor one column to the right |
| Right(Int32, Boolean) | Moves the cursor the number of defined columns to the right |
| SetCurrentWorksheet | Sets the worksheet accessed by the shortener |
| SetCurrentWorksheetInternal | Sets the worksheet accessed by the shortener, invoked by the workbook |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
| Up | Moves the cursor one row up |
| Up(Int32, Boolean) | Moves the cursor the number of defined rows up |
| Value(Object) | Sets a value into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction) |
| Value(Object, Style) | Sets a value with style into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction) |
See Also