deleteRow - cfsimplicity/spreadsheet-cfml GitHub Wiki

Deletes data from a row, but not the row itself.

deleteRow( workbook, row )

Required arguments

• workbook spreadsheet object
• row numeric

Chainable? Yes.

Example

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