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

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

Qlik-Developer — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Thanks in Advance.

devarasu07 — Thu, 23 Nov 2017 10:46:22 GMT

Hi,

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

woshua5550 — Fri, 24 Nov 2017 03:35:18 GMT

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 — Fri, 24 Nov 2017 06:16:45 GMT

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 — Thu, 08 Oct 2020 13:46:52 GMT

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 — Fri, 09 Oct 2020 08:50:05 GMT

Actually found another thread: