Cells.ImportData

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

Copy// Called: wb.Worksheets[0].Cells.ImportData(dt, 0, 0, new ImportTableOptions());
public void Cells_Method_ImportData()
{
    Workbook wb = new Workbook();

    ArrayList dataLists = new ArrayList();
    dataLists.Add(new object[] { "Name", "Age", "Gender" });
    dataLists.Add(new object[] { "Alice", 30, "Female" });
    dataLists.Add(new object[] { "Bob", 25, "Male" });
    dataLists.Add(new object[] { "Charlie", 35, "Male" });

    ICellsDataTable dt = wb.CellsDataTableFactory.GetInstance(dataLists, true);

    wb.Worksheets[0].Cells.ImportData(dt, 0, 0, new ImportTableOptions());
    Assert.AreEqual("Alice", wb.Worksheets[0].Cells["A2"].StringValue);

    wb.Worksheets.Add();
    wb.Worksheets[1].Cells.ImportArrayList(dataLists, 0, 0, true);
    Assert.AreEqual("Bob", wb.Worksheets[1].Cells["A3"].StringValue);
}

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

Copy
[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)

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

Copy// Called: cells.ImportData(dataview, 1048572, 16383, options);
public void Cells_Method_ImportData()
{
    caseName = "testImportDataColumn_Excel2007_007";
    Workbook workbook = new Workbook();
    Cells cells = workbook.Worksheets[0].Cells;
    cells[1048572, 16383].PutValue(10);
    DataView dataview = getDataTable().DefaultView;
    ImportTableOptions options = new ImportTableOptions();
    options.ColumnIndexes = new int[] { 1 };
    options.IsFieldNameShown = false;
    options.InsertRows = true;

    cells.ImportData(dataview, 1048572, 16383, options);

    checkImportDataColumn_Excel2007_007(workbook);
    workbook.Save(Constants.destPath + "testImportDataColumn.xlsx");            
    workbook = new Workbook(Constants.destPath + "testImportDataColumn.xlsx");
    checkImportDataColumn_Excel2007_007(workbook);
    workbook.Save(Constants.destPath + "testImportDataColumn.xml", SaveFormat.SpreadsheetML );            
    workbook = new Workbook(Constants.destPath + "testImportDataColumn.xml");
    workbook.Save(Constants.destPath + "testImportDataColumn.xls");
}

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

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

Copy// Called: int vNumberOfRowInsert = worksheet.Cells.ImportData(Reader1, 8, 0, options);
public void Cells_Method_ImportData()
{
    string path = Constants.sourcePath;
    Workbook dataWB = new Workbook(path + "example.xlsx");


    Worksheet dataWS = dataWB.Worksheets[0];


    DataTable dt = dataWS.Cells.ExportDataTable(0, 0, 25, 4, true);


    DataTableReader Reader1 = dt.CreateDataReader();


    Workbook workbook = new Workbook(path + "example.xls");


    Worksheet worksheet = workbook.Worksheets[0];

    ImportTableOptions options = new ImportTableOptions();
    options.IsFieldNameShown = false;
    options.InsertRows = true;
    options.ConvertNumericData = false;
    options.DateFormat = "dd/MM/yyyy";
  //  options.TotalRows = dt.Rows.Count;

    int vNumberOfRowInsert = worksheet.Cells.ImportData(Reader1, 8, 0, options);
    Assert.AreEqual(worksheet.Cells["A35"].StringValue, "New Members");
}