Question
4
Replies
43
Views
Posted: March 11, 2019
Last activity: March 12, 2019
Closed
Solved
How to show the contents from simple Excel file into a Windows form DataGridView control
I'm trying to read from an excel file all the rows and columns in a specified range and show the result in a windows form using a DataGridView. However I'm lost as to how to do it.
I've already been able to read the excel worksheet, I only need pointers into how to show each read row into the data table of a windows form.
You need to use the Excel connector.
http://help.openspan.com/80/Components/Microsoft_Excel.htm