Rows are returned as a sequence from the Data
element of the ExcelFile type.
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
|