topic Named areas Excel 2010 in QlikView

Named areas Excel 2010

Sat, 03 Mar 2012 16:36:19 GMT

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.

Named areas Excel 2010

Sun, 04 Mar 2012 11:19:41 GMT

hi all,

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

Named areas Excel 2010

deepakk — Sun, 04 Mar 2012 11:23:19 GMT

hi,

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

Deepak

Named areas Excel 2010

Sun, 04 Mar 2012 13:37:13 GMT

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

Named areas Excel 2010

Mon, 05 Mar 2012 22:49:59 GMT

Thank you Sajeevan,

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

Regards.