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

Selection specific sheet doesn't work #12

Closed dmitry-a-morozov closed 9 years ago

dmitry-a-morozov commented 9 years ago

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">
WallaceKelly commented 9 years ago

I found that adding an exclamation mark is a workaround:

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

sheet2

dmitry-a-morozov commented 9 years ago

Thanks. It works.