Xml properties and server

Mon, 26 Jan 2026 18:19:17 GMT

If I use this function ActiveDocument.GetSheetObject( "CH01" ).WriteXmlPropertiesFile "C:\MychartProp.xml"

with a file that is published from server, the path to export is a path of server.

How can I export the xml properties file on client?

Thanks

Xml properties and server

raajeshn — Tue, 19 Jul 2011 10:41:33 GMT

Hi All,

I am also facing a similar problem. WriteXMLPropertiesFile Function doesnt seem to work for me. The below statement executes without any error, but does not provide any output files.

oQVObject.WriteXmlPropertiesFile "D:\TEST.xml"

oQVObject is a declared SheetObject. I am able to get values like Caption, Object Id, etc from this object. However, WriteXmlPropertiesFile doesnt seem to work.

Appreciate your help.

Thanks & Regards,

Raajesh N

Xml properties and server

raajeshn — Thu, 21 Jul 2011 15:12:28 GMT

Hi All,

Found a way to resolve this issue. Here is a copy of the script used by me.

Sub getQlikViewObjectXML(strFileName As String, strFolderPath As String)

    Dim oQVApp As QlikView.Application
    Dim oQVDoc As QlikView.Document
    Dim oQVSheet As QlikView.Sheet
    Dim oQVSheetObject As QlikView.SheetObject

    Dim lSheet As Long
    Dim lSheetObject As Long
    Dim strXMLFileName As String

    Set oQVApp = New QlikView.Application

    Set oQVDoc = oQVApp.OpenDocEx(strFileName, 1, False)

    For lSheet = 0 To oQVDoc.NoOfSheets - 1
        Set oQVSheet = oQVDoc.Sheets(lSheet)
        oQVDoc.ExportSheetLayoutFile ("C:\Temp\" & Mid(oQVSheet.GetProperties.SheetId, 10) & ".xml"), oQVSheet.GetProperties.SheetId
        For lSheetObject = 0 To oQVSheet.NoOfSheetObjects - 1
            oQVSheet.GetSheetObjects(lSheetObject).WriteXmlPropertiesFile (strFolderPath & Mid(oQVSheet.SheetObjects(lSheetObject).GetObjectId, 10) & ".xml")
        Next lSheetObject
    Next lSheet

    oQVDoc.CloseDoc

    oQVApp.Quit

    Set oQVSheetObject = Nothing
    Set oQVSheet = Nothing
    Set oQVDoc = Nothing
    Set oQVApp = Nothing

End Sub

This statment seems to work

oQVSheet.GetSheetObjects(lSheetObject).WriteXmlPropertiesFile (strFolderPath & Mid(oQVSheet.SheetObjects(lSheetObject).GetObjectId, 10) & ".xml")

However, if I declare a SheetObject (like the one below) and if I use WriteXMLPropertiesFile - then the desired output is not available.

Set oQVSheetObject = oQVSheet.GetSheetObjects(1)

oQVSheetObject.WriteXmlPropertiesFile ("C:\Temp\SheetObject.xml")

Experts can correct me, if am wrong.

Regards,

Raajesh N

topic Xml properties and server in QlikView

Xml properties and server

Xml properties and server

Xml properties and server