How can we export sheet object content to .text file(notepad)

[Qlik-Developer]

Hi,

Does anyone knows if it is possible to export text object content to a text file.

Thanks in Advance.

[devarasu07]

Hi,

Right click your sheet object -->click on properties -> export and save as .txt file

[woshua5550]

check this simple macro, it will create a txt file at same path with qvw

Sub ExportToNotepad

Set obj = ActiveDocument.GetSheetObject("TX01")

Set objpro = obj.GetProperties

Set docpro = ActiveDocument.GetProperties

Set fso = CreateObject("Scripting.FileSystemObject")

Set f1 = fso.CreateTextFile(docpro.MyWorkingDirectory & "\TX01.txt", True)

f1.WriteLine(objpro.Layout.Text.v)

f1.Close

End Sub

also find my example attached

[woshua5550]

Hi , before you run the macro , plz ensure you have allowed system access for it

Ctrl + M to open and set

txt file will be saved at same path with qvw file

[shane_spencer]

I tried using this but it exports the code behind the text box (i.e. field names and calculation) not what is on screen. Is there an alterative?

[shane_spencer]

Actually found another thread:

https://community.qlik.com/t5/QlikView-Scripting/Exporting-a-text-object-to-HTML-file-using-macro/td...