CSVData Property

Returns or sets spreadsheet data as a comma-delimited list. Read/write String.

expression   Required. An expression that returns a Spreadsheet object.

Example

This example sets the values for cells A1:G1.

Spreadsheet1.CSVData = "1,1,2,3,5,8,13"