Skip to content

Cannot refresh intellisense to changes in excel file #38

Open
@halcwb

Description

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

  • Windows 7
  • .NET 4

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions