misterspeedy / FsExcel

An F# Excel spreadsheet generator
MIT License
142 stars 18 forks source link

Add support for named cells #33

Closed fatim closed 2 years ago

fatim commented 2 years ago

This PR implements #29

The changes in this PR are as follows:

To create worksheet scoped name use

Name "Username"

or

ScopedName ("Email", NameScope.Worksheet)

To create workbook scoped name use

ScopedName ("Email", NameScope.Workbook)
fatim commented 2 years ago

Not sure if I need to commit "CreateRegressionTestActuals.fsx" and "RegressionTests\Expected\NamedCells.xlsx". Git does not pickup "NamedCells.xlsx" as a new file because "*.xlsx" files are ignored in ".gitignore"

misterspeedy commented 2 years ago

Brilliant, thank you @fatim. I've merged the PR to main but not yet done a release as I need to tidy up the tutorial and the issue you mention above. Will do this ASAP.