dv3
dv3

Reputation: 4579

ExcelDataReader ConfigureDataTable Error

I'm attempting to use .asDataSet() with a configuration:

Dim x_config As New ExcelDataSetConfiguration
Dim table_config As New ExcelDataTableConfiguration With {
                                                            .UseHeaderRow = True
                                                         }
x_config.UseColumnDataType = True
x_config.ConfigureDataTable = table_config
'ERROR: Value of type 'ExcelDataTableConfiguration' &_
'cannot be converted to 'Func(Of IExcelDataReader, ExcelDataTableConfiguration)'.

basis_data = reader.AsDataSet(x_config)

What am I doing wrong here?

Upvotes: 0

Views: 2740

Answers (1)

Ashish Emmanuel
Ashish Emmanuel

Reputation: 728

Change your ConfigureDataTable to this.

x_config.ConfigureDataTable = Function(tableReader) New ExcelDataTableConfiguration() With {
     .UseHeaderRow = True
    }

Upvotes: 2

Related Questions