Class DataImportExport

Provides conversions between spreadsheet ranges and tabular ADO.NET data structures.

Inheritance

object

DataImportExport

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet

Assembly: DRIT.Spreadsheet.dll

Syntax

public class DataImportExport

Constructors

DataImportExport()

Provides conversions between spreadsheet ranges and tabular ADO.NET data structures.

Declaration

public DataImportExport()

Methods

ExportRangeToDataTable(Range)

Writes rt range to data table from the DataImportExport.

Declaration

public static DataTable ExportRangeToDataTable(Range range)

Parameters

Type	Name	Description
Range	range	The range used by the operation.

Returns

Type	Description
DataTable	The export range to data table returned by the operation.

ExportRangeToDataTable(Range, DataTableExportOptions)

Exports the range To Data Table.

Declaration

public static DataTable ExportRangeToDataTable(Range range, DataTableExportOptions options)

Parameters

Type	Name	Description
Range	range
DataTableExportOptions	options

Returns

Type	Description
DataTable

ExportRangeToJson(Range)

Writes rt range to json from the DataImportExport.

Declaration

public static string ExportRangeToJson(Range range)

Parameters

Type	Name	Description
Range	range	The range used by the operation.

Returns

Type	Description
string	The export range to json returned by the operation.

ExportRangeToJson(Range, JsonExportOptions)

Writes rt range to json from the DataImportExport.

Declaration

public static string ExportRangeToJson(Range range, JsonExportOptions options)

Parameters

Type	Name	Description
Range	range	The range used by the operation.
JsonExportOptions	options	The options used by the operation.

Returns

Type	Description
string	The export range to json returned by the operation.

Import(Cell, DataTable)

Loads rt into the DataImportExport.

Declaration

public static void Import(Cell topLeftCell, DataTable dataTable)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
DataTable	dataTable	The data table used by the operation.

Import(Cell, DataTable, DataTableImportOptions)

Loads rt into the DataImportExport.

Declaration

public static void Import(Cell topLeftCell, DataTable dataTable, DataTableImportOptions importOptions)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
DataTable	dataTable	The data table used by the operation.
DataTableImportOptions	importOptions	The import options used by the operation.

Import(Cell, DataView)

Loads rt into the DataImportExport.

Declaration

public static void Import(Cell topLeftCell, DataView dataView)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
DataView	dataView	The data view used by the operation.

Import(Cell, DataView, DataViewImportOptions)

Loads rt into the DataImportExport.

Declaration

public static void Import(Cell topLeftCell, DataView dataView, DataViewImportOptions importOptions)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
DataView	dataView	The data view used by the operation.
DataViewImportOptions	importOptions	The import options used by the operation.

Import(Cell, string)

Loads rt into the DataImportExport.

Declaration

public static void Import(Cell topLeftCell, string json)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
string	json	The json used by the operation.

Import(Cell, string, JsonImportOptions)

Loads rt into the DataImportExport.

Declaration

public static void Import(Cell topLeftCell, string json, JsonImportOptions options)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
string	json	The json used by the operation.
JsonImportOptions	options	The options used by the operation.

ImportToColumns(Cell, ArrayList)

Loads rt to columns into the DataImportExport.

Declaration

public static void ImportToColumns(Cell topLeftCell, ArrayList items)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
ArrayList	items	The items used by the operation.

ImportToColumns(Cell, ICollection)

Loads rt to columns into the DataImportExport.

Declaration

public static void ImportToColumns(Cell topLeftCell, ICollection items)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
ICollection	items	The items used by the operation.

ImportToColumns(Cell, string[])

Loads rt to columns into the DataImportExport.

Declaration

public static void ImportToColumns(Cell topLeftCell, string[] items)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
string[]	items	The items used by the operation.

ImportToRows(Cell, ArrayList)

Loads rt to rows into the DataImportExport.

Declaration

public static void ImportToRows(Cell topLeftCell, ArrayList items)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
ArrayList	items	The items used by the operation.

ImportToRows(Cell, ICollection)

Loads rt to rows into the DataImportExport.

Declaration

public static void ImportToRows(Cell topLeftCell, ICollection items)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
ICollection	items	The items used by the operation.

ImportToRows(Cell, string[])

Loads rt to rows into the DataImportExport.

Declaration

public static void ImportToRows(Cell topLeftCell, string[] items)

Parameters

Type	Name	Description
Cell	topLeftCell	The top left cell used by the operation.
string[]	items	The items used by the operation.