ImportDataTable(DataTable,Boolean,Int32,Int32) Method
Imports data from a System.Data.DataTable into a worksheet with specified row and column.
Syntax
'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: 16.4460.0.52
See Also