You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a file with multiple sheets and they share the same structure. I would like to generate type from the first sheet and after that instantiate my type on each of the sheets. It can be done by adding optional sheetName parameter to instance constructor.
Expected behavior
type MonthlyData = FSharp.ExcelProvider.ExcelFile< @"c:\tmp\x.xlsx", "JAN"> let data =["JAN"; "FEB"; "MAR"] |> List.map (fun x -> MonthlyData(@"c:\tmp\x.xlsx", x)))
The text was updated successfully, but these errors were encountered:
Not sure why this wasn't closed, but the thing you're requesting here currently works exactly as you've written it: you can provide a 2nd argument to the constructor at runtime to designate the sheetname for your type provider.
Description
I have a file with multiple sheets and they share the same structure. I would like to generate type from the first sheet and after that instantiate my type on each of the sheets. It can be done by adding optional sheetName parameter to instance constructor.
Expected behavior
type MonthlyData = FSharp.ExcelProvider.ExcelFile< @"c:\tmp\x.xlsx", "JAN">
let data =["JAN"; "FEB"; "MAR"] |> List.map (fun x -> MonthlyData(@"c:\tmp\x.xlsx", x)))
The text was updated successfully, but these errors were encountered: