Clear Filters
Clear Filters

writing string into excel

9 views (last 30 days)
Af
Af on 8 May 2020
Commented: Af on 12 May 2020
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 Comments
dpb
dpb on 8 May 2020
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 on 12 May 2020
Writetable does the trick. I do not have problems with that.

Sign in to comment.

Answers (1)

Harsha Priya Daggubati
Harsha Priya Daggubati on 11 May 2020
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 Comments
dpb
dpb on 11 May 2020
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 on 12 May 2020
Writetable does the trick. I do not have problems with that.

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!