deleteColumns

Jump to bottom Edit New page

Julian Halliwell edited this page Sep 20, 2021 · 5 revisions

Deletes the data in multiple columns (without deleting the columns).

deleteColumns( workbook, range )

Required arguments

workbook spreadsheet object
range string: a comma-delimited list of ranges.Each value can be either a single number or a range of numbers with a hyphen, e.g. "1,2-5"

Chainable? Yes.

Example

data = QueryNew( "First,Last","VarChar,VarChar",[ [ "Susi","Sorglos" ],[ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.deleteColumns( workbook,"1-2" );