Variable Range on SpreadsheetWrite prodecure

User ForumVariable Range on SpreadsheetWrite prodecure
tassus asked 3 years ago

How can I set to SpreadsheetWrite(data, file, range, sheet) the range to depend on the dimension of the data, because in some cases the range, it is not constant and known a priori.

Thanks,

T.

1 Answers
aptech Staff answered 3 years ago

If you only put in a starting cell, the function will write all of the data automatically. For example:

x = rndn(10, 3);
ret = spreadSheetWrite(x, "myfile.xlsx", "A1", 1);

will write your matrix x from A1:C10.