-
Export to a file-issues
Dear $all,
I would like to export list data into a file.
a) is there a (platform-independant) way to export to Excel?
b) I’d like to include a header line with my data.
With myList.$cols.$makelist($ref.$name) returns llHeader I get the the Column names, 1 list line per column. Is there a <b style=”font-family: inherit; font-size: inherit;”>simple command to transpose this list into a row, so I can use it as the header line? The following is very clumsy:
Do llHeader.$first()
While llHeader.$line
Do llHeader2.$addcols(llHeader.C1,kCharacter,kSimplechar,255)
Do llHeader2.[llHeader.C1].$assign(llHeader.C1)
Do llHeader.$next(llHeader.$line)
End WhileBut this did not work:
Do llHeader.$sendall(llHeader2.$addcols($ref.$name,kCharacter,kSimplechar,255))
c) when I export into a file using
Set print or export file name [lcPath]
Prepare for export to file Delimited (tabs)
Export data llHeader2
Export data ilDataList
End export
Close print or export filethe numerical values use a ‘.’ for the <em style=”font-family: inherit; font-size: inherit;”>decimal and a ‘,’ for the thousand separators – I need it the other way around. Is there a setting to correct this (My system is German localized, i.e. ‘,’ for the <em style=”font-family: inherit; font-size: inherit;”>decimal and a ‘.’ for the thousand separators)
Thanks in advance!
Uwe
Log in to reply.