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

using System; 
using System.Data;
using System.Windows.Forms;
using EasyXLS;

namespace WindowsFormsApplication
{
    public partial class ImportExcelForm : Form
    {
        public ImportExcelForm()
        {
            InitializeComponent();
            FillDataGridView();
        }

        private void FillDataGridView()
        {
            // 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 DataGridView.xlsx");
            
            // Get the DataTable of the DataSet
            DataTable dataTable = ds.Tables[0];

            // Extract the first Excel row as header
            Object[] header = dataTable.Rows[0].ItemArray;
            dataTable.Rows.RemoveAt(0);
            
            // Set the data source of the DataGridView
            dataGridView.DataSource = dataTable;

            // Set DataGridView header data from the first Excel row
            for (int column = 0; column < dataTable.Columns.Count; column++)
            {
                dataGridView.Columns[column].HeaderText = (String)header[column];
            }
        }
    }
}

Imports EasyXLS

Public Class ImportFromExcelForm

    Private Sub ImportFromExcel_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) _
                                                                                 Handles MyBase.Load
        FillDataGridView()
    End Sub

    Private Sub FillDataGridView()

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

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

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

        ' Extract the first Excel row as header
        Dim header As Object() = dataTable.Rows(0).ItemArray
        dataTable.Rows.RemoveAt(0)

        ' Set the data source of the DataGridView
        dataGridView.DataSource = dataTable

        ' Set DataGridView header data from the first Excel row
        For column As Integer = 0 To dataTable.Columns.Count - 1
            dataGridView.Columns(column).HeaderText = header(column)
        Next
    End Sub
End Class

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

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

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

    // Import Excel sheet to DataSet
    DataSet ds = workbook.easy_ReadExcelWorksheet_AsDataSet(xlsSheet);
    
    // Get the DataTable of the DataSet
    DataTable dataTable = ds.Tables[0];

    // Extract the first Excel row as header
    Object[] header = dataTable.Rows[0].ItemArray;
    dataTable.Rows.RemoveAt(0);
    
    // Set the data source of the DataGridView
    dataGridView.DataSource = dataTable;

    // Set DataGridView header data from the first Excel row
    for (int column = 0; column < dataTable.Columns.Count; column++)
    {
        dataGridView.Columns[column].HeaderText = (String)header[column];
    }

    // Set DataGridView header formatting (assuming that all header columns have the same format)
    ExcelStyle xlsStyleHeader = xlsSheet.easy_getExcelTable().easy_getCell(0, 0).getStyle();
    dataGridView.ColumnHeadersDefaultCellStyle.BackColor = xlsStyleHeader.getBackground();
    dataGridView.ColumnHeadersDefaultCellStyle.Font = 
                 new System.Drawing.Font(xlsStyleHeader.getFont(), xlsStyleHeader.getFontSize());
    dataGridView.ColumnHeadersDefaultCellStyle.ForeColor = xlsStyleHeader.getForeground();

    // Set DataGridView cell formatting (assuming that all cells have the same format)
    ExcelStyle xlsStyleData = xlsSheet.easy_getExcelTable().easy_getCell(1, 0).getStyle();
    for (int column = 0; column < dataTable.Columns.Count; column++)
    {
        dataGridView.Columns[column].DefaultCellStyle.BackColor = xlsStyleData.getBackground();
        dataGridView.Columns[column].DefaultCellStyle.Font = 
                     new System.Drawing.Font(xlsStyleData.getFont(), xlsStyleData.getFontSize());
        dataGridView.Columns[column].DefaultCellStyle.ForeColor = xlsStyleData.getForeground();
    }

    // Set DataGridView column widths
    for (int column = 0; column < dataTable.Columns.Count; column++)
    {
        dataGridView.Columns[column].Width = xlsSheet.easy_getExcelTable().getColumnWidth(column);
    }
}

Private Sub FillDataGridView()

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

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

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

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

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

    ' Extract the first Excel row as header
    Dim header As Object() = dataTable.Rows(0).ItemArray
    dataTable.Rows.RemoveAt(0)

    ' Set the data source of the DataGridView
    dataGridView.DataSource = dataTable

    ' Set DataGridView header data from the first Excel row
    For column As Integer = 0 To dataTable.Columns.Count - 1
        dataGridView.Columns(column).HeaderText = header(column)
    Next

    ' Set DataGridView header formatting (assuming that all header columns have the same format)
    Dim xlsStyleHeader As ExcelStyle = xlsSheet.easy_getExcelTable().easy_getCell(0, 0).getStyle()
    dataGridView.ColumnHeadersDefaultCellStyle.BackColor = xlsStyleHeader.getBackground()
    dataGridView.ColumnHeadersDefaultCellStyle.Font = _
                 New System.Drawing.Font(xlsStyleHeader.getFont(), xlsStyleHeader.getFontSize())
    dataGridView.ColumnHeadersDefaultCellStyle.ForeColor = xlsStyleHeader.getForeground()

    ' Set DataGridView cell formatting (assuming that all cells have the same format)
    Dim xlsStyleData As ExcelStyle = xlsSheet.easy_getExcelTable().easy_getCell(1, 0).getStyle()
    dataGridView.DefaultCellStyle.BackColor = xlsStyleData.getBackground()

    ' Set DataGridView column widths
    For column As Integer = 0 To dataTable.Columns.Count - 1
        dataGridView.Columns(column).Width = xlsSheet.easy_getExcelTable().getColumnWidth(column)
    Next
End Sub