Cells.ImportData

ImportData(ICellsDataTable, int, int, ImportTableOptions)

Import data from custom data table.

public int ImportData(ICellsDataTable table, int firstRow, int firstColumn, 
    ImportTableOptions options)

Parameter	Type	Description
table	ICellsDataTable	The custom data table.
firstRow	Int32	First row index.
firstColumn	Int32	First column index.
options	ImportTableOptions	The import options

See Also

• interface ICellsDataTable
• class ImportTableOptions
• class Cells
• namespace Aspose.Cells
• assembly Aspose.Cells

---

ImportData(DataTable, int, int, ImportTableOptions)

Import data from custom data table.

public int ImportData(DataTable table, int firstRow, int firstColumn, ImportTableOptions options)

Parameter	Type	Description
table	DataTable	The DataTable object to be imported.
firstRow	Int32	First row index.
firstColumn	Int32	First column index.
options	ImportTableOptions	The 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

• class ImportTableOptions
• class Cells
• namespace Aspose.Cells
• assembly Aspose.Cells

---

ImportData(DataView, int, int, ImportTableOptions)

Import data from data view.

public int ImportData(DataView dataView, int firstRow, int firstColumn, ImportTableOptions options)

Parameter	Type	Description
dataView	DataView	The DataView object to be imported.
firstRow	Int32	First row index.
firstColumn	Int32	First column index.
options	ImportTableOptions	The import options

Return Value

Total number of rows imported.

See Also

• class ImportTableOptions
• class Cells
• namespace Aspose.Cells
• assembly Aspose.Cells

---

ImportData(IDataReader, int, int)

Imports data from a IDataReader object.

public int ImportData(IDataReader reader, int firstRow, int firstColumn)

Parameter	Type	Description
reader	IDataReader	The IDataReader object which contains data.
firstRow	Int32	The row number of the first cell to import in.
firstColumn	Int32	The column number of the first cell to import in.

Return Value

Total number of rows imported.

See Also

• class Cells
• namespace Aspose.Cells
• assembly Aspose.Cells

---

ImportData(IDataReader, int, int, ImportTableOptions)

Imports data from a IDataReader object.

public int ImportData(IDataReader reader, int firstRow, int firstColumn, ImportTableOptions options)

Parameter	Type	Description
reader	IDataReader	The IDataReader object which contains data.
firstRow	Int32	The row number of the first cell to import in.
firstColumn	Int32	The column number of the first cell to import in.
options	ImportTableOptions	The options of importing table.

Return Value

Total number of rows imported.

See Also

• class ImportTableOptions
• class Cells
• namespace Aspose.Cells
• assembly Aspose.Cells