setCellValue

Sets the value for a cell. If the cell doesn't exist it will be created.

setCellValue( workbook, value, row, column )

Required arguments

• workbook spreadsheet object
• value any: value to set
• row numeric
• column numeric

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
spreadsheet.setCellValue( workbook, "test", 1, 1 );