Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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...
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;