Why do I get this xlswrite error?

1 次查看（过去 30 天）
Jonathan Babitsch
Jonathan Babitsch 2020-6-30
评论： Walter Roberson 2020-6-30
Hey everybody,
quick question concerning the following problem:
I can't find my mistake here. Matlab keeps teeling me I have too many input arguements. In line 228 I want to write the Vector Kmittelpunkt to the Cells C5:E5 in excel.
In line 229 I only want to write one value named "angledeg" to the to Cell G5 in Excel.
Thanks a lot for your help in advance, I'm a beginner in Matlab and just don't see the problem.
Thanks a lot,
Johnny

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2020-6-30
Either remove the keyword 'sheet' or else before the last input add the keyword 'range'. You can use positional arguments but as soon as you use the first keyword argument you have to stop using positionals.
  2 个评论
Jonathan Babitsch
Jonathan Babitsch 2020-6-30
Now I get the error message:
Input data must be numerical, cell or logical array...
What can I do about this?
Thanks in advance Walter!!
Walter Roberson
Walter Roberson 2020-6-30
You cannot xlswrite() symbolic values. You would have to xlswrite() double() of the symbolic values.
The part of the symbolic value that appears on the screen is numeric and can be converted to double. If you have any unresolved symbolic variables and you want to write out formulas, then you need to do something like
C = arrayfun(@(formula) char(formula), Kmittelpunkt, 'uniform', 0);
and then C would be a cell array of character vectors that you could xlswrite(), provided that you are using MS Windows with Excel installed.
Note: these days we recommend using writetable() or writecell() or writematrix() instead of xlswrite()

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Standard File Formats 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by