GemBox.Spreadsheet

https://www.gemboxsoftware.com/spreadsheet/docs/
Admin
GemBox.Spreadsheet is a .NET component that enables developers to read, write, edit, convert, and...
Tokens:271,008
Snippets:3,732
Trust Score:7.5
Update:2 months ago
Show doc for...
Tokens:
Raw
### StartColumn Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.CreateDataTableOptions.html

Gets or sets the starting column index. This is ignored if ColumnIndexes is used.

```C#
public int StartColumn { get; set; }
```

```VB.NET
Public Property StartColumn As Integer
```

--------------------------------

### StartRow Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.CreateDataTableOptions.html

Gets or sets the starting row index.

```C#
public int StartRow { get; set; }
```

```VB.NET
Public Property StartRow As Integer
```

--------------------------------

### StartPageNumber

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelPrintOptions.html

Gets or sets the starting page number.

```APIDOC
## Property: StartPageNumber

### Description
Gets or sets the starting page number for the print job. The default value is 1.
```

--------------------------------

### UseStartPageNumber

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelPrintOptions.html

Gets or sets a value indicating whether to use the start page number.

```APIDOC
## Property: UseStartPageNumber

### Description
Gets or sets a boolean value indicating whether the StartPageNumber property should be used. The default value is false.
```

--------------------------------

### Source

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.PictureFillFormat.html

Gets the picture source content.

```APIDOC
## Property: Source

### Description
Gets the picture source that is either embedded in or linked to the workbook file.

### Type
PictureContent
```

--------------------------------

### Initialize Certificate from File

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Security.Certificate.html

Constructor to create a Certificate instance from a file path.

```C#
public Certificate(string fileName)
```

```VB.NET
Public Sub New(fileName As String)
```

--------------------------------

### Format Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ImageSaveOptions.html

Gets or sets the target image format.

```C#
public ImageSaveFormat Format { get; set; }
```

```VB.NET
Public Property Format As ImageSaveFormat
```

--------------------------------

### Initialize Certificate from Source

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Security.Certificate.html

Constructor to create a Certificate instance from an existing X509Certificate2 object.

```C#
public Certificate(object source)
```

```VB.NET
Public Sub New(source As Object)
```

--------------------------------

### Initialize FileFormatLimitations Instance

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.FileFormatLimitations.html

Constructor to initialize a new instance with specific format constraints.

```C#
public FileFormatLimitations(int maxRows, int maxColumns, int maxColors, int maxCellStyles)
```

```VB.NET
Public Sub New(maxRows As Integer, maxColumns As Integer, maxColors As Integer, maxCellStyles As Integer)
```

--------------------------------

### Normal

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.CellStyleCollection.html

Gets the default 'Normal' style.

```APIDOC
## Property: Normal

### Description
Gets the 'Normal' style, which stores default cell formatting properties for the entire workbook. This style cannot be removed.
```

--------------------------------

### TilingAlignment

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.PictureFillFormat.html

Gets or sets the alignment of the first tile.

```APIDOC
## Property: TilingAlignment

### Description
Gets or sets a value indicating where to align the first tile with respect to the filling area. Alignment occurs after scaling but before additional offset.

### Signature
`public RectangleAlignment TilingAlignment { get; set; }`
```

--------------------------------

### Initialize PrintOptions with Stream

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PrintOptions.html

Constructor using an XML stream that complies with the XML Print Schema.

```C#
public PrintOptions(MemoryStream xmlStream)
```

```VB.NET
Public Sub New(xmlStream As MemoryStream)
```

--------------------------------

### NumberStartAt Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.TextListFormat.html

Gets or sets the number that starts a given sequence of a numbered list.

```C#
public int NumberStartAt { get; set; }
```

```VB.NET
Public Property NumberStartAt As Integer
```

--------------------------------

### Open Method

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.Content.html

Opens the content as a stream. Ensure the returned stream is disposed after use.

```C#
public Stream Open()
```

```VB.NET
Public Function Open As Stream
```

--------------------------------

### HasFormulas Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.CsvLoadOptions.html

Gets or sets whether text starting with '=' should be treated as a formula.

```C#
public bool HasFormulas { get; set; }
```

```VB.NET
Public Property HasFormulas As Boolean
```

--------------------------------

### Initialize PrintOptions

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PrintOptions.html

Constructors for creating a new instance of the PrintOptions class.

```C#
public PrintOptions()
```

```VB.NET
Public Sub New
```

--------------------------------

### FirstColumn Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.HorizontalPageBreak.html

Gets or sets the index of the first column of the new page. Use 0 if the starting column is not restricted.

```C#
public int FirstColumn { get; set; }
```

```VB.NET
Public Property FirstColumn As Integer
```

--------------------------------

### XlsxLoadOptions()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XlsxLoadOptions.html

Initializes a new instance of the XlsxLoadOptions class.

```APIDOC
## XlsxLoadOptions()

### Description
Initializes a new instance of the XlsxLoadOptions class.
```

--------------------------------

### Example of Non-Cacheable Formula

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.CalculationEngine.CalculationOptions.html

An example of a formula that cannot be cached because its result depends on the cell location.

```Excel
=MAX(ROW(), COLUMN())
```

--------------------------------

### Initialize XlsLoadOptions

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XlsLoadOptions.html

Constructor for creating a new instance of XlsLoadOptions.

```C#
public XlsLoadOptions()
```

```VB.NET
Public Sub New
```

--------------------------------

### InsertDataTableOptions Constructors

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.InsertDataTableOptions.html

Initializes a new instance of the InsertDataTableOptions class, optionally specifying the starting row and column or the starting cell address.

```APIDOC
## Constructors

### InsertDataTableOptions()
Initializes a default instance of the class.

### InsertDataTableOptions(int startRow, int startColumn)
Initializes an instance with specific starting coordinates.
- **startRow** (int): Index of the first row.
- **startColumn** (int): Index of the first column.

### InsertDataTableOptions(string startCell)
Initializes an instance with a cell address.
- **startCell** (string): Name of the top-left cell.
```

--------------------------------

### XlsbLoadOptions()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XlsbLoadOptions.html

Initializes a new instance of the XlsbLoadOptions class.

```APIDOC
## Constructor: XlsbLoadOptions()

### Description
Initializes a new instance of the XlsbLoadOptions class.
```

--------------------------------

### Hyperlinks

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelWorksheet.html

Gets hyperlinks in this sheet.

