addColumn

Adds a column or column data to a spreadsheet object.

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 columns automatically to fit the data added.