Named areas Excel 2010

[#1]

Hello,

does anyone know how to import excel named areas in QV. It was working with .xls file and does not seem to work anymore with .xlsx or .xlsm files ?

Thanks in advance for your answers.

Regards.

[#2]

hi all,

Still no answer ... this should work according to reference manual (p200) but i am stuck at this time. Please help.

[deepakk]

hi,

its not clear. Can you give a detail of the problem.

Deepak

[#4 · Accepted solution]

Hi,

You can load the named areas. Try the below. The example below is for a named area as "Variable1". To get all such named variables add a table box with "TABLE_NAME" and "TABLE_TYPE". I think any TABLE_TYPE marked as "TABLE" is the named areas.

ODBC CONNECT TO [Excel Files;DBQ=c:\temp\Book3.xlsx];
tables:
SQLTABLES;
DISCONNECT;

SQL SELECT * FROM `C:\temp\Book3.xlsx`.Variable1;

Hope this solve your query.

Regards,

Sajeevan

[#5]

Thank you Sajeevan,

Your answer does the job. This workaround allows me to bypass my usual way to import named areas.

Regards.