```APIDOC
## Hyperlinks

### Description
Gets hyperlinks in this sheet.

### Property Value
- **SpreadsheetHyperlinkCollection**
```

--------------------------------

### PrintOptions()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PrintOptions.html

Initializes a new instance of the PrintOptions class.

```APIDOC
## PrintOptions()

### Description
Initializes a new instance of the PrintOptions class.
```

--------------------------------

### OdsLoadOptions()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.OdsLoadOptions.html

Initializes a new instance of the OdsLoadOptions class.

```APIDOC
## OdsLoadOptions()

### Description
Initializes a new instance of the OdsLoadOptions class.
```

--------------------------------

### FillFormat.FillType

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.FillFormat.html

Gets the type of the fill.

```APIDOC
## Property: FillType

### Description
Gets the type of the fill.

### Return Value
- **FillFormatType** - The type of the fill.
```

--------------------------------

### Certificate(string fileName)

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Security.Certificate.html

Initializes a new instance of the Certificate class from a certificate file.

```APIDOC
## Certificate(string fileName)

### Description
Initializes a new instance of the Certificate class from a file with the specified file name.

### Parameters
- **fileName** (string) - Required - The path to the certificate file.

### Exceptions
- **System.ArgumentNullException** - Thrown if fileName is null.
```

--------------------------------

### Language

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Style.html

Gets or sets the language for this style.

```APIDOC
## Property: Language

### Description
Gets or sets the language for this style.

### Type
System.Globalization.CultureInfo
```

--------------------------------

### TableCollection.Count

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Tables.TableCollection.html

Gets the number of Tables in the collection.

```APIDOC
## Count

### Description
Gets the number of Tables contained in the collection.

### Returns
- **int** - The number of Tables.
```

--------------------------------

### HtmlLoadOptions()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.HtmlLoadOptions.html

Initializes a new instance of the HtmlLoadOptions class.

```APIDOC
## HtmlLoadOptions()

### Description
Initializes a new instance of the HtmlLoadOptions class for configuring HTML import settings.

### Signature
`public HtmlLoadOptions()`
```

--------------------------------

### PivotField Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PivotTables.PivotItem.html

Gets the parent PivotField.

```C#
public PivotField PivotField { get; }
```

```VB.NET
Public ReadOnly Property PivotField As PivotField
```

--------------------------------

### FileFormatLimitations Constructor

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.FileFormatLimitations.html

Initializes a new instance of the FileFormatLimitations class with specified constraints.

```APIDOC
## FileFormatLimitations(int maxRows, int maxColumns, int maxColors, int maxCellStyles)

### Description
Initializes a new instance of the FileFormatLimitations class.

### Parameters
- **maxRows** (Int32) - Maximum number of rows.
- **maxColumns** (Int32) - Maximum number of columns.
- **maxColors** (Int32) - Maximum number of colors.
- **maxCellStyles** (Int32) - Maximum number of cell styles.
```

--------------------------------

### HeadersFooters

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelWorksheet.html

Gets or sets headers/footers for the sheet.

```APIDOC
## HeadersFooters

### Description
Gets or sets headers/footers for the sheet.

### Property Value
- **SheetHeaderFooter**
```

--------------------------------

### XlsLoadOptions()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XlsLoadOptions.html

Initializes a new instance of the XlsLoadOptions class.

```APIDOC
## XlsLoadOptions()

### Description
Initializes a new instance of the XlsLoadOptions class.
```

--------------------------------

### Configure FromPage Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PrintOptions.html

Gets or sets the page index of the first page to print, using zero-based indexing.

```C#
public int FromPage { get; set; }
```

```VB.NET
Public Property FromPage As Integer
```

--------------------------------

### GroupShapes

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelWorksheet.html

Gets the worksheet group shapes.

```APIDOC
## GroupShapes

### Description
Gets the worksheet group shapes.

### Property Value
- **ExcelGroupShapeCollection** - The worksheet group shapes.
```

--------------------------------

### ImportFromDataGridViewOptions()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.WinFormsUtilities.ImportFromDataGridViewOptions.html

Initializes a new instance of the ImportFromDataGridViewOptions class.

```APIDOC
## ImportFromDataGridViewOptions()

### Description
Initializes an instance of the ImportFromDataGridViewOptions class with default settings.
```

--------------------------------

### FormControls

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelWorksheet.html

Gets the worksheet form controls.

```APIDOC
## FormControls

### Description
Gets the worksheet form controls.

### Property Value
- **ExcelFormControlCollection** - The worksheet form controls.
```

--------------------------------

### BringToFront Method

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelPicture.html

Brings the picture to the front of all drawings.

```C#
public void BringToFront()
```

```VB.NET
Public Sub BringToFront
```

--------------------------------

### Filter

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelWorksheet.html

Gets or sets the active AutoFilter.

```APIDOC
## Filter

### Description
Gets or sets the active AutoFilter. Returns null if no AutoFilter is active. Active AutoFilter is loaded from and saved to XLSX file.

### Property Value
- **AutoFilter** - The active AutoFilter or null if no AutoFilter is active.

### Exceptions
- **System.ArgumentException** - Filter range doesn't belong to this worksheet.
```

--------------------------------

### PrintOptions(MemoryStream)

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PrintOptions.html

Initializes a new instance of the PrintOptions class using an XML stream that complies with the XML Print Schema.

```APIDOC
## PrintOptions(MemoryStream xmlStream)

### Description
Initializes a new instance of the PrintOptions class by using an XML stream (that contains a PrintTicket document) that complies with the XML Print Schema.

### Parameters
- **xmlStream** (System.IO.MemoryStream) - Required - An XML stream that describes a print job and conforms to the Print Schema.
```

--------------------------------

### Worksheets

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelFile.html

Gets the collection of all worksheets in the workbook.

```APIDOC
## Property: Worksheets

### Description
Collection of all worksheets (ExcelWorksheet) in a workbook.

### Property Value
ExcelWorksheetCollection
```

--------------------------------

### PaginatorOptions()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PaginatorOptions.html

Initializes a new instance of the PaginatorOptions class.

```APIDOC
## PaginatorOptions()

### Description
Initializes a new instance of the PaginatorOptions class.
```

--------------------------------

### FilterType Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Filter.html

Gets the type of the filter.

```C#
public abstract FilterType FilterType { get; }
```

```VB.NET
Public MustOverride ReadOnly Property FilterType As FilterType
```

--------------------------------

### XpsSaveOptions()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XpsSaveOptions.html

Initializes a new instance of the XpsSaveOptions class.

