Question
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.
Thank you @grona for your reply, I'm actually using the excel connector to read the Excel file. My question is regarding the DataGridView in a Windows Form. The contents of the excel file is the source of the data that I want to show in a Data Table in a windows form.
To give context of what I'm trying to achieve: I have used the Excel connector to read an Excel Workbook/Worksheet. I get the range of used cells, then I iterate all the rows and read each row retrieving each row/column value
I would like to be able to put all the contents of the excel (100 rows, 5 columns) into a data table in a windows forms.
Would appreciate very much your help in this regard. #helpme
Accepted Solution
Well, I figured it out.
I added a Lookup Table component to my GC and configured it to fit the columns of my spreadsheet. Then I dragged into the windows form a Data Grid View component and configured to use as a datasource the tableview from the GC.
In my automation that iterates and retrieves all the data from the Excel Worksheet I mapped the output of each row into the AddRecord method of the lookupTable.
You need to use the Excel connector.
http://help.openspan.com/80/Components/Microsoft_Excel.htm