ExcelProvider


Accessing Rows

Rows are returned as a sequence from the Data element of the ExcelFile type.

Example

alt text

This example demonstrates loading the second row (with index 1) into the variable test:

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

// Let the type provider do it's work
type MultipleSheetsSecond = ExcelFile<"MultipleSheets.xlsx", "B">
let file = new MultipleSheetsSecond()
let rows = file.Data |> Seq.toArray
let test = rows.[1]

And the variable test has the following value:

No value has been returned
Fork me on GitHub