Why do I get this xlswrite error?

Question

Jonathan Babitsch 2020-6-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/557152-why-do-i-get-this-xlswrite-error

评论： Walter Roberson 2020-6-30

采纳的回答： Walter Roberson

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2020-6-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/557152-why-do-i-get-this-xlswrite-error#answer_458947

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 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 2020-6-30

在 MATLAB Online 中打开

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()

请先登录，再进行评论。