Problem with xlswrite. Need to write text and numbers. Need help!!
4 次查看(过去 30 天)
显示 更早的评论
Good day! I've developed a gui, that takes data from an excel spreadsheet and does certain calculatons to some of the data. I then need to write the answers from the GUI into certain cells in a new excel sheet. I also need the xlswrite to give the names to those values. What i've tried so far was something similar to this:
A=[1 2 3 4];
B='test';
xlswrite('test.xls',[A B]);
the problem with that is that it for some reason creates .csv file instead of .xls and every letter of the text is in a separate column. I also have no idea how to write specific elements to specific cells. I tried specifying the cells in xlswrite,but it did not work. Any ideas or suggestions? Thank you!
0 个评论
采纳的回答
F.
2012-7-13
You should use a cell array where each cell contains one value : a double, a string, ... but not an array !!
So try something like this:
A = { 1, 'Test' ; 2, 0 ; 3, 0 };
xlswrite( 'toto.xls', A )
After, look command : num2cell
1 个评论
Avery Krovetz
2017-6-2
This doesn't seem to work anymore. I copied your code into MATLAB and received the error:
Error using dlmwrite
The input cell array cannot be converted to a matrix.
Thoughts?
更多回答(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!