Excel references and named ranges

[snth]

Hi,

Thank you for creating this. It's something that I've wanted for a long time. I'm looking forward to trying it out.

Just a quick question, is it possible to also work with Excel references and named ranges?

I would like to do things like:

FROM Table1 WHERE Name=Sheet1!A1

In order to avoid ambiguity this could be under a namespace like "xl", e.g.

FROM xl.Table1 WHERE Name=xl.Sheet1.A1

[RusselWebber]

Hi,

Glad you like the project!

Accessing ranges as tables would be a nice feature. For this to be feasible we'll need DuckDb.NET to support replacement scans
https://duckdb.org/docs/api/c/replacement_scans.html
I see there is an open issue for this
Giorgi/DuckDB.NET#239

I'm not sure about the utility of using Excel references in the WHERE clauses? How is this more useful than constructing the string using Excel string functions and passing in the query?