Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

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