topic Reading more tables from HTML in QlikView

Reading more tables from HTML

francisvandergr — Mon, 15 Aug 2011 09:52:14 GMT

I have an excel file. I can only read it good when i use the option HTML. Nor problem so far. I see 3 tables. I wanna load all tables. In future there are more tables, so i want to load always all tables. Is this possible in once. The structure of all tables is the same.

I included an excel file.

In the script i have at the moment this

[\\Website\sessions_15-08-2011.xls]

(html, codepage is 1252, embedded labels,Table is @1);

Re: Reading more tables from HTML

Thu, 18 Aug 2011 11:12:45 GMT

Hi,

Try like this in your editscript after loading the file in to the qlikview and do the changes like this.

for i =1 to 1000;

LOAD course_title,

start_date,

end_date,

name,

participant_type,

maximum_participants,

participants_entered,

remarks_admin

FROM

[sessions_15-08-2011.xls]

(html, codepage is 1252, embedded labels, table is @$(i));

Let me know it is working or not

Regards...

Re: Reading more tables from HTML

Thu, 18 Oct 2012 17:41:23 GMT

yo modifique un ejemplo para abrir muchos libros y muchas tablas.

espero te sirva

sub DoDir (Root)

for each Ext in 'html'

for each File in filelist (Root&'\*.' &Ext)

////===================================================================================================================================================

ODBC CONNECT32 TO [Excel Files;DBQ= $(File)];

tables:

SQLtables;

DISCONNECT;

////===================================================================================================================================================

FOR i = 0 to NoOfRows('tables')-1

LET sheetName =PurgeChar(PurgeChar(peek('TABLE_NAME', i, 'tables'),chr(39)),'$');

MONITOREO_EQUIPO:

LOAD

'$(File)' as MONEQPOCOM_NOMBRE_LIBRO,

num(@1, '0' ) as MONEQPOCOM_ORDEN,

@2 as MONEQPOCOM_HOSTNAME,

@3 as MONEQPOCOM_DIRECCION_IP

FROM

[$(File)]

(ooxml, no labels, table is [$(sheetName)], filters(

Remove(Row, RowCnd(CellValue, 8, StrCnd(null))),

Remove(Row, RowCnd(CellValue, 1, StrCnd(null)))

));

////===================================================================================================================================================

next File

next Ext

for each Dir in dirlist (Root&' \*' )

call DoDir (Dir)

next Dir

end sub

call DoDir ('D:\PROYECTOS\QLIKVIEW\MENSUALES\Matriz Monitoreo')

DROP Table tables;