Fable bindings for the python xlsx reader/writer openpyxl.
Based on openpyxl version
3.1.2
.
<PackageReference Include="Fable.Openpyxl" Version="0.1.0" />
#r "nuget: Fable.Openpyxl, 0.1.0"
Fable.Openpyxl follows openpyxl syntax as close as possible. Most documentation from openpyxl can be used for Fable.Openpyxl together with built in F# intellisense.
Checkout the tests for implemented functions.
// minimal read
open Fable.Openpyxl
let path_to_file = @"tests/TestFiles/MinimalTest.xlsx"
let wb = openpyxl.load_workbook(path_to_file)
let ws = wb.active
let cell = ws.cell(row = 1, column = 1)
printfn "%A" (cell.value = "A1") // true
dotnet tool restore
py -m venv .venv
, creates python virtual environment..\.venv\Scripts\python.exe -m pip install -r requirements.txt
, install local python dependencies
- Install new local dependencies with
.\.venv\Scripts\pip.exe install <PACKAGE_NAME>
- Freeze local dependencies with
.\.venv\Scripts\python.exe -m pip freeze > requirements.txt
.