Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
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...
Solved! Go to 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 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
Thanks Stuart! A newbie mistake...appreciate the help.
No problem.
Stuart
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?
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