```APIDOC
## XpsSaveOptions()

### Description
Initializes a new instance of the XpsSaveOptions class.
```

--------------------------------

### PictureStream Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelPicture.html

Gets the picture stream.

```C#
public MemoryStream PictureStream { get; }
```

```VB.NET
Public ReadOnly Property PictureStream As MemoryStream
```

--------------------------------

### PictureFormat Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelPicture.html

Gets the picture format.

```C#
public ExcelPictureFormat PictureFormat { get; }
```

```VB.NET
Public ReadOnly Property PictureFormat As ExcelPictureFormat
```

--------------------------------

### Certificate(Object source)

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Security.Certificate.html

Initializes a new instance of the Certificate class from an existing System.Security.Cryptography.X509Certificates.X509Certificate2 object.

```APIDOC
## Certificate(object source)

### Description
Initializes a new instance of the Certificate class from the specified source object.

### Parameters
- **source** (object) - Required - The certificate source, which must be an instance of System.Security.Cryptography.X509Certificates.X509Certificate2.

### Exceptions
- **System.ArgumentException** - Thrown if the source parameter is not an instance of System.Security.Cryptography.X509Certificates.X509Certificate2.
```

--------------------------------

### LoadWithOptions Method

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ComHelper.html

Loads a spreadsheet from the specified path using provided loading options.

```C#
public ExcelFile LoadWithOptions(string path, object options)
```

```VB.NET
Public Function LoadWithOptions(path As String, options As Object) As ExcelFile
```

--------------------------------

### ExcelFilePaginator.Pages

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelFilePaginator.html

Gets the collection of workbook pages.

```APIDOC
### Property: Pages

**Description:** Gets the workbook pages as a ReadOnlyCollection of ExcelFilePage objects.

**Type:** System.Collections.ObjectModel.ReadOnlyCollection<ExcelFilePage>
```

--------------------------------

### ComHelper Constructor

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ComHelper.html

Initializes a new instance of the ComHelper class.

```C#
public ComHelper()
```

```VB.NET
Public Sub New
```

--------------------------------

### Constructor with Cell Reference

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.CreateDataTableOptions.html

Initializes a new instance using a starting cell name and dimensions.

```C#
public CreateDataTableOptions(string startCell, int numberOfRows, int numberOfColumns)
```

```VB.NET
Public Sub New(startCell As String, numberOfRows As Integer, numberOfColumns As Integer)
```

--------------------------------

### GetWidth(LengthUnit)

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelDrawingPosition.html

Gets the width of the ExcelDrawing.

```APIDOC
## GetWidth(LengthUnit)

### Description
Gets the width of the ExcelDrawing (picture, chart, etc.).

### Parameters
- **unit** (LengthUnit) - Required - The length unit of the returned value.

### Returns
- **System.Double** - The width of the ExcelDrawing.
```

--------------------------------

### DefaultPage Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.SheetHeaderFooter.html

Gets or sets the default header/footer configuration.

```C#
public HeaderFooterPage DefaultPage { get; set; }
```

```VB.NET
Public Property DefaultPage As HeaderFooterPage
```

--------------------------------

### ListType Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.TextListFormat.html

Gets the type of the list.

```C#
public ListType ListType { get; }
```

```VB.NET
Public ReadOnly Property ListType As ListType
```

--------------------------------

### XlsxLoadOptions Constructor

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XlsxLoadOptions.html

Initializes a new instance of the XlsxLoadOptions class.

```C#
public XlsxLoadOptions()
```

```VB.NET
Public Sub New
```

--------------------------------

### FillType Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.FillFormat.html

Gets the type of the fill.

```C#
public abstract FillFormatType FillType { get; }
```

```VB.NET
Public MustOverride ReadOnly Property FillType As FillFormatType
```

--------------------------------

### ImportFromDataGridViewOptions Constructor with Row and Column

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.WinFormsUtilities.ImportFromDataGridViewOptions.html

Initializes a new instance with specified starting row and column indices.

```csharp
public ImportFromDataGridViewOptions(int startRow, int startColumn)
```

```vbnet
Public Sub New(startRow As Integer, startColumn As Integer)
```

--------------------------------

### ImportFromDataGridViewOptions(String)

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.WinFormsUtilities.ImportFromDataGridViewOptions.html

Initializes a new instance of the ImportFromDataGridViewOptions class with a specified starting cell address.

```APIDOC
## ImportFromDataGridViewOptions(string startCell)

### Description
Initializes an instance of the ImportFromDataGridViewOptions class using a cell name (e.g., "A1") to define the top-left corner of the imported data.

### Parameters
- **startCell** (String) - Required - Name of the first (top left) cell of imported data in ExcelWorksheet.
```

--------------------------------

### DateTime Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.DateTimeGroup.html

Gets the date/time of this DateTimeGroup.

```C#
public readonly DateTime DateTime { get; }
```

```VB.NET
Public ReadOnly Property DateTime As Date
```

--------------------------------

### Methods

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.GradientStop.html

Methods for comparing gradient stops and retrieving instance information.

```APIDOC
## Methods

### Equals(GradientStop other)
- **Description**: Determines whether the other GradientStop is equal to this instance.

### Equals(object obj)
- **Description**: Determines whether the specified object is equal to this instance.

### GetHashCode()
- **Description**: Returns a hash code for this GradientStop instance.

### ToString()
- **Description**: Returns a string representation of this GradientStop instance, primarily for debugging purposes.
```

--------------------------------

### ExcelCell Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.DataTableCellToExcelCellConvertingEventArgs.html

Gets the destination ExcelCell.

```C#
public ExcelCell ExcelCell { get; }
```

```VB.NET
Public ReadOnly Property ExcelCell As ExcelCell
```

--------------------------------

### ImportFromDataGridViewOptions Constructor

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.WinFormsUtilities.ImportFromDataGridViewOptions.html

Initializes a new instance of the ImportFromDataGridViewOptions class.

```csharp
public ImportFromDataGridViewOptions()
```

```vbnet
Public Sub New
```

--------------------------------

### DataTable Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.DataTableCellToExcelCellConvertingEventArgs.html

Gets the source DataTable.

```C#
public DataTable DataTable { get; }
```

```VB.NET
Public ReadOnly Property DataTable As DataTable
```

--------------------------------

### Constructor with Row and Column Indices

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.CreateDataTableOptions.html

Initializes a new instance using specific row and column indices.

```C#
public CreateDataTableOptions(int startRow, int startColumn, int numberOfRows, int numberOfColumns)
```

