csv export

[RSH]

Hi,

I am trying to export all my channels to xls or csv file each time i process them... But the problem is, when the number of channels varies in the data portal,the stp file fails to generate the xls file...for variable number of files..

What is the solution for this??

[AndreasK]

If csv is O.K. you can just use Save as CSV or call

dim fileNamePath : fileNamePath = "C:\temp\EXAMPLE.csv"
Call DataFileSave( fileNamePath, "CSV" )

 for character separated file (tab and .)

Or call

dim fileNamePath : fileNamePath = "C:\temp\EXAMPLE.csv"
Call DataFileSave( "<decimalpoint>.</decimalpoint><delimiter>,</delimiter><filename>" & replace(fileNamePath, "&", "&amp;") & "</filename>", "CSV" )

 for comma separated file.

For a US Excel you need . and , to open automatically.

For German Excel you need , and ; to open automatically.