Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IWorksheet Interface > ImportDataView Method : ImportDataView(DataView,Boolean,Int32,Int32,Int32,Int32,Boolean) Method
DataView with desired data.
TRUE if column names must also be imported. FALSE otherwise.
First row from where the data should be imported.
First column from where the data should be imported.
Maximum number of rows to import.
Maximum number of columns to import.
Indicates whether XlsIO should try to preserve types in Data Table, i.e. if it is set to False (default) and in Data Table we have in string column value that contains only numbers, it would be converted to number.

ImportDataView(DataView,Boolean,Int32,Int32,Int32,Int32,Boolean) Method

Imports data from a System.Data.DataView into a worksheet with specified range 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, _
   ByVal bPreserveTypes As Boolean _
) 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 bPreserveTypes As Boolean
Dim value As Integer
 
value = instance.ImportDataView(dataView, isFieldNameShown, firstRow, firstColumn, maxRows, maxColumns, bPreserveTypes)

Parameters

dataView
DataView with desired data.
isFieldNameShown
TRUE if column names must also 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.
bPreserveTypes
Indicates whether XlsIO should try to preserve types in Data Table, i.e. if it is set to False (default) and in Data Table we have in string column value that contains only numbers, it would be converted to number.

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, true);
     
     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.40

See Also