```VB.NET
Public Sub New(startRow As Integer, startColumn As Integer, numberOfRows As Integer, numberOfColumns As Integer)
```

--------------------------------

### ToString(String, IFormatProvider) Method

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.Length.html

Returns a string representation using a specified format and format provider with the default unit.

```C#
public string ToString(string format, IFormatProvider formatProvider)
```

```VB.NET
Public Function ToString(format As String, formatProvider As IFormatProvider) As String
```

--------------------------------

### Language Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Style.html

Gets or sets the language for this style.

```csharp
public CultureInfo Language { get; set; }
```

```vbnet
Public Property Language As CultureInfo
```

--------------------------------

### BringToFront Method

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelDrawingCollection-1.html

Moves a drawing to the front of the Z-order.

```C#
public void BringToFront(T item)
```

```VB.NET
Public Sub BringToFront(item As T)
```

```C#
public void BringToFront(int index)
```

```VB.NET
Public Sub BringToFront(index As Integer)
```

--------------------------------

### Password

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XlsbSaveOptions.html

Gets or sets the password for workbook protection.

```APIDOC
## Password

### Description
Gets or sets the password used to protect or encrypt the workbook.
```

--------------------------------

### Limitations

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XlsbSaveOptions.html

Gets the file format limitations for XLSB.

```APIDOC
## Limitations

### Description
Gets the specific limitations for saving to the XLSB file format, including maximum rows (1,048,576), columns (16,384), colors (16,000,000), and cell styles (64,000).
```

--------------------------------

### GradientStop Constructor

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.GradientStop.html

Initializes a new instance of the GradientStop class with the specified position and color.

```C#
public GradientStop(double position, DrawingColor color)
```

```VB.NET
Public Sub New(position As Double, color As DrawingColor)
```

--------------------------------

### Load Method

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ComHelper.html

Loads a spreadsheet from the specified file path.

```C#
public ExcelFile Load(string path)
```

```VB.NET
Public Function Load(path As String) As ExcelFile
```

--------------------------------

### ContentType

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XlsbSaveOptions.html

Gets the content-type for the XLSB file format.

```APIDOC
## ContentType

### Description
Gets the content-type for the XLSB file format: application/vnd.ms-excel.sheet.binary.macroEnabled.12.
```

--------------------------------

### ContentType

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XlsSaveOptions.html

Gets the content-type for the XLS file format.

```APIDOC
## ContentType

### Description
Gets the content-type for XLS file format: application/vnd.ms-excel.
```

--------------------------------

### TextRun Properties and Methods

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.TextRun.html

Documentation for the properties and methods available on the TextRun class.

```APIDOC
## TextRun Class

### Description
Represents a run of text within a spreadsheet drawing element.

### Properties
- **ElementType** (TextElementType) - Gets the Run value.
- **Text** (string) - Gets or sets the text content of the run.
- **Format** (TextFormat) - Gets or sets the text formatting options (Inherited from TextElement).
- **Parent** (TextParagraph) - Gets the parent text paragraph (Inherited from TextElement).

### Methods
- **ToString()** (string) - Returns a string representation of the TextRun instance.
```

--------------------------------

### State Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.WorksheetPanes.html

Gets or sets the state of the panes.

```C#
public PanesState State { get; set; }
```

```VB.NET
Public Property State As PanesState
```

--------------------------------

### BringToFront()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelPicture.html

Brings the picture to the front of the drawings.

```APIDOC
## void BringToFront()

### Description
Brings the picture to the front of the drawings.
```

--------------------------------

### VbaProject.Name

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Vba.VbaProject.html

Gets or sets the name of the VBA project.

```APIDOC
## Property: Name

### Description
Gets or sets the name of the VbaProject.

### Property Value
- **System.String** - The name of the project.
```

--------------------------------

### Accessing FullVersion Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.SpreadsheetInfo.html

Retrieves the full version string of the GemBox.Spreadsheet assembly.

```C#
public static string FullVersion { get; }
```

```VB.NET
Public Shared ReadOnly Property FullVersion As String
```

--------------------------------

### Item Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Tables.TableRowCollection.html

Gets the TableRow at the specified index.

```APIDOC
## Property: Item[Int32]

### Description
Gets the TableRow at the specified index.

### Parameters
- **index** (System.Int32) - Required - The zero-based index of the TableRow.

### Property Value
- **Type**: TableRow
- **Description**: The TableRow at the specified index.
```

--------------------------------

### Item[Int32]

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Tables.TableColumnCollection.html

Gets the TableColumn at the specified index.

```APIDOC
## Property Item[Int32]

### Description
Gets the TableColumn at the specified index.

### Parameters
- **index** (System.Int32) - Required - The zero-based index of the TableColumn.

### Return Value
- **Type**: TableColumn
- **Description**: The TableColumn.
```

--------------------------------

### Initialize XpsSaveOptions

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XpsSaveOptions.html

Constructor for creating a new instance of the XpsSaveOptions class.

```csharp
public XpsSaveOptions()
```

```vbnet
Public Sub New
```

--------------------------------

### HtmlLoadOptions Constructor

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.HtmlLoadOptions.html

Initializes a new instance of the HtmlLoadOptions class.

```csharp
public HtmlLoadOptions()
```

```vbnet
Public Sub New
```

--------------------------------

### Count

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Tables.TableColumnCollection.html

Gets the number of TableColumns contained in the collection.

```APIDOC
## Property Count

### Description
Gets the number of TableColumns contained in the collection.

### Return Value
- **Type**: System.Int32
- **Description**: The number of TableColumns contained in the collection.
```

--------------------------------

### Item[Int32]

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PivotTables.PivotTableCollection.html

Gets the PivotTable at the specified index.

```APIDOC
### Property: Item[Int32]

**Description:** Gets the PivotTable at the specified index.

**Parameters:**
- **index** (System.Int32) - The zero-based index of the PivotTable.

**Return Type:** PivotTable

**Signature:** `public PivotTable this[int index] { get; }`
```

--------------------------------

### Enable Compatibility Switch for Windows Server

Source: https://www.gemboxsoftware.com/spreadsheet/docs/supported-platforms.html

Configures the application to allow rendering when no display devices are available, which is required for saving to XPS or image formats on Windows servers.

```C#
public class Startup
{
    public Startup(IConfiguration configuration)
    {
        Configuration = configuration;
        // Add compatibility switch.
        AppContext.SetSwitch("Switch.System.Windows.Media.ShouldRenderEvenWhenNoDisplayDevicesAreAvailable", true);
    }

    public IConfiguration Configuration { get; }

    // ...

}
```

