ImportDataView(DataView,Boolean,Int32,Int32,Int32,Int32) Method
Imports data from a System.Data.DataView into a worksheet with specified row, column and preserve type.
Syntax
'Declaration Overloads Function ImportDataView( _ ByVal dataView As DataView, _ ByVal isFieldNameShown As Boolean, _ ByVal firstRow As Integer, _ ByVal firstColumn As Integer, _ ByVal maxRows As Integer, _ ByVal maxColumns As Integer _ ) As Integer
'Usage Dim instance As IWorksheet Dim dataView As DataView Dim isFieldNameShown As Boolean Dim firstRow As Integer Dim firstColumn As Integer Dim maxRows As Integer Dim maxColumns As Integer Dim value As Integer value = instance.ImportDataView(dataView, isFieldNameShown, firstRow, firstColumn, maxRows, maxColumns)
int ImportDataView( DataView dataView, bool isFieldNameShown, int firstRow, int firstColumn, int maxRows, int maxColumns )
Parameters
- dataView
- Data View 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.
- maxRows
- Maximum number of rows to import.
- maxColumns
- Maximum number of columns to import.
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 ImportDataView refer this link
Example
The following code illustrates how to Imports data from a System.Data.DataView into worksheet with the 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(); //Initialize dataview of datatable DataView view = table.DefaultView; //Import data from DataView worksheet.ImportDataView(view, true, 1, 1, 5, 2); workbook.SaveAs("ImportDataView.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 Ten 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"); table.Rows.Add(5, "Snacks", "Andrew"); table.Rows.Add(6, "Perfume", "Thomos"); table.Rows.Add(7, "Biscuit", "Stephen"); table.Rows.Add(8, "Cake", "Jones"); table.Rows.Add(9, "Fruit", "Yabes"); table.Rows.Add(10, "vegetable", "Marsion"); return table; } }
AssemblyVersion
Syncfusion.XlsIO.Base: 16.4460.0.52
See Also