I suspect your arguments are in the wrong order.
I don't have Mathcad 15 at hand, but prime 3.1 help says the format is:
WRITEEXCEL("file", M, [rows, [cols]], [“range”])
Arguments
- “file” is a string containing the filename or the full pathname and filename. You must include the XLS or XLSX file extension, for example, heat.xlsx. Non-absolute pathnames are relative to the current working directory.
- M is a matrix of scalars. If M contains units, functions, or embedded matrices, PTC Mathcad cannot write the file.
- rows or cols (optional) are either scalars specifying the first row or column of matrix M to write, or two-element vectors specifying the range of rows or columns (inclusive) of matrix M to write. If you omit this argument, WRITEEXCEL writes out every row and column of the matrix to the specified file.
- “range” (optional) is a string containing the cell range. If this argument is omitted, then READEXCEL reads all the data in "Sheet1" of the specified file and WRITEEXCEL writes all the data in the specified matrix to "Sheet1" of the specified file.You can specify range in one of the following forms:
- "Sheet1!A1:B3" specifying the worksheet name, the top left cell, and the bottom right cell. "Sheet1!A1" means cell A1 of Sheet1, and "Sheet1" means the entire worksheet.
- "[1]A1:B3" specifying the worksheet number, the top left cell, and the bottom right cell. "[1]A1" means cell A1 of Sheet1, and "[1]" means the entire worksheet.
- Both rows and cols are indices that start with 1. System variable ORIGIN has no effect on the behavior of the READEXCEL or WRITEEXCEL functions.
- You can only omit optional arguments from the last argument and back. For example, in WRITEEXCEL you cannot omit rows and specify cols. If you omit rows, the value of cols is used as rows.
To execute the function you must use it in an assignment, example:
a:=WRITEEXCEL("a.xlsx",M)
Success!
Luc