```VB.NET
Public Class Startup

    Public Sub New(configuration As IConfiguration)

        Configuration = configuration
        ' Add compatibility switch.
        AppContext.SetSwitch("Switch.System.Windows.Media.ShouldRenderEvenWhenNoDisplayDevicesAreAvailable", True)

    End Sub

    Public ReadOnly Property Configuration As IConfiguration

    ' ...

End Class
```

--------------------------------

### Count

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PivotTables.PivotTableCollection.html

Gets the number of PivotTables contained in the collection.

```APIDOC
### Property: Count

**Description:** Gets the number of PivotTables contained in the collection.

**Type:** System.Int32

**Signature:** `public int Count { get; }`
```

--------------------------------

### Item Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.SortLevelCollection.html

Gets the SortLevel at the specified index.

```APIDOC
## Item[Int32]

### Description
Gets the SortLevel at the specified index.

### Parameters
- **index** (System.Int32) - Required - The zero-based index of the SortLevel to get.

### Exceptions
- **System.ArgumentOutOfRangeException** - Thrown when index is less than zero or is equal to or greater than Count.
```

--------------------------------

### ImportFromDataGridViewOptions Constructor with Cell Name

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.WinFormsUtilities.ImportFromDataGridViewOptions.html

Initializes a new instance with a specified starting cell address.

```csharp
public ImportFromDataGridViewOptions(string startCell)
```

```vbnet
Public Sub New(startCell As String)
```

--------------------------------

### Configure Runtime Compatibility via JSON

Source: https://www.gemboxsoftware.com/spreadsheet/docs/supported-platforms.html

Enables the rendering compatibility switch by adding a configuration property to the project's runtimeconfig.template.json file.

```JSON
{
  "configProperties": {
    "Switch.System.Windows.Media.ShouldRenderEvenWhenNoDisplayDevicesAreAvailable": true
  }
}
```

--------------------------------

### Item[Int32]

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.SpreadsheetHyperlinkCollection.html

Gets the hyperlink at the specified index.

```APIDOC
### Property: Item[Int32]

**Description**: Gets the hyperlink at the specified index.

**Parameters**:
- **index** (System.Int32) - The zero-based index of the hyperlink.

**Returns**: SpreadsheetHyperlink
```

--------------------------------

### Count

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.SpreadsheetHyperlinkCollection.html

Gets the number of hyperlinks contained in the collection.

```APIDOC
### Property: Count

**Description**: Gets the number of hyperlinks contained in the collection.

**Type**: System.Int32
```

--------------------------------

### UseStartPageNumber Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelPrintOptions.html

Configures whether to use the specified start page number.

```csharp
public bool UseStartPageNumber { get; set; }
```

```vbnet
Public Property UseStartPageNumber As Boolean
```

--------------------------------

### Create SpreadsheetColor from ARGB values

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.SpreadsheetColor.html

Create a color structure using either a single 32-bit integer or individual 8-bit red, green, and blue components.

```C#
public static SpreadsheetColor FromArgb(int argb)
```

```VB.NET
Public Shared Function FromArgb(argb As Integer) As SpreadsheetColor
```

```C#
public static SpreadsheetColor FromArgb(int red, int green, int blue)
```

```VB.NET
Public Shared Function FromArgb(red As Integer, green As Integer, blue As Integer) As SpreadsheetColor
```

--------------------------------

### GetRawData()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Security.Certificate.html

Gets the copy of raw data of a Certificate.

```APIDOC
## GetRawData()

### Description
Gets the copy of raw data of a Certificate.

### Signature
`public byte[] GetRawData()`

### Returns
- **Byte[]** - The copy of raw data of the Certificate as a byte array.
```

--------------------------------

### ImportFromDataGridViewOptions(Int32, Int32)

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.WinFormsUtilities.ImportFromDataGridViewOptions.html

Initializes a new instance of the ImportFromDataGridViewOptions class with specified starting row and column indices.

```APIDOC
## ImportFromDataGridViewOptions(int startRow, int startColumn)

### Description
Initializes an instance of the ImportFromDataGridViewOptions class using specific row and column indices for the starting position in the Excel worksheet.

### Parameters
- **startRow** (Int32) - Required - Index of the first row of imported data in ExcelWorksheet.
- **startColumn** (Int32) - Required - Index of the first column of imported data in ExcelWorksheet.
```

--------------------------------

### Item[String]

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ProtectedRangeCollection.html

Gets the ProtectedRange with the specified title.

```APIDOC
## Property: Item[String]

### Description
Gets the ProtectedRange with the specified title or null.

### Parameters
- **title** (System.String) - Required - The ProtectedRange title.
```

--------------------------------

### Item[String]

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PivotTables.PivotItemCollection.html

Gets the PivotItem with the specified name.

```APIDOC
## Property: Item[String]

### Description
Gets the PivotItem with the specified name.

### Parameters
- **itemName** (System.String) - The name of the PivotItem.

### Return Value
- **PivotItem** - The PivotItem with the specified name.
```

--------------------------------

### OdsLoadOptions Constructor

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.OdsLoadOptions.html

Initializes a new instance of the OdsLoadOptions class.

```C#
public OdsLoadOptions()
```

```VB.NET
Public Sub New
```

--------------------------------

### ComSetLicense Method

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ComHelper.html

Sets the GemBox.Spreadsheet serial key. This should be called before using any other library classes.

```C#
public void ComSetLicense(string serialKey)
```

```VB.NET
Public Sub ComSetLicense(serialKey As String)
```

--------------------------------

### Item[Int32]

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ProtectedRangeCollection.html

Gets the ProtectedRange at the specified index.

```APIDOC
## Property: Item[Int32]

### Description
Gets the ProtectedRange at the specified index.

### Parameters
- **index** (System.Int32) - Required - The zero-based index of the ProtectedRange to get.

### Exceptions
- **System.ArgumentOutOfRangeException** - Thrown if index is less than zero or equal to/greater than Count.
```

--------------------------------

### Count

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ProtectedRangeCollection.html

Gets the number of ProtectedRanges contained in the collection.

```APIDOC
## Property: Count

### Description
Gets the number of ProtectedRanges actually contained in the ProtectedRangeCollection.

### Return Value
- **Type**: System.Int32
- **Description**: The number of ProtectedRanges in the collection.
```

--------------------------------

