search

a-marenkov / gsheets

A Dart library for working with Google Sheets API.
Other
78 stars 31 forks source link

Sheets API feature request: add named-ranges to read/write cells (with examples) #56

Open SDCode1 opened 2 years ago

SDCode1 commented 2 years ago

(Thank you for this sheets API, I am currently using it, and it's very helpful).

Is it possible to use named-ranges with this API? (Related to this 1st issue. I am following up now.)

Your previous comment:

In gsheets 0.3.2 A1Ref class was added might be useful for such cases

Originally posted by @a-marenkov in https://github.com/a-marenkov/gsheets/issues/52#issuecomment-907704555

My response: Thank you for the response, but A1Ref is different from named ranges. See explanation below:

Here is an example of named-range:

Google Sheets, and Excel, allow referencing any cell using an alias (AKA named-range). For example, we can assign cell A1 another name, for example A1 = 'my_A1_NamedRange' (or any other name).

1st example: Summing two cells using A1Notation: =A1+B1 or summing two cells using named-range as follow: =my_A1_NamedRange+B1

2nd example When using gsheets API, instead of using: sheet.cells.cell(column: 1, row: 1) we could use the named-range instead: sheet.cells.cell('my_A1_NamedRange') //this line of code won't work, but just to give you an example.

I hope this clarifies my request of adding named-range into your sheets API.

Link to Google Sheets named-range

a-marenkov commented 2 years ago

Hi @SDCode1

I got what you mean. I think i saw something about it in docs, so that might be possible. I'm not sure.

Unfortunately, i don't have enough time to look into it and support it.

If you are ready to contribute PRs are welcome.

I might be able to find the time in the future. I'll keep this issue open, so i can return to it later.

Thanks for the idea! And sorry that i cannot look int it right now.

SDCode1 commented 2 years ago

Thank you for the reply.

I would love to help with this, I just don't know where to start to provide my contribution, I am new to Dart/Flutter, and new to GitHub. But I have good knowledge about spreadsheets, App Script, and VBA.

If I want to contribute with gsheets, where should I start?

a-marenkov commented 2 years ago

Thank you for the reply.

I would love to help with this, I just don't know where to start to provide my contribution, I am new to Dart/Flutter, and new to GitHub. But I have good knowledge about spreadsheets, App Script, and VBA.

If I want to contribute with gsheets, where should I start?

Hi @SDCode1

Sorry, for delay with reply.

You can fork gsheets, support new features and once they ready open PR.