fsprojects/ExcelProvider

Selection specific sheet doesn't work

dmitry-a-morozov opened this issue · 2 comments

Hi,
Selecting specific sheet from *.xlsx file doesn't work.
image

When I access first spreadsheet in the same file it works

type Sheet1 = ExcelFile< @"..\FileStorage\test.xlsx", "Sheet1">
//or
//type Sheet = ExcelFile< @"..\FileStorage\test.xlsx">

I found that adding an exclamation mark is a workaround:

type Sheet = ExcelFile< @"c:\temp\Library2\test.xlsx", "Sheet2!" >

sheet2

Thanks. It works.