topic Export QV to static html page in QlikView

Export QV to static html page

Sat, 02 Jan 2010 19:10:11 GMT

Hello,

I want to export a table to a html file and upload it to a ftp server. Only simple static data. You all can use this code because it links to a website.

The object works fine but there is no export. The bold lettercode is the code I've added to export the table (i've found this code on the Qlikview forum.

LOAD [December 20, 2009],
[December 20, 20091],
[December 20, 20092]
FROM
[http://soccernet.espn.go.com/stats/topscorers?league=esp.1&year=2009&cc=5739]
(html, codepage is 1252, embedded labels, table is @2, filters(
Remove(Row, Pos(Top, 2)),
Remove(Col, Pos(Top, 1)),
Remove(Col, Pos(Top, 4)),
Remove(Col, Pos(Top, 4))
));

set cs = ActiveDocument.GetSheetObject("TB01")
cs.ExportHtml "C:\test.html"

Can anyone help me with this issue?

Export QV to static html page

Sat, 02 Jan 2010 20:34:24 GMT

Tried your code and I don't know why but it doesn't seem to work with a tablebox.
It does however work if you use a straight table instead.

/Fredrik

Export QV to static html page

Sat, 02 Jan 2010 21:44:44 GMT

What do you mean with a straight table? Can't get it working.

Export QV to static html page

Sun, 03 Jan 2010 19:36:37 GMT

Well, what I've done now is select the table, then press right mouse button en select export. Then I select csv so now it works fine. Shame that it can not be done automaticly!

Is there a posibility to export it without the first row (which contains the fieldnames)?

thx in advanced!

Export QV to static html page

Sun, 03 Jan 2010 21:29:07 GMT

I've fixed it. Made an action on leaving the worksheet. Action-> export to csv and now it works automaticly.