read excel file and display only table in gridview

C# Corner

Manoj Mandal

4y720.NET

i want to read the excel and display only the table data in gridview

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Leon D4y ago

Check this:

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

Workbook workbook = new Workbook();         
workbook.LoadFromFile(@"..\FandH.xlsx");            
Worksheet sheet = workbook.Worksheets[0];  
this.dataGridView1.DataSource = sheet.ExportDataTable();

Srinivasan Ramamoorthi4y ago
you can create a range name for the table in excel. In C# you can access the table using the range name

try this link for reading data from range name

https://stackoverflow.com/questions/24125947/how-to-get-an-existing-range-name-from-an-excel-worksheet-using-c-sharp-excel-in
+1
Manoj Mandal4y ago
i have attached the image file
+1
Srinivasan Ramamoorthi4y ago
I am unable to access the file, can you post the snapshot?
+1
Manoj Mandal4y ago
in my excel i have table and raw data but i need only the table
+1
Srinivasan Ramamoorthi4y ago
Check this link for windows application https://www.c-sharpcorner.com/UploadFile/6b8651/read-excel-file-in-windows-application-using-C-Sharp/
+1