I use a OdbcConnection string to read xls sheet into a data table (VB.net)
is there a property I can use to omit formulas (ex. Vlookup) and use the values instead?
I tried to add "Allow Formula=false" but the data table shows only the columns before the one with the formula.
Thank you for the feedback.