Variable Range on SpreadsheetWrite prodecure

Question

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 Answer

Your Answer

aptech · Answer 1

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.

link

aptech

1,773

aptech · Answer 2

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.

link

aptech

1,773

Variable Range on SpreadsheetWrite prodecure

1 Answer

Your Answer

1 Answer

You must login to post answers.

Have a Specific Question?

Need Support?