Resources

Variable Range on SpreadsheetWrite prodecure

0

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.

Tags: asked September 5, 2013

1 Answer

0

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.

aptech
227