WRITEEXCEL - MathCAD 15 - won't write file

[mlabree]

Hello all,

I'm working with the WRITEEXCEL function for the first time and seem unable to make even the most basic example work.  In the attached file, no file gets written and I am unclear why this would be.

Best regards...

[StuartBruff · Accepted solution]

mlabree wrote:

Hello all,

I'm working with the WRITEEXCEL function for the first time and seem unable to make even the most basic example work.  In the attached file, no file gets written and I am unclear why this would be.

Although you've written the WRITEEXCEL command correctly, Mathcad won't do anything with it until you evaluate it.  Either write Result:=WRITEEXCEL(...) or WRITEEXCEL(...)=; the former is usually preferable to displaying a large array.

Stuart

[mlabree]

Thanks Stuart!  A newbie mistake...appreciate the help.

[StuartBruff]

No problem.

Stuart

[astevenson-2]

That was helpful. However, I get an error that my vector must be unitless. Must the vector be unitless to use the WRITEEXCEL function? What is the best way to strip the units from a variable? Multiply the reciprocal of the units?

[StuartBruff]

Andy Stevenson wrote:

That was helpful. However, I get an error that my vector must be unitless. Must the vector be unitless to use the WRITEEXCEL function? What is the best way to strip the units from a variable? Multiply the reciprocal of the units?

Yes. 

... Or divide by the units