error in writing to excel sheet

2012 2 21
2 个回答
12 次查看（30 天）

0 个投票

1.0e+005 *
Columns 1 through 2
0.000001380000000 0.000001380000000
0.000001380000000 0.000001380000000
0.000001380000000 0.000001380000000
0.000001380000000 0
0.000001380000000 0.000001380000000
0.000001380000000 0
0.000001380000000 0.000001380000000
0.000001380000000 0
0.000370000000000 2.845820000000000
0.000140000000000 0
0.000490000000000 1.601870000000000
0.000050000000000 0
0.000520000000000 2.096420000000000
0.000090000000000 0
0.000310000000000 0.457810000000000
I have these values from an outpur,noe if i write these data to excel sheeet,these valuee are not writing ,please help

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

回答（2 个）

Adnan
Adnan 2012-2-21

0 个投票

Hi,
If you have those numbers saved as zeros in your excel sheet, please change the format of the cells in that sheet, i.e. change the number of decimals.
Andrei Bobrov
Andrei Bobrov 2012-2-21

0 个投票

A=1e5*[0.000001380000000 0.000001380000000
0.000001380000000 0.000001380000000
0.000001380000000 0
0.000001380000000 0.000001380000000
0.000001380000000 0
0.000001380000000 0.000001380000000
0.000001380000000 0
0.000370000000000 2.845820000000000
0.000140000000000 0
0.000490000000000 1.601870000000000
0.000050000000000 0
0.000520000000000 2.096420000000000
0.000090000000000 0
0.000310000000000 0.457810000000000];
xlswrite('yourfile.xlsx',A)

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

提问:

kash
kash
2012-2-21

Community Treasure Hunt

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

Start Hunting!

Translated by