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

Visual Basic
C#

'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.40

Reference

IWorksheet Interface
IWorksheet Members
Overload List