### ExcelFile Constructor

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelFile.html

Initializes a new empty instance of the ExcelFile class.

```C#
public ExcelFile()
```

```VB.NET
Public Sub New
```

--------------------------------

### ProtectedRange.Title

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ProtectedRange.html

Gets or sets the title of the protected range.

```APIDOC
## Property: Title

### Description
Gets or sets the ProtectedRange title.

### Signature
`public string Title { get; set; }`

### Value
- **Type**: System.String
- **Description**: The ProtectedRange title.
```

--------------------------------

### Configure RenderingMode Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XpsSaveOptions.html

Gets or sets the rendering mode for XPS output.

```csharp
public RenderingMode RenderingMode { get; set; }
```

```vbnet
Public Property RenderingMode As RenderingMode
```

--------------------------------

### ProtectedRange.RefersToCells

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ProtectedRange.html

Gets or sets the range of cells to be protected.

```APIDOC
## Property: RefersToCells

### Description
Gets or sets the range of cells to be protected.

### Signature
`public string RefersToCells { get; set; }`

### Value
- **Type**: System.String
- **Description**: The range to be protected.
```

--------------------------------

### Initialize OdsSaveOptions

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.OdsSaveOptions.html

Constructor for creating a new instance of OdsSaveOptions.

```csharp
public OdsSaveOptions()
```

```vbnet
Public Sub New
```

--------------------------------

### RefersToCells Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ProtectedRange.html

Gets or sets the range to be protected.

```C#
public string RefersToCells { get; set; }
```

```VB.NET
Public Property RefersToCells As String
```

--------------------------------

### Location Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PdfDigitalSignatureSaveOptions.html

Gets or sets the CPU host name or physical location of the signing.

```C#
public string Location { get; set; }
```

```VB.NET
Public Property Location As String
```

--------------------------------

### Item[Int32]

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PivotTables.PivotItemCollection.html

Gets the PivotItem at the specified index.

```APIDOC
## Property: Item[Int32]

### Description
Gets the PivotItem at the specified index.

### Parameters
- **index** (System.Int32) - The zero-based index of the PivotItem.

### Return Value
- **PivotItem** - The PivotItem at the specified index.
```

--------------------------------

### Setting the License Key

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.SpreadsheetInfo.html

Configures the serial key for the library. This should be called before using any other library classes.

```C#
public static void SetLicense(string serialKey)
```

```VB.NET
Public Shared Sub SetLicense(serialKey As String)
```

--------------------------------

### Count

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PivotTables.PivotItemCollection.html

Gets the number of PivotItems contained in the collection.

```APIDOC
## Property: Count

### Description
Gets the number of PivotItems contained in the collection.

### Return Value
- **System.Int32** - The number of PivotItems contained in the collection.
```

--------------------------------

### Configure Size Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.TextFormat.html

Sets or retrieves the text size. Value must be between 1 pt and 4000 pt.

```C#
public Length Size { get; set; }
```

```VB.NET
Public Property Size As Length
```

--------------------------------

### Item[Int32]

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PivotTables.PivotCacheCollection.html

Gets the PivotCache at the specified index.

```APIDOC
## Property: Item[Int32]

### Description
Gets the PivotCache at the specified index.

### Parameters
- **index** (System.Int32) - Required - The zero-based index of the PivotCache.

### Property Value
- **Type**: PivotCache
- **Description**: The PivotCache at the specified index.
```

--------------------------------

### Create SpreadsheetColor from ColorName

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.SpreadsheetColor.html

Initialize a SpreadsheetColor using a predefined value from the ColorName enumeration.

```C#
public static SpreadsheetColor FromName(ColorName name)
```

```VB.NET
Public Shared Function FromName(name As ColorName) As SpreadsheetColor
```

--------------------------------

### Count

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PivotTables.PivotCacheCollection.html

Gets the number of PivotCaches contained in the collection.

```APIDOC
## Property: Count

### Description
Gets the number of PivotCaches contained in the collection.

### Property Value
- **Type**: System.Int32
- **Description**: The number of PivotCaches contained in the collection.
```

--------------------------------

### Load spreadsheet from file path with options

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelFile.html

Loads a spreadsheet from a file path using specific LoadOptions.

```C#
public static ExcelFile Load(string path, LoadOptions options)
```

```VB.NET
Public Shared Function Load(path As String, options As LoadOptions) As ExcelFile
```

--------------------------------

### PivotCacheSource.SourceType Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PivotTables.PivotCacheSource.html

Gets the type of the PivotCache source.

```APIDOC
### Property: SourceType

#### Description
Gets the type of the PivotCache source.

#### Syntax
`public abstract PivotCacheSourceType SourceType { get; }`

#### Property Value
- **PivotCacheSourceType** - The type of the PivotCache source.
```

--------------------------------

### SpreadsheetIcon(SpreadsheetIconStyle, Int32)

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.SpreadsheetIcon.html

Initializes a new instance of the SpreadsheetIcon struct.

```APIDOC
## SpreadsheetIcon(SpreadsheetIconStyle iconStyle, int id)

### Description
Initializes a new instance of the SpreadsheetIcon struct with the specified style and identifier.

### Parameters
- **iconStyle** (SpreadsheetIconStyle) - Required - The icon style. Cannot be set to Custom.
- **id** (int) - Required - The identifier of the icon from the set of icons specified by iconStyle (usually a value between 0 and 4).

### Exceptions
- **System.ArgumentException**: Thrown if iconStyle is set to Custom.
- **System.ArgumentOutOfRangeException**: Thrown if id is invalid for the given iconStyle.
```

--------------------------------

### ContentType

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.OdsSaveOptions.html

Gets the content-type for the ODS file format.

```APIDOC
## ContentType

### Description
Gets the content-type for ODS file format. Returns 'application/vnd.oasis.opendocument.spreadsheet-template' if the workbook is a template, otherwise returns 'application/vnd.oasis.opendocument.spreadsheet'.
```

--------------------------------

### Content.Open() Method

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.Content.html

Opens the content as a stream. Ensure the returned stream is disposed after use.

```APIDOC
## Method: Open()

### Description
Opens the content as a System.IO.Stream. Make sure to call System.IO.Stream.Dispose on the returned instance after it is no longer used.

### Returns
- **Type**: System.IO.Stream
- **Description**: An instance representing the content data.

### Remarks
If content is linked, this method attempts to open the external content. This may fail if the link format is incorrect or permissions are insufficient.
```

--------------------------------

### SetSource with Link Option

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.PictureFillFormat.html

Sets the picture source and optionally specifies if the picture is linked to the file.

```C#
public PictureContent SetSource(string picturePath, bool isLink = false)
```

```VB.NET
Public Function SetSource(picturePath As String, isLink As Boolean = False) As PictureContent
```

--------------------------------

### DefaultColumnWidth

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelWorksheet.html

Gets or sets the default column width.

```APIDOC
## DefaultColumnWidth

### Description
Gets or sets the default column width. This value is used as a width for columns which do not have Width property explicitly set.

### Property Value
- **System.Int32** - The default column width.
```

--------------------------------

### Properties

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.WinFormsUtilities.ImportFromDataGridViewOptions.html

Configuration properties for the import process.

```APIDOC
## Properties

- **ColumnHeaders** (bool) - Gets or sets a value indicating whether to import column headers into the first row.
- **StartColumn** (int) - Gets or sets the index of the first column of imported data in ExcelWorksheet.
- **StartRow** (int) - Gets or sets the index of the first row of imported data in ExcelWorksheet.
```

--------------------------------

### FontName Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.FontFileSelectionEventArgs.html

Gets the original font name.

```C#
public string FontName { get; }
```

```VB.NET
Public ReadOnly Property FontName As String
```

--------------------------------

### TopMargin

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelPrintOptions.html

Gets or sets the top margin in inches.

```APIDOC
## Property: TopMargin

### Description
Gets or sets the top margin of the page in inches. The default value is 0.75.
```

--------------------------------

### Load(String, LoadOptions)

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelFile.html

Loads a spreadsheet from a file with the specified path and options.

```APIDOC
## Load(String, LoadOptions)

### Description
Loads a spreadsheet from a file with the specified path.

### Parameters
- **path** (System.String) - Required - The path from which to load a spreadsheet.
- **options** (LoadOptions) - Required - The loading options which can be used to define settings for load operation.

### Returns
- **ExcelFile** - A loaded spreadsheet.
```

--------------------------------

### RightMargin

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelPrintOptions.html

Gets or sets the right margin in inches.

```APIDOC
## Property: RightMargin

### Description
Gets or sets the right margin of the page in inches. The default value is 0.7.
```

--------------------------------

### Marker Methods

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Charts.Marker.html

Methods available for managing the Marker instance.

```APIDOC
## Methods

### Delete()
Deletes the marker from the series.

### ToString()
Returns a System.String that represents this Marker instance. Primarily for debugging purposes.
```

--------------------------------

### PrintResolution

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelPrintOptions.html

Gets or sets the print resolution in DPI.

```APIDOC
## Property: PrintResolution

### Description
Gets or sets the print resolution in dots per inch (DPI). The default value is 0. This value is ignored when exporting to PDF, XPS, or image formats.
```

--------------------------------

### Author Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelComment.html

Gets or sets the author of the comment.

```C#
public string Author { get; set; }
```

```VB.NET
Public Property Author As String
```

--------------------------------

### Define LoadOptions Class

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.LoadOptions.html

The base class definition for file loading options.

```C#
public abstract class LoadOptions
```

```VB.NET
Public MustInherit Class LoadOptions
```

--------------------------------

### Properties

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XlsbLoadOptions.html

Configuration properties for the XlsbLoadOptions class.

```APIDOC
## Properties

- **Password** (string) - Gets or sets the password to open protected or encrypted workbooks.
- **PreserveUnsupportedFeatures** (bool) - Gets or sets whether to preserve XLSB features not directly supported by the GemBox.Spreadsheet model. Default is true.
- **StreamingMode** (LoadStreamingMode) - Gets or sets the streaming mode for reading ExcelRows.
```

--------------------------------

### TilingScaleX

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.PictureFillFormat.html

Gets or sets the horizontal tiling scale.

```APIDOC
## Property: TilingScaleX

### Description
Gets or sets the horizontal tiling scale in range from 0 (0%) to 1 (100%).

### Signature
`public double TilingScaleX { get; set; }`
```

--------------------------------

### ExportToDataGridViewOptions Constructors

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.WinFormsUtilities.ExportToDataGridViewOptions.html

Initializes a new instance of the ExportToDataGridViewOptions class to define the range of data to be exported.

```APIDOC
## ExportToDataGridViewOptions()
Initializes an instance of ExportToDataGridViewOptions class to export the used cell range.

## ExportToDataGridViewOptions(int startRow, int startColumn, int numberOfRows, int numberOfColumns)
Initializes an instance of ExportToDataGridViewOptions class with specific row and column indices.

## ExportToDataGridViewOptions(string startCell, int numberOfRows, int numberOfColumns)
Initializes an instance of ExportToDataGridViewOptions class using a starting cell name and dimensions.
```

--------------------------------

### WorksheetPanes(PanesState, float, float, string, PanePosition)

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.WorksheetPanes.html

Initializes a new instance of the WorksheetPanes class with specific state, split positions, top-left cell, and active pane.

```APIDOC
## WorksheetPanes(PanesState state, float xSplit, float ySplit, string topLeftCell, PanePosition activePane)

### Description
Initializes a new instance of the WorksheetPanes class.

### Parameters
- **state** (PanesState) - State of the panes.
- **xSplit** (float) - If frozen, number of columns in left pane. If not frozen, position of split in 1/20th of a point.
- **ySplit** (float) - If frozen, number of rows in top pane. If not frozen, position of split in 1/20th of a point.
- **topLeftCell** (string) - Top left visible cell in the bottom right pane.
- **activePane** (PanePosition) - Position of the active pane.
```

--------------------------------

### FillType

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.PictureFillFormat.html

Gets the fill format type for the picture.

```APIDOC
## Property: FillType

### Description
Gets the FillFormatType value, which is set to Picture.

### Type
FillFormatType
```

--------------------------------

### Converting to XpsDocument

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelFilePaginator.html

Converts the paginated workbook to an XpsDocument instance.

```C#
public XpsDocument ConvertToXpsDocument(XpsSaveOptions options)
```

```VB.NET
Public Function ConvertToXpsDocument(options As XpsSaveOptions) As XpsDocument
```

--------------------------------

### ExcelFilePage PageContent Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelFilePage.html

Gets the content of the page.

```C#
public FrameworkElement PageContent { get; }
```

```VB.NET
Public ReadOnly Property PageContent As FrameworkElement
```

--------------------------------

### UnderlineFill

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.TextFormat.html

Gets or sets the underline fill property.

```APIDOC
## Property: UnderlineFill

### Description
Gets or sets the underline fill.

### Signature
`public FillFormat UnderlineFill { get; set; }`

### Property Value
- **FillFormat** - The underline fill.
```

--------------------------------

### GradientStop(Double, DrawingColor)

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.GradientStop.html

Initializes a new instance of the GradientStop struct with a specified position and color.

```APIDOC
## GradientStop(double position, DrawingColor color)

### Description
Initializes a new instance of the GradientStop struct with the specified position and color.

### Parameters
- **position** (double) - Required - The position in the gradient where the gradient stop is placed. Value must be between 0 and 1.
- **color** (DrawingColor) - Required - The color value of the gradient stop.
```

--------------------------------

### Strikethrough

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.TextFormat.html

Gets or sets the text strikethrough property.

```APIDOC
## Property: Strikethrough

### Description
Gets or sets the text strikethrough. Default value is None.

### Signature
`public StrikethroughType Strikethrough { get; set; }`

### Property Value
- **StrikethroughType** - The text strikethrough.
```

--------------------------------

### Item[String]

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.CellStyleCollection.html

Retrieves a style by its string name, creating it if it does not exist.

```APIDOC
## Property: Item[String]

### Description
Gets the Style that corresponds to the given name. If the style does not exist, it is created and returned.

### Parameters
- **styleName** (System.String) - The name of the style.

### Return Value
- **Style** - The requested or newly created style.
```

--------------------------------

### Initialize XlsSaveOptions

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.XlsSaveOptions.html

Constructor for creating a new instance of the XlsSaveOptions class.

```csharp
public XlsSaveOptions()
```

```vbnet
Public Sub New
```

--------------------------------

### Type

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.DataValidation.html

Gets or sets the type of data validation.

```APIDOC
## Property: Type

### Description
Gets or sets the type of data validation.

### Type
DataValidationType
```

--------------------------------

### Level Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.DateTimeGroup.html

Gets the grouping level of this DateTimeGroup.

```C#
public readonly DateTimeGroupLevel Level { get; }
```

```VB.NET
Public ReadOnly Property Level As DateTimeGroupLevel
```

--------------------------------

### PaginatorOptions Constructor

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PaginatorOptions.html

Initializes a new instance of the PaginatorOptions class.

```C#
public PaginatorOptions()
```

```VB.NET
Public Sub New
```

--------------------------------

### FormControlType Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.Button.html

Gets the FormControlType value for the button.

```C#
public override FormControlType FormControlType { get; }
```

```VB.NET
Public Overrides ReadOnly Property FormControlType As FormControlType
```

--------------------------------

### FixedWidthLoadOptions Constructors

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.FixedWidthLoadOptions.html

Initializes a new instance of the FixedWidthLoadOptions class using either an array or an enumerable collection of FixedWidthColumn definitions.

```APIDOC
## FixedWidthLoadOptions(FixedWidthColumn[] columns)
## FixedWidthLoadOptions(IEnumerable<FixedWidthColumn> columns)

### Description
Initializes a new instance of the FixedWidthLoadOptions class with the specified column definitions.

### Parameters
- **columns** (FixedWidthColumn[] or IEnumerable<FixedWidthColumn>) - Required - The column definitions for the Fixed-Width Text file.
```

--------------------------------

### Type

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.CsvLoadOptions.html

Gets or sets the value delimiter type.

```APIDOC
## Property: Type

### Description
Gets or sets the value delimiter type, see CsvType.

### Type
System.Nullable<CsvType>

### Exceptions
- **System.ArgumentNullException**: Thrown if the value is set to null.
```

--------------------------------

### Create a number format

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.NumberFormatBuilder.html

Constructs a numeric format string with configurable decimal places, digit padding, separators, and negative value notation.

```C#
public static string Number(int decimalPlaces, int minDigits = 1, bool useThousandsSeparator = false, bool useParenthesesToDisplayNegativeValue = false)
```

```VB.NET
Public Shared Function Number(decimalPlaces As Integer, minDigits As Integer = 1, useThousandsSeparator As Boolean = False, useParenthesesToDisplayNegativeValue As Boolean = False) As String
```

--------------------------------

### Configure PDF Version

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.PdfSaveOptions.html

Sets or gets the PDF specification version for the output file. If null, the version is automatically determined based on document features.

```csharp
public PdfVersion? Version { get; set; }
```

```vbnet
Public Property Version As PdfVersion?
```

--------------------------------

### Item Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ConditionalFormatting.ConditionalFormatRuleCollection.html

Gets the rule at the specified index.

```C#
public ConditionalFormatRule this[int index] { get; }
```

```VB.NET
Public ReadOnly Property Item(index As Integer) As ConditionalFormatRule
```

--------------------------------

### Create Color from Name

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.Drawing.DrawingColor.html

Creates a new color instance from a predefined color name.

```C#
public static DrawingColor FromName(DrawingColorName name)
```

```VB.NET
Public Shared Function FromName(name As DrawingColorName) As DrawingColor
```

--------------------------------

### DataTableValue Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.DataTableCellToExcelCellConvertingEventArgs.html

Gets the source value from DataTable.

```C#
public object DataTableValue { get; }
```

```VB.NET
Public ReadOnly Property DataTableValue As Object
```

--------------------------------

### ExtractDataOptions Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.CreateDataTableOptions.html

Gets or sets the extraction options.

```C#
public ExtractDataOptions ExtractDataOptions { get; set; }
```

```VB.NET
Public Property ExtractDataOptions As ExtractDataOptions
```

--------------------------------

### Clone()

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ExcelFile.html

Creates a deep copy of the current ExcelFile instance.

```C#
public ExcelFile Clone()
```

```VB.NET
Public Function Clone As ExcelFile
```

--------------------------------

### ConditionType Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.ConditionalFormatting.AboveOrBelowAverageCondition.html

Gets the AboveOrBelowAverage condition type.

```C#
public override FormatConditionType ConditionType { get; }
```

```VB.NET
Public Overrides ReadOnly Property ConditionType As FormatConditionType
```

--------------------------------

### Access TxtDefault Property

Source: https://www.gemboxsoftware.com/spreadsheet/docs/GemBox.Spreadsheet.LoadOptions.html

Retrieves default options for loading tab-delimited files.

```C#
public static CsvLoadOptions TxtDefault { get; }
```

```VB.NET
Public Shared ReadOnly Property TxtDefault As CsvLoadOptions
```
Tokens:
Raw