writing string into excel

7 次查看（过去 30 天）
Af
Af 2020-5-8
评论： Af 2020-5-12
I am trying to simply write cell string array to excel
xlswrite(ExclFl,cellstr("1.1234"),'A1:A1');
or
xlswrite(ExclFl,{'1.1234'},'A1:A1');
in excel the written string is shown as 11.234, I tried to change the format of the cell but no luck.
Another strange observation is that if I have a string like
xlswrite(ExclFl,{'0.1234'},'A1:A1');
then it is correctly shown in excel.
Any idea?
  4 个评论
显示 2更早的评论
dpb
dpb 2020-5-8
Same ML Release, Excel version, still Win7 though.
While didn't test on W10, I've never observed such on that system either, so agree must be something unique to your setup.
What happens if you use writetable instead of xlswrite?
Af
Af 2020-5-12
Writetable does the trick. I do not have problems with that.

请先登录，再进行评论。

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

回答（1 个）

Harsha Priya Daggubati
Hi,
I could not reproduce the same at my end too. I guess there might be a cache issue. Try using the following commands.
rehash toolbox
rehash toolboxcache
Hope this helps!
  4 个评论
显示 2更早的评论
dpb
dpb 2020-5-11
Same Q? as above...what if you use writetable instead? Would prove whether it is MATLAB/xlswrite that is the problem or a system/Excel issue. The above looks like locale settings issues may be in the way.
Af
Af 2020-5-12
Writetable does the trick. I do not have problems with that.

请先登录，再进行评论。

类别

在 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