import data from columns multi sheets from excel

Question

How import data from columns multi sheets from excel to dataGridView ?

Ranjit Powar · Answer

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.

Ranjit Powar · Answer

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

ابو يوسف الحربي · Answer

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

Alex Smith · 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

Hemant Srivastava · Answer

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