addColumn

Adds a column or column data to a spreadsheet object.

addColumn( workbook, data, [startRow, startColumn, insert, delimiter, autosize ] );

Required arguments

• workbook spreadsheet object
• data string: a delimited list of cell values, one list item per row being added to the column. The default delimiter is a comma, but you can specify a different delimiter.

Optional arguments

• startRow numeric: the number of the row at which to start adding the column data. If insert=true all cells above the start row will be empty. If you omit this argument the column is inserted at the first row after the current last column.
• startColumn numeric: the number of the column in which to add the data.
• insert boolean, default=true: whether to insert the new data or replace existing values.
• delimiter string, default=",": the character separating column values in your data. If your values contain commas, use an alternative delimiter not contained in your data, e.g. |
• autosize boolean, default=false: whether to adjust the width of the column automatically to fit the data added.

##Examples

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
spreadsheet.addColumn( workbook,"a,b" );
// If your data contains commas, use a different delimiter
spreadsheet.addColumn( workbook=workbook,data="Champion, the wonder horse|Bagpuss",delimiter="|" );