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

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

Answer 1

[Image Analyst]

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

For more on cell arrays, see the FAQ: http://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F