writing into excel sheets while keeping the leading zeros

4 次查看（过去 30 天）
SSG_newbiecoder
SSG_newbiecoder 2018-3-14
评论： SSG_newbiecoder 2018-3-14
Hello, is there any way to keep the leading zeros in my number while saving to excel sheet as a csv file? I should be getting 000 001 010 011 etc but in the excel sheet it is 0 1 10 11. How can I solve this?

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

采纳的回答

Pawel Jastrzebski
Pawel Jastrzebski 2018-3-14
编辑：Pawel Jastrzebski 2018-3-14
Following the:
https://uk.mathworks.com/matlabcentral/answers/93656-why-is-the-leading-zero-dropped-when-i-write-a-string-of-numbers-to-excel
you could use a similar method:
val1 = randi(1000,[20 1]);
val2 = rand(20,1);
val = val1.*val2
valWithZeros = num2str(val,'%09.3f')
valWithZeros = cellstr(valWithZeros)
for i=1:length(valWithZeros)
valWithZeros{i} = strjoin({'''',valWithZeros{i}});
end
xlswrite('file.xlsx',valWithZeros)
Or pre-format your sheet and then copy the data to it from Matlab. If you need to repeat this action over many batches of data, make sure you first make a copy of the pre-formatted sheet and then overwrite it with Matlab:
Pre-formatted sheet:
The Matlab code:
val1 = randi(1000,[20 1]);
val2 = rand(20,1);
val = val1.*val2
xlswrite('file.xlsx',val,'Sheet2','B2:B21')
Output:

更多回答（0 个）

类别

在 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