Skip to content
Julian Halliwell edited this page Sep 20, 2021 · 4 revisions

Deletes the data from a column (without deleting the column itself).

deleteColumn( workbook, column )

Required arguments

  • workbook spreadsheet object
  • column numeric

Chainable? Yes.

Example

data = QueryNew( "First,Last","VarChar,VarChar",[ [ "Susi","Sorglos" ],[ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadSheet.deleteColumn( workbook,1 );
Clone this wiki locally