How to xlswrite cell array with both strings and number?

1 次查看（过去 30 天）

显示更早的评论

Supreet Hegde 2015-7-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/231739-how-to-xlswrite-cell-array-with-both-strings-and-number

评论： Supreet Hegde 2015-7-31

采纳的回答： Azzi Abdelmalek

I have a cell array of the type A={'01:02:03'};

when I use the function: xlswrite('Output',A)

The excel sheet that I get has eliminated the first zero, it is reading the cell as a number and giving me output as '1:02:03'. How do I get the entire string without eliminating 0?

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

请先登录，再进行评论。

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

采纳的回答

Azzi Abdelmalek 2015-7-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/231739-how-to-xlswrite-cell-array-with-both-strings-and-number#answer_187681

编辑：Azzi Abdelmalek 2015-7-30

在 MATLAB Online 中打开

A={'''01:02:03'};

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

Azzi Abdelmalek 2015-7-31

在 MATLAB Online 中打开

s={'01:02:03';11; 20; '01:02:03';'01:02:03' ;11 ;10 }
idx=cellfun(@isstr,s)
s(idx)=strcat('''',s(idx))
xlswrite('fic.xlsx',s)

Supreet Hegde 2015-7-31

This works great! Thanks a lot!

请先登录，再进行评论。

更多回答（1 个）

Carl Agnew 2015-7-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/231739-how-to-xlswrite-cell-array-with-both-strings-and-number#answer_187704

Change the cell format in excel to "Text".

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

Supreet Hegde 2015-7-31

I have tried doing that. It didn't work.

请先登录，再进行评论。

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

类别

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