Reading more tables from HTML

[francisvandergr]

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);

[#2]

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...

[#3]

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    

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

  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;