Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik-Developer
Creator
Creator

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

Hi,

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


Thanks in Advance.


5 Replies
devarasu07
Master II
Master II

Hi,

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

Untitled.png

woshua5550
Creator III
Creator III

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
Creator III
Creator III

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

Ctrl + M to open and set

1.png

txt file will be saved at same path with qvw file

shane_spencer
Specialist
Specialist

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?