write string to excel using matlab and control the format

Question

My question is so simple~ code is :

name={'ab','ac','ad','ae'};
xlswrite('outex1',name);

what I get :

a b a c a d a e

but I want:

ab ac ad ae

I try many different way, but I still not get what I want. I am using 2013b version of matlab

lakshmen · Accepted Answer · 2014-07-10 22:56:11Z

2

name={'ab','ac','ad','ae'};
name = strjoin(name);
xlswrite('outex1',name);

Try this.

xlswrite in MATLAB in Mac has a issue. If you execute what you typed in Windows, it is working fine.

answered Jul 10, 2014 at 20:46

lakshmen

29.2k68 gold badges183 silver badges286 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

don't work, I got "a b blankcell a c blankcell a d blankcell a e" just separated by blank cell between two of them.

are you using Matlab in Mac?

OK， I will try, i believe this is OK!