ExcelProvider


ExcelProvider

This library is for the .NET platform implementing a Excel type provider.

The library can be installed from NuGet:
PM> Install-Package ExcelProvider

Example

This example demonstrates the use of the type provider:

alt text

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
// reference the type provider dll
#r "ExcelProvider.dll"
open FSharp.ExcelProvider


// Let the type provider do it's work
type DataTypesTest = ExcelFile<"DataTypes.xlsx">
let file = new DataTypesTest()
let row = file.Data |> Seq.head

Now we have strongly typed access to the Excel rows:

alt text

1: 
2: 
3: 
4: 
5: 
6: 
row.String
val it : string = "A"
row.Float
val it : float = 1.0
row.Boolean
val it : bool = true

Documentation

For more information see the Documentation pages:

Contributing and copyright

The project is hosted on GitHub where you can report issues, fork the project and submit pull requests. If you're adding new public API, please also consider adding samples that can be turned into a documentation. You might also want to read library design notes to understand how it works.

The library is available under Public Domain license, which allows modification and redistribution for both commercial and non-commercial purposes. For more information see the License file in the GitHub repository.

namespace Microsoft.FSharp
type DataTypesTest = obj

Full name: Index.DataTypesTest
val file : DataTypesTest

Full name: Index.file
val row : obj

Full name: Index.row
namespace Microsoft.FSharp.Data
module Seq

from Microsoft.FSharp.Collections
val head : source:seq<'T> -> 'T

Full name: Microsoft.FSharp.Collections.Seq.head
module String

from Microsoft.FSharp.Core
Fork me on GitHub