Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to TXT without headers

Created a macro to export a SheetObject to txt/csv. I would like to export the object without headerrow. Any suggestions on how i could change the Macro to do so?

Current Macro looks like this:



Sub

set

sObject = ActiveDocument.GetSheetObject("CH67") SR39

sObject.Export

\\filename.txt",";"

End







Sub



2 Replies
hectorgarcia
Partner - Creator III
Partner - Creator III

i am also interested in this solution, many customers define flat files atructured with no headers...

Hector

Not applicable
Author

There is a very simple workaround: cut the headers from the file after the export. For example file data.txt like this :

Product,Region,Value
one,a,234
one,b,54
one,c,54
three,a,635
three,b,891


Have a batch file containing

type data.txt | find /V "Product,Region,Value" > noheader.txt


-Alex