fsprojects / ExcelProvider

This library is for the .NET platform implementing a Excel type provider.
http://fsprojects.github.io/ExcelProvider/
The Unlicense
141 stars 51 forks source link

Cannot refresh intellisense to changes in excel file #38

Open halcwb opened 7 years ago

halcwb commented 7 years ago

Description

Intellisense for a fsx file shows error after changing column names in excel template file.

Repro steps

Create an Excel template file with columns A and B called test.xlsx. Reference the type provider dll in an fsx file. Create the types using the text.xlsx. Write some code using columns A and B

  1. Step A

Change column B to C in the excel file.

  1. Step B

Change the naming of column B to C in the fsx file. Intellisense shows and error for using column C. However, the code can be loaded to the fsi without problems. The only way to be able to correct the intellisense problem is by renaming the test.xlsx to for example test1.xlsx and use that file.

Expected behavior

Intellisense adjusts to the new column C.

Actual behavior

Intellisense keeps refering to column B.

Known workarounds

Renaming the template file and using that as type provider.

Related information