Show/Hide Toolbars

 

The Excel - Create Task can create an Excel file from a CSV file or Variable.

 

Excel - Create > Source sub tab

TaskOfficeExcelCreate

 

Source

You can select File if the source for conversion is one or more files. You can also select Value/Variable if the source comes from a previous Task for example.

 

Format

You need to adjust format controls so they fit the format of the incoming file. The text qualifier is any surrounding character.

 

Excel - Create > File filter > Location sub tab

If you have selected File as source you are able to set the standard VisualCron File filter values.

 

Excel - Create > Columns sub tab

TaskOfficeExcelcreateColumns

 

In the columns tab you can override existing columns or set columns if they do not exist. It is possible to override name and also format of column. Default format is @ which is a string. You can see different format options when editing or adding a column.

 

For faster addition of new columns we recommend using Import headers. This lets you import any existing first row of the document (in the same format you specified in the Source tab).

 

Column header source

You can choose to use the existing columns in the file but then it is not possible to apply formatting. If you add columns manually and select "Use columns from definition above" you are able to control name, width, format and order.

 

Include column headers in destination file

You can deselect this option if you do not want to include any existing headers in file.

 

Add->Format

http://www.ozgrid.com/Excel/CustomFormats.htm

 

Excel - Create > Output sub tab

TaskOfficeExcelCreateOutput

 

Save to..

Depending on if you have selected File or Variable as source different options are available. If you have selected File all options are available and if you have selected Variable only Different folder and use file mask is available. When using Variable option the file mask must be the full name of the file.

 

Credential

If you are planning to save on a network location you can select a Credential.

 

Password protection

If you want to protect the file with Excel password authentication you can check this value and enter a password.

 

Sheet

The created Excel sheet name.