PicoXLSX Library Documentation
 | 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: 2.4.0.0 (2.4.0)
SyntaxC#
public class Shortener
The WorkbookShortener type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | WorkbookShortener |
Default constructor
|
Methods| Name | Description | |
|---|---|---|
| Down |
Moves the cursor one row down
|
| Down(Int32) |
Moves the cursor the number of defined rows down
|
| Equals | (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 a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| 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) |
Moves the cursor the number of defined columns to the right
|
| SetCurrentWorksheet |
Sets the worksheet accessed by the shortener
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| 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