How to write a vector to excel?

59 次查看（过去 30 天）

显示更早的评论

Khanh 2014-10-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/157374-how-to-write-a-vector-to-excel

评论： Khanh 2014-10-4

采纳的回答： Image Analyst

Hi,

I have an array like this: a=0:100:500

I want to write its each element to each cell of excel.

I know to do it the array has to become as a'=[0,100,200,300,400,500];

But how I can get the array a' which created by adding comma.

Any help would be greatly appreciated.

Thanks.

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

请先登录，再进行评论。

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

采纳的回答

Image Analyst 2014-10-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/157374-how-to-write-a-vector-to-excel#answer_153915

在 MATLAB Online 中打开

I don't understand the comma stuff you said, and don't know why you have an apostrophe like you want to transpose a or something. But to write a vector to Excel and have it look like what you showed, use:

xlswrite(fullFileName, a, 'D23');

2 个评论
显示无隐藏无

Khanh 2014-10-4

Thanks. You're right. I'm just a little bit silly.

Khanh 2014-10-4

Apostrophe a (a') is just a name I give to a new array. Sorry, I should name it correctly.

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 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