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 OR array: Either a delimited list of cell values or an array of values. The default list 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 passed as a list. If your values contain commas, use an alternative delimiter not contained in your data, e.g. |, or preferably pass the data as an array.
• autosize boolean default=false: whether to adjust the column width 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="|" );