Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ganginenivarsha
New Contributor

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.


3 Replies
devarasu07
Honored Contributor II

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

Hi,

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

Untitled.png

Highlighted
woshua5550
Contributor III

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

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

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

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