How to upload words into a spreadsheet and then to a structure?

Question

Shane 2014-7-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/139972-how-to-upload-words-into-a-spreadsheet-and-then-to-a-structure

关闭： MATLAB Answer Bot 2021-8-20

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

此问题已关闭。

Answer 1

Image Analyst 2014-7-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/139972-how-to-upload-words-into-a-spreadsheet-and-then-to-a-structure#answer_143620

在 MATLAB Online 中打开

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');