ExcelPackageF is a simple F# wrapper over the EPPlus library.
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.nuget
ExcelPackageF.Tests
ExcelPackageF
tools/NuGet
.gitignore
ExcelPackageF.nuspec
ExcelPackageF.sln
LICENSE.txt
README.md
build.bat
build.fsx

README.md

ExcelPackageF

Build status

ExcelPackageF is a simple F# wrapper over the EPPlus library.

Motivation

On Windows you can use COM to work with Excel but it is of no use if you do not have Excel installed or are using MacOS or Linux. The ExcelPackage library works without Excel and can be used with Mono.

Usage

The ExcelPackageF namespace contains the following methods

Excel.getWorksheets
Excel.getWorksheetByName
Excel.getWorksheetByIndex
Excel.getMaxRowNumber
Excel.getMaxColNumber
Excel.getContent
Excel.getColumn
Excel.getRow

For example, if you want to read the whole data from sheet number 1 from a file called test.xlsx

#!fsharp

let data = 
        "test.xlsx"
        |> Excel.getWorksheetByIndex 1
        |> Excel.getContent 

data 
    |> Seq.iter (fun x-> printfn "%s" x)