Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to import a locally saved .htm into Qlikview?

How to import a locally saved .htm into Qlikview? Need urgent help.

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

4 Replies
marcus_sommer

Within the script-editor click on the button table below the script-window and use the wizard to load your htm-file.

-  Marcus

Not applicable
Author

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>

marcus_sommer

Have you chosen html as file-format for this file?

- Marcus

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein