How to place text in a single excel cell?

Question

Robert 2019-2-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/446313-how-to-place-text-in-a-single-excel-cell

评论： Robert 2019-2-21

I'm running a series of analyses and exporting information to an Excel file to make it easier to summary, do additional analyses, share with collaborators, etc, and I have run into an issue that is probably very simple (so my aplogies if I have missed an obvious solution).

When I export the data to excel, I would like to export text to multiple cells. For example, if I were adding the value "Connecticut" to five cells in a single columns. The goal is to produce something like this:

I am using something similar to the following:

label = 'Connecticut';
label = repmat(label,5,1);
xlswrite(fid,label,sheet1,'A1');

which produces this:

so the script is importing the individual values (characters) into individual cells, rather than the entire row. Is there a simple way to change this?

Thanks,

Robert

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2019-2-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/446313-how-to-place-text-in-a-single-excel-cell#answer_362140

在 MATLAB Online 中打开

label = repmat( {label}, 5, 1)

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2019-2-21

在 MATLAB Online 中打开

 T = 'hello';
 label = repmat({T}, 5, 1);
 
 %these next two can only work on MS Windows with Excel installed
 xlswrite('testxx.xlsx', label)
 xlswrite('testxc.csv', label)
 
 %these will work on any release since tables were introduced
 TT = array2table(label);
 writetable( TT, 'testtx.xlsx', 'writevariablenames', false)
 writetable( TT, 'testtc.csv', 'writevariablenames', false)

Robert 2019-2-21

Well, I feel sheepish.

I initially tried this approach, and it didnt work.

Then I ran your script, and it worked fine.

It took me a while to realize I had misspelled a variable, which meant the { } were being applied to a variable that was not used in the repmat command.

Thanks for your patience and your code, it's much appreciated.

Cheers

请先登录，再进行评论。