Question
2
Replies
2045
Views
Posted: September 18, 2017
Last activity: October 6, 2017
Closed
Solved
Excel Connector
Hi,
I would like to know whether there is a way to get the records of a particular column( depending on the column name like customer ID, place etc rather than A1, D3 etc).This is because additional columns would be inserted into the sheet.
Also if I use ExportData, the cellStart and cellEnd has to be specified. Is there a way to read the entire set of records without specifying the cell name?
Thanks in advance.
Hi,
We can create a .net component using excel.introp to read the excel and keep all the values in a table.
Then we can use query with a column name to retrieve the values.
it give us more flexibility and usability then a excel connector.
And with a .net component it will make your code more reusable.