How to export data from matlab to excel as a column

Hi,

I am able to export data to excel as a row. I'm not able to export it as a column. Could someone kindly help me.

Thanks, Santosh

Answer 1

[Image Analyst]

columnVector = yourCurrentRowVector';
xlswrite(excelFileName, columnVector);

[Image Analyst]

Try this. It works fine, just as expected.

workspace;
yourCurrentRowVector = randi(9, 1, 20);
columnVector = yourCurrentRowVector';
xlswrite('delete me.xlsx', columnVector);

You're doing something different. Is your array a cell array of strings or something other than a normal numerical matrix?

[Vighneswara Siva Santosh Kumar Kondeti]

Hi,

Thanks. Its working now. I didn't correct my syntax earlier. Sorry for the inconvenience.

Thanks, Santosh

[Image Analyst]

OK great. Can you mark the answer as "Accepted" then?