import data from columns multi sheets from excel

You can read all sheets one bye one into datatable. And then assign that datatable as datasource to datagridview.

Thank you for your answer I have an Excel file contains many sheets I Do I All sheets imported data to datagridview once

Hi check this

http://www.c-sharpcorner.com/blogs/get-all-sheets-from-excel-and-fill-data-of-selected-excel-sheet-in-datagridview

If it helps you, select it as correct answer.

Using Spire.XLS, you're able to Import data from Excel to DataGridView easily:

http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html

Let me know if you have any questions

From here you get the idea how to import the data from Excel sheet.

http://www.easyxls.com/manual/FAQ/import-excel-to-datagridview.html