Cells.ImportData

ImportData(ICellsDataTable, int, int, ImportTableOptions)

Import data from custom data table.

public int ImportData(ICellsDataTable table, int firstRow, int firstColumn, 
    ImportTableOptions options)
ParameterTypeDescription
tableICellsDataTableThe custom data table.
firstRowInt32First row index.
firstColumnInt32First column index.
optionsImportTableOptionsThe import options

See Also


ImportData(DataTable, int, int, ImportTableOptions)

Import data from custom data table.

public int ImportData(DataTable table, int firstRow, int firstColumn, ImportTableOptions options)
ParameterTypeDescription
tableDataTableThe DataTable object to be imported.
firstRowInt32First row index.
firstColumnInt32First column index.
optionsImportTableOptionsThe import options

Return Value

Total number of rows imported.

Examples


[C#]

Workbook excel = new Workbook();
Cells cells = excel.Worksheets[0].Cells;

//Import data
DataTable dt = new DataTable("Products");
dt.Columns.Add("Product_ID",typeof(Int32));
dt.Columns.Add("Product_Name",typeof(string));
dt.Columns.Add("Units_In_Stock",typeof(Int32));
DataRow dr = dt.NewRow();
dr[0] = 1;
dr[1] = "Aniseed Syrup";
dr[2] = 15;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = 2;
dr[1] = "Boston Crab Meat";
dr[2] = 123;
dt.Rows.Add(dr);
ImportTableOptions options = new ImportTableOptions();
options.IsFieldNameShown = true;
cells.ImportData(dt, 12, 12, options);

[Visual Basic]

Dim excel as Workbook = new Workbook()
Dim cells as Cells = excel.Worksheets(0).Cells

'Import data
Dim dt as DataTable = new DataTable("Employee")
dt.Columns.Add("Employee_ID",typeof(Int32))
dt.Columns.Add("Employee_Name",typeof(string))
dt.Columns.Add("Gender",typeof(string))
Dim dr as DataRow = dt.NewRow()
dr(0) = 1
dr(1) = "John Smith"
dr(2) = "Male"
dt.Rows.Add(dr)
dr = dt.NewRow()
dr(0) = 2
dr(1) = "Mary Miller"
dr(2) = "Female"
dt.Rows.Add(dr)
Dim options as ImportTableOptions = new ImportTableOptions()
options.IsFieldNameShown = True
cells.ImportData(dt, 12, 12, options)

'Export data
Dim outDataTable as DataTable = cells.ExportDataTable(12, 12, 10, 10)

See Also


ImportData(DataView, int, int, ImportTableOptions)

Import data from data view.

public int ImportData(DataView dataView, int firstRow, int firstColumn, ImportTableOptions options)
ParameterTypeDescription
dataViewDataViewThe DataView object to be imported.
firstRowInt32First row index.
firstColumnInt32First column index.
optionsImportTableOptionsThe import options

Return Value

Total number of rows imported.

See Also


ImportData(IDataReader, int, int)

Imports data from a IDataReader object.

public int ImportData(IDataReader reader, int firstRow, int firstColumn)
ParameterTypeDescription
readerIDataReaderThe IDataReader object which contains data.
firstRowInt32The row number of the first cell to import in.
firstColumnInt32The column number of the first cell to import in.

Return Value

Total number of rows imported.

See Also


ImportData(IDataReader, int, int, ImportTableOptions)

Imports data from a IDataReader object.

public int ImportData(IDataReader reader, int firstRow, int firstColumn, ImportTableOptions options)
ParameterTypeDescription
readerIDataReaderThe IDataReader object which contains data.
firstRowInt32The row number of the first cell to import in.
firstColumnInt32The column number of the first cell to import in.
optionsImportTableOptionsThe options of importing table.

Return Value

Total number of rows imported.

See Also