search

fsprojects / ExcelProvider

This library is for the .NET platform implementing a Excel type provider.
http://fsprojects.github.io/ExcelProvider/
The Unlicense
141 stars 51 forks source link

Access to range defined by a Table Name #32

Open RolandTLH opened 7 years ago

RolandTLH commented 7 years ago

Hi,

thank you for the library. It's very useful. I'm using a lot of Structured References (also called "Table Name") in my Excel Sheets for different reasons.

In VBA, I can access these ranges by its name like any range. For example, a table défined by the range "A1:B5" named "MyRange" can be accessed both ways : range("A1:B5") or range("MyRange").

It's interesting when you have different tables in the same sheets and when their ranges are not know a priori.

Is it possible to do it the same way through the "range" attribute of your method ?

thanks a lot.

Regards

TheSchemm commented 4 years ago

I came here to see if this issue existed. I am working on a project now that would benefit a lot from this.