清空筛选条件
清空筛选条件

Turning a lot of variables into a string

1 次查看（过去 30 天）
Steve
Steve 2013-5-17
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 个评论
显示 1更早的评论
Matt Kindig
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
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
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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by