Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to import a locally saved .htm into Qlikview? Need urgent help.
This looks like an Excel file saved as HTML. Could you not get the original Excel file? The Excel HTML export is designed to facilitate round-tripping (to HTML and back to Excel), and is not very easy to machine read for data extraction. You could also try loading it as XML (if it is well formed) - this gives you more control over what you read.
Within the script-editor click on the button table below the script-window and use the wizard to load your htm-file.
- Marcus
Thank you Marcus for the reply.
I tried to do that but the data is not in structured tabular format so its not being recognized by Qlikview. Below is the sample of xml file.
<html>
<head>
<style>
.a12{border:1pt None Black;background-color:White;background-repeat:Repeat;padding-left:0pt;padding-top:0pt;padding-right:0pt;padding-bottom:0pt;border-collapse:collapse}.a23{border:1pt None Black;border-bottom:2pt Solid Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:900;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a24{border:1pt None Black;border-bottom:2pt Solid Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:900;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a25{border:1pt None Black;border-bottom:2pt Solid Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:900;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a26{border:1pt None Black;border-bottom:2pt Solid Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:900;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a27{border:1pt None Black;border-bottom:2pt Solid Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:900;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a28{border:1pt None Black;border-bottom:2pt Solid Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:900;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a29{border:1pt None Black;border-bottom:2pt Solid Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:900;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a30{border:1pt None Black;border-bottom:2pt Solid Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:900;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a41{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:Normal;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a42{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:Normal;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a43{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:Normal;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a44{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:Normal;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a45{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:Normal;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a46{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:Normal;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a47{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:Normal;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a48{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:Normal;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word}.a11{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:11pt;font-weight:900;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;word-wrap:break-word;overflow:hidden;WIDTH:237.00mm;HEIGHT:10.67mm}.a3{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:0pt;padding-top:0pt;padding-right:0pt;padding-bottom:0pt;WIDTH:100%}.a5{border:1pt None Black;background-color:#fdbb30;background-repeat:Repeat;padding-left:0pt;padding-top:0pt;padding-right:0pt;padding-bottom:0pt;WIDTH:269.88mm}.a10{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:0pt;padding-top:0pt;padding-right:0pt;padding-bottom:0pt;WIDTH:34.29mm;HEIGHT:11.43mm;overflow:hidden}.a8{border:1pt None Black;background-color:#fdbb30;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:18pt;font-weight:700;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Center;writing-mode:lr-tb;vertical-align:Middle;color:Black;}.a50{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:0pt;padding-top:0pt;padding-right:0pt;padding-bottom:0pt;WIDTH:100%}.a53{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:8pt;font-weight:700;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Left;writing-mode:lr-tb;vertical-align:Top;color:Black;}.a54{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:8pt;font-weight:400;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Center;writing-mode:lr-tb;vertical-align:Top;color:Black;}.a52{border:1pt None Black;background-color:Transparent;background-repeat:Repeat;padding-left:2pt;padding-top:2pt;padding-right:2pt;padding-bottom:2pt;font-style:Normal;font-family:Times New Roman;font-size:8pt;font-weight:700;text-decoration:None;direction:LTR;unicode-bidi:Normal;text-align:Right;writing-mode:lr-tb;vertical-align:Top;color:Black;}.r1{HEIGHT:100%;WIDTH:100%}.r2{HEIGHT:100%;WIDTH:100%;overflow:hidden}.r3{HEIGHT:100%}.r4{border-style:none}.r5{border-left-style:none}.r6{border-right-style:none}.r7{border-top-style:none}.r8{border-bottom-style:none}.r10{border-collapse:collapse}.r9{border-collapse:collapse;table-layout:fixed}.r11{WIDTH:100%;overflow-x:hidden}.r12{position:absolute;display:none;background-color:white;border:1px solid black;}.r13{text-decoration:none;color:black;cursor:pointer;}
</style>
</head><body class="r0">
<TABLE CELLSPACING="0" CELLPADDING="0"><TR><TD ID="oReportCell"><DIV class="a3"><DIV class="a5"><TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0" COLS="5" LANG="en" class="r10" style="HEIGHT:11.43mm"><TR VALIGN="top"><TD style="HEIGHT:9.53mm" WIDTH="0"></TD><TD ROWSPAN="2" style="WIDTH:34.29mm"><DIV class="a10"><IMG class="r1" SRC="./RPT23_.Images.1.gif"/></DIV></TD><TD style="WIDTH:0.63mm"></TD><TD style="WIDTH:231.78mm"><TABLE CELLSPACING="0" CELLPADDING="0" LANG="en"><TR><TD style="WIDTH:231.78mm;word-wrap:break-word;HEIGHT:9.53mm;" class="a8">Daily_Backup_Reports_MILBACK02_v2010</TD></TR></TABLE></TD><TD style="WIDTH:3.18mm"></TD></TR><TR><TD style="HEIGHT:1.91mm" WIDTH="0"></TD><TD COLSPAN="3"></TD></TR><TR VALIGN="top"><TD style="HEIGHT:1.27mm" WIDTH="0"></TD><TD COLSPAN="4"><v:group coordsize="100,100" coordorigin="0,0" style="WIDTH:269.88mm;HEIGHT:1.27mm"><v:line from="0,100" to="100,0" strokecolor="#ffffff" strokeWeight="3pt"><v:stroke dashstyle="solid"/></v:line></v:group></TD></TR></TABLE></DIV></DIV><DIV><TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0" COLS="2" LANG="en" class="r10"><TR><TD style="HEIGHT:0.32mm;WIDTH:237.00mm"></TD><TD style="WIDTH:38.00mm"></TD></TR><TR VALIGN="top"><TD COLSPAN="2"><TABLE CELLSPACING="0" CELLPADDING="0" LANG="en" class="a12" COLS="8"><TR><TD HEIGHT="0" style="WIDTH:50.00mm"></TD><TD HEIGHT="0" style="WIDTH:50.00mm"></TD><TD HEIGHT="0" style="WIDTH:25.00mm"></TD><TD HEIGHT="0" style="WIDTH:25.00mm"></TD><TD HEIGHT="0" style="WIDTH:25.00mm"></TD><TD HEIGHT="0" style="WIDTH:25.00mm"></TD><TD HEIGHT="0" style="WIDTH:25.00mm"></TD><TD HEIGHT="0" style="WIDTH:50.00mm"></TD></TR><TR style="HEIGHT:5.33mm"><TD class="a23"><DIV class="r11">Job Name</DIV></TD><TD class="a24"><DIV class="r11">Server</DIV></TD><TD class="a25"><DIV class="r11">Job Type</DIV></TD><TD class="a26"><DIV class="r11">Job Status</DIV></TD><TD class="a27"><DIV class="r11">Job Start Time</DIV></TD><TD class="a28"><DIV class="r11">Job End Time</DIV></TD><TD class="a29"><DIV class="r11">Status</DIV></TD><TD class="a30"><DIV class="r11">Resource Name</DIV></TD></TR><TR><TD style="HEIGHT:5.33mm" class="a41"><DIV class="r11">Daily_Backup_Reports_v2010</DIV></TD><TD class="a42"> </TD><TD class="a43"><DIV class="r11">Report</DIV></TD><TD class="a44"><DIV class="r11">0</DIV></TD><TD class="a45"><DIV class="r11">7/27/2016 7:00:05 AM</DIV></TD><TD class="a46"><DIV class="r11">7/27/2016 7:00:05 AM</DIV></TD><TD class="a47"><DIV class="r11">Running</DIV></TD>
Have you chosen html as file-format for this file?
- Marcus
This looks like an Excel file saved as HTML. Could you not get the original Excel file? The Excel HTML export is designed to facilitate round-tripping (to HTML and back to Excel), and is not very easy to machine read for data extraction. You could also try loading it as XML (if it is well formed) - this gives you more control over what you read.