ImportDataTable(DataTable,Boolean,Int32,Int32) Method

Imports data from a System.Data.DataTable into a worksheet with specified row and column.

Syntax

Visual Basic
C#

'Declaration
 
Overloads Function ImportDataTable( _
   ByVal dataTable As DataTable, _
   ByVal isFieldNameShown As Boolean, _
   ByVal firstRow As Integer, _
   ByVal firstColumn As Integer _
) As Integer

'Usage
 
Dim instance As IWorksheet
Dim dataTable As DataTable
Dim isFieldNameShown As Boolean
Dim firstRow As Integer
Dim firstColumn As Integer
Dim value As Integer
 
value = instance.ImportDataTable(dataTable, isFieldNameShown, firstRow, firstColumn)

int ImportDataTable( 
   DataTable dataTable,
   bool isFieldNameShown,
   int firstRow,
   int firstColumn
)

Parameters

dataTable: DataTable with desired data.
isFieldNameShown: TRUE if column names must be imported. FALSE otherwise.
firstRow: First row from where the data should be imported.
firstColumn: First column from where the data should be imported.

Return Value

Number of imported rows.

Remarks

This method is supported in ASP.NET Core, Xamarin, and UWP platforms from .NET Standard 2.0 onward.. To know more about ImportDataTable refer this link

Example

The following code illustrates how to Imports data from a System.Data.DataTable into a worksheet with specified row and column.

using Syncfusion.XlsIO;
using System.Data;
             
class Example
{
  static void Main()
  {
     ExcelEngine excelEngine = new ExcelEngine();
     IApplication application = excelEngine.Excel;
     application.DefaultVersion = ExcelVersion.Excel2013;
     IWorkbook workbook = application.Workbooks.Create(1);
     IWorksheet worksheet = workbook.Worksheets[0];
     
     //Initialize DataTable and data get from SampleDataTable method
     DataTable table = SampleDataTable();
     
     //Import data from DataTable
     worksheet.ImportDataTable(table, true, 1, 1);
     
     workbook.SaveAs("ImportDataTable.xlsx");
     workbook.Close();
     excelEngine.Dispose();
  } 
  
  static DataTable SampleDataTable()
  {
    // Here we create a three columns
    DataTable table = new DataTable();
    table.Columns.Add("ID", typeof(int));
    table.Columns.Add("Item", typeof(string));
    table.Columns.Add("Name", typeof(string));
            
    // Here we add four DataRows
    table.Rows.Add(1, "Soap", "David");
    table.Rows.Add(2, "Paste", "Sam");
    table.Rows.Add(3, "Cream", "Christoff");
    table.Rows.Add(4, "Powder", "Janet");
    return table;
  }
}

AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

Reference

IWorksheet Interface
IWorksheet Members
Overload List