DataImportOptions Class

Contains properties which allow you to specify whether the imported data are treated as formulas, the cell reference style in use, the culture-specific decimal and list separators and a custom value converter.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v22.1.Core.dll

Declaration

C#

public class DataImportOptions

VB.NET

Public Class DataImportOptions

Remarks

When calling the WorksheetExtensions.Import method, create the DataImportOptions instance, use its properties to specify required options and pass it to the method.

Example

View Example

Form1.vb

Dim arrayR1C1() As String = { "a", "b", "=R1C1&R1C2" }
worksheet.Import(arrayR1C1, 0, 0, False, New DataImportOptions() With {.ImportFormulas = True, .ReferenceStyle = ReferenceStyle.R1C1})

Dim arrayLocalized() As String = { "a", "=1,2+1" }
worksheet.Import(arrayLocalized, 1, 0, False, New DataImportOptions() With {.ImportFormulas = True, .FormulaCulture = New System.Globalization.CultureInfo("de-DE")})

Form1.cs

string[] arrayR1C1 = new string[] { "a", "b", "=R1C1&R1C2" };
worksheet.Import(arrayR1C1, 0, 0, false, new DataImportOptions() { ImportFormulas = true, ReferenceStyle = ReferenceStyle.R1C1 });

string[] arrayLocalized = new string[] { "a", "=1,2+1" };
worksheet.Import(arrayLocalized, 1, 0, false, 
    new DataImportOptions() { ImportFormulas = true, FormulaCulture = new System.Globalization.CultureInfo("de-DE") });

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the DataImportOptions class.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-import-data-to-worksheet-cells-from-different-data-sources-and-use-tables-e4751/CS/DataImportExample/Form1.cs#L207

string[] arrayR1C1 = new string[] { "a", "b", "=R1C1&R1C2" };
worksheet.Import(arrayR1C1, 0, 0, false, new DataImportOptions() { ImportFormulas = true, ReferenceStyle = ReferenceStyle.R1C1 });

spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/ImportActions.cs#L94

// Import data as formulas in German locale (decimal and list separators).
worksheet.Import(array, 0, 0, false, new DataImportOptions() { ImportFormulas = true,
    FormulaCulture = new System.Globalization.CultureInfo("de-DE") });

VB.NET

how-to-import-data-to-worksheet-cells-from-different-data-sources-and-use-tables-e4751/VB/DataImportExample/Form1.vb#L199

Dim arrayR1C1() As String = { "a", "b", "=R1C1&R1C2" }
worksheet.Import(arrayR1C1, 0, 0, False, New DataImportOptions() With {.ImportFormulas = True, .ReferenceStyle = ReferenceStyle.R1C1})

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/ImportActions.vb#L89

' Import data as formulas in German locale (decimal and list separators).
worksheet.Import(array, 0, 0, False, New DataImportOptions() With {.ImportFormulas = True, .FormulaCulture = New Globalization.CultureInfo("de-DE")})
Dim arrayR1C1 As String() = New String() {"=3.141", "=R[-1]C+1.01"}

Inheritance

Object

DataImportOptions

DataSourceImportOptions