Creating named cells

[sudipto80]

How can I create a named cell

Let's say I have a value 0.04 and I put it in B1 but that 0.04 is called "rate"
How do I pass in that information to Cell [] ? if at all

[misterspeedy]

Hi @sudipto80 - FsExcel doesn't support that right now but it would be a useful feature.

One thing to consider would be whether we support the naming of ranges - maybe not initially.

Naming individual cells should be relatively straightforward to add. Do you want to submit a PR or would you like me to have a go at it? I'm easy either way. It might take me a few days to get to it.

There are some contributor guidelines here: https://github.com/misterspeedy/FsExcel/blob/main/Contributing.md

[misterspeedy]

Looking at doing this now.

[misterspeedy]

Someone has pointed out that we need to consider the scope of names - worksheet or workbook. I'm guessing that most people, most of the time will want to create a worksheet-scoped name (or won't care), so to keep that use-case simple, I propose that we add the following "keywords":

Name name // Creates a worksheet-scoped name

type NameScope = | Worksheet | Workbook
ScopedName(name, scope) // Creates an explicitly-scoped name where scope Worksheet or Workbook

[fatim]

Hi Kit, this can be closed now ?