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?
Please see the post below. I discuss how you can get the UsedRange of an Excel sheet. It isn't 100% accurate however as Excel will report cells that are empty, although I believe it will always report 100% of the cells (it just may have extras if those cells were ever used). You could then filter the DataTable object in a script to exclude the empty rows.