Script to generate CSV file

Last activity on June 20, 2025 - 08:52 52 Views 1 Reply Reports & Macros

Nicola Adas on June 19, 2025

Hi all,

Do you have an example script to generate a csv file instead of excel xls. I know that I need to use "createCsvOutputObject" funciton for the output object, but not sure what to use as a replacement for XLS row functions like "Begin Table"," TableCell" to add records. The "WriteReport() still applies for the csv file.

Many thanks,

Nicola

Bookmark

Notify Moderator

1 Reply

Klaus Bieg on June 20, 2025 - 07:45

Easiest way to create a CSV in my opinion is to generate it as txt output.

Create a report with output format "Txt"
Overwrite the file extension when creating the output object:

var oOut = Context.createOutputObject(Constants.OUTTEXT, "MyFile.csv")
var a_Rows = [];
a_Rows.push(["Field 1.1", "Field 1.2", "Field 1.3", "Field 1.4"])
a_Rows.push(["Field 2.1", "Field 2.2", "Field 2.3", "Field 2.4"])
for each(var row in a_Rows){
   oOut.OutputLn(row.join(";"),"Arial",12,Constants.C_BLACK,Constants.C_TRANSPARENT,Constants.FMT_LEFT,0);
}
   
oOut.WriteReport();

Best regards

Klaus

Attachments

Create CSV.arx

or register to reply.

Notify Moderator

Upcoming events

Tuesday, September 23, 2025 - 09:00

Meeting of ARIS User Group DACH
Tuesday, October 7, 2025 - 09:00

Meeting of the ARIS User Group 7.10.-8.10.2025

Meeting of ARIS User Group DACH

Meeting of the ARIS User Group 7.10.-8.10.2025