Something for the Wishlist: Named Ranges

20 views

Skip to first unread message

Thomas

unread,

Feb 24, 2012, 7:41:49 AM2/24/12

to Spreadsheet::ParseExcel

Hi,

Excel has a feature, that allows to declare a name for a range. It
would be great, if one could access those ranges via
Spreadsheet::ParseExcel.

The reason would be, that you don't have to use fixed cell addresses
any more. Using fixed cell addresses can break easily, because cells
can be selected and moved around. Ranges on the other hand, update
themselves to match the position, where the cells are moved to.

Another usage would be to declare special ranges for your perl module,
so that you can update the information, where certain data is stored
in the spreadsheet, in Excel itself. No need to edit your perl module
any more.

Would it be possible to implement such a feature?

Cheers,
tmueller

jmcnamara

unread,

Mar 1, 2012, 8:22:13 PM3/1/12

to spreadsheet...@googlegroups.com

On Friday, February 24, 2012 12:41:49 PM UTC, Thomas wrote:

Hi,

Excel has a feature, that allows to declare a name for a range. It
would be great, if one could access those ranges via
Spreadsheet::ParseExcel.

...

Would it be possible to implement such a feature?

Hi Thomas,

I would be possible but realistically it probably won't be added to the core ParseExcel.

It could be implemented in client code or a helper module though if someone was interested in doing it.