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
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.