Info
此问题已关闭。 请重新打开它进行编辑或回答。
How to upload words into a spreadsheet and then to a structure?
1 次查看(过去 30 天)
显示 更早的评论
I'm making a plot of certain events. Each event has plot coordinates already in the structure. However, I want to label each event. I'm trying to transfer the names through a spreadsheet, but I keep getting the not a number (NaN) thing pop up. How do I save these names as an X-by-1 matrix within the structure? Thanks
0 个评论
回答(1 个)
Image Analyst
2014-7-4
I don't know what you mean by a "structure" within Excel. But to output a string to Excel it has to be inside a MATLAB cell, not just a bare string or else each character of the string will go into a new cell in Excel.
e.g. (untested)
myArray = rand(20,2);
cellArray = {'column 1', 'Column 2'} % First row is column headers.
% The following rows are the numbers.
for row = 1 : size(myArray, 1)
cellArray{row+1, 1} = myArray(row,1);
cellArray{row+1, 2} = myArray(row,2);
end
xlswrite(filename, cellArray , 'A1');
0 个评论
此问题已关闭。
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!