Variable Range on SpreadsheetWrite prodecure

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



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

1,423

Your Answer


You must login to post answers.

Have a Specific Question?

Get a real answer from a real person

Need Support?

Get help from our friendly experts.

Try GAUSS for 30 days for FREE

See what GAUSS can do for your data

© Aptech Systems, Inc. All rights reserved.

Privacy Policy