Using Named Ranges in Excel

wrathstone — Mon, 26 Jun 2017 15:58:32 GMT

I'm very interested in using an Excel document declared as a library in order to read and write directly to certain cells for the purpose of updating specific cells as well as populating datasets. So far I've found named ranges very useful in this regard, but I've run up against the problem that assigning a named range to the contents of a table causes it to not appear in the available datasets.

Is there any way in SAS to read from an Excel cell range that has been formatted as a table? As a named range or otherwise?

Also, if there's a way to read from an Excel file while it's still open that would be really cool. Despite there being a readonly option it seems the libname statement still requires a file lock.

Re: Using Named Ranges in Excel

tomrvincent — Mon, 14 Oct 2019 15:10:42 GMT

I read in the entire worksheet with getnames=n and then I can manipulate/test cells as I see fit.

topic Using Named Ranges in Excel in Microsoft Integration with SAS

Using Named Ranges in Excel

Re: Using Named Ranges in Excel