Why do I get this xlswrite error?
3 次查看(过去 30 天)
显示 更早的评论
Hey everybody,
quick question concerning the following problem:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/324457/image.png)
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 个评论
采纳的回答
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 个评论
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 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!