setReadOnly

Jump to bottom Edit New page

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

Prevent a workbook from being edited without a password. Only works with binary (.xls) files

setReadOnly( workbook, password )

Required arguments

workbook spreadsheet object
password string

Chainable? Yes.

Example

data = QueryNew( "First,Last", "VarChar,VarChar", [ [ "Susi","Sorglos" ], [ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.setReadOnly( workbook, "secret" );
path = "C:/temp/test.xls";
spreadsheet.write( workbook, path );