[id] = xlsx.Create(id, filename$)
filename$
until you
call either xlsx.Save() or xlsx.SaveAs() on it.
Nil
for auto id selectionNil
as argument 1 (see above)xlsx.Create(1, "test.xlsx") For Local y = 1 To 100 For Local x = 1 to 30 xlsx.SetCellValue(1, x, y, "Cell " .. x .. "/" .. y) Next Next xlsx.Save(1) xlsx.Close(1)The code above will create a new XLSX document and add 30 columns and 100 rows to it. The document will be saved as
test.xlsx
.