How to import Excel file to GridView in C# and VB.NET

using System;
using System.Data;
using System.Linq;
using EasyXLS; 

namespace WebApplication
{
    public partial class ImportToGridView : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            this.BindGridView();
        }

        private void BindGridView()
        {
            // Create an instance of the class that imports Excel files
            ExcelDocument workbook = new ExcelDocument();

            // Import Excel file to DataSet
            DataSet ds = workbook.easy_ReadXLSXActiveSheet_AsDataSet("C:\\Samples\\Excel to GridView.xlsx");

            // Get the DataTable of the DataSet
            DataTable dataTable = ds.Tables[0];

            // Set GridView header from the first Excel row
            for (int column = 0; column < dataTable.Columns.Count; column++)
            {
                gridView.Columns[column].HeaderText = (string)dataTable.Rows[0][column];
            }
            dataTable.Rows.RemoveAt(0);

            // Set the data source of the GridView
            gridView.DataSource = dataTable;
            gridView.DataBind();
        }
     }
}

Imports EasyXLS

Partial Public Class ImportToGridView
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        BindGridView()
    End Sub

    Private Sub BindGridView()
        ' Create an instance of the class that imports Excel files
        Dim workbook As New ExcelDocument()

        ' Import Excel file to DataSet
        Dim ds = workbook.easy_ReadXLSXActiveSheet_AsDataSet("C:\Samples\Excel to GridView.xlsx")

        ' Get the DataTable of the DataSet
        Dim dataTable = ds.Tables(0)

        ' Set GridView header from the first Excel row
        For column As Integer = 0 To dataTable.Columns.Count - 1

            gridView.Columns(column).HeaderText = dataTable.Rows(0)(column)
        Next
        dataTable.Rows.RemoveAt(0)

        ' Set the data source of the GridView
        gridView.DataSource = dataTable
        gridView.DataBind()
    End Sub
End Class

private void BindGridView()
{
    // Create an instance of the class that imports Excel files
    ExcelDocument workbook = new ExcelDocument();

    // Import Excel file
    workbook.easy_LoadXLSXFile("C:\\Samples\\Excel to GridView.xlsx");

    // Get the first sheet from the Excel file
    ExcelWorksheet xlsSheet = (ExcelWorksheet)workbook.easy_getSheetAt(0);

    // Import Excel file to DataSet
    DataSet ds = workbook.easy_ReadExcelWorksheet_AsDataSet(xlsSheet);

    // Get the DataTable of the DataSet
    DataTable dataTable = ds.Tables[0];

    // Set GridView header from the first Excel row
    for (int column = 0; column < dataTable.Columns.Count; column++)
    {
        gridView.Columns[column].HeaderText = (string)dataTable.Rows[0][column];
    }
    dataTable.Rows.RemoveAt(0);

    // Set the data source of the GridView
    gridView.DataSource = dataTable;
    gridView.DataBind();

    // Set GridView header formatting (assuming that all header columns have the same format)
    ExcelStyle xlsStyleHeader = xlsSheet.easy_getExcelTable().easy_getCell(0, 0).getStyle();
    gridView.HeaderStyle.BackColor = xlsStyleHeader.getBackground();
    gridView.HeaderStyle.Font.Name = xlsStyleHeader.getFont();
    gridView.HeaderStyle.ForeColor = xlsStyleHeader.getForeground();

    // Set GridView cell formatting (assuming that all cells have the same format)
    ExcelStyle xlsStyleData = xlsSheet.easy_getExcelTable().easy_getCell(1, 0).getStyle();
    gridView.RowStyle.BackColor = xlsStyleData.getBackground();
    gridView.RowStyle.Font.Name = xlsStyleData.getFont();
    gridView.RowStyle.ForeColor = xlsStyleData.getForeground();
}

Private Sub BindGridView()
    ' Create an instance of the class that imports Excel files
    Dim workbook As New ExcelDocument()

    ' Import Excel file
    workbook.easy_LoadXLSXFile("C:\Samples\Excel to GridView.xlsx")

    ' Get the first sheet from the Excel file
    Dim xlsSheet As ExcelWorksheet = workbook.easy_getSheetAt(0)

    ' Import Excel file to DataSet
    Dim ds = workbook.easy_ReadExcelWorksheet_AsDataSet(xlsSheet)

    ' Get the DataTable of the DataSet
    Dim dataTable = ds.Tables(0)

    ' Set GridView header from the first Excel row
    For column As Integer = 0 To dataTable.Columns.Count - 1
        gridView.Columns(column).HeaderText = dataTable.Rows(0)(column)
    Next
    dataTable.Rows.RemoveAt(0)

    ' Set the data source of the GridView
    gridView.DataSource = dataTable
    gridView.DataBind()

    ' Set GridView header formatting (assuming that all header columns have the same format)
    Dim xlsStyleHeader = xlsSheet.easy_getExcelTable().easy_getCell(0, 0).getStyle()
    gridView.HeaderStyle.BackColor = xlsStyleHeader.getBackground()
    gridView.HeaderStyle.Font.Name = xlsStyleHeader.getFont()
    gridView.HeaderStyle.ForeColor = xlsStyleHeader.getForeground()

    ' Set GridView cell formatting (assuming that all cells have the same format)
    Dim xlsStyleData = xlsSheet.easy_getExcelTable().easy_getCell(1, 0).getStyle()
    gridView.RowStyle.BackColor = xlsStyleData.getBackground()
    gridView.RowStyle.Font.Name = xlsStyleData.getFont()
    gridView.RowStyle.ForeColor = xlsStyleData.getForeground()
End Sub