I have a spread sheet which contained 8 columns and every day data ( rows ) will append to the spread sheet. I need a solution to read only 4 columns ( 1 column is Account number as key field ) into Automation, filter the data by passing required account number and read the rest of 3 columns data ( Name , DOB and Address ) for that account number.
Please suggest if any one had already a solution for this.
The connector does not have methods for applying filters via Excel, so if you'd prefer to do that, then that would require a lot more programming. You can probably look into "Excel Interop" for some C# code you might use to be able to apply filters in Excel itself.