Turning a lot of variables into a string
1 次查看(过去 30 天)
显示 更早的评论
I have a list of some 500+ variable names in Excel. What I want to do is to turn them all into strings so I can use them in Matlab. Is there a way I can import the names in as a string without having to add ' ' around each entry?
3 个评论
Matt Kindig
2013-5-17
编辑:Matt Kindig
2013-5-17
Are you importing them using xlsread()? If so, the '' should not be necessary.
If you are just copy-pasting the names into Matlab, why not add a formula (in Excel) concatenating the '' to the variable name, using the CONCATENATE() function in Excel?
David Barry
2013-5-17
If you don't want to import automatically then you can just create an empty cell array and paste the excel data straight in.
data = cell(0); % Create empty cell array
回答(1 个)
Image Analyst
2013-5-17
[numbers, variableNameStrings, raw] = xlsread(fullFileName);
variableNameStrings should be a cell array with all your strings in it. See the FAQ for an explanation of cell arrays: http://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F
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!