error in writing to excel sheet
Afficher commentaires plus anciens
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
Réponses (2)
Adnan
le 21 Fév 2012
0 votes
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
le 21 Fév 2012
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)
Catégories
En savoir plus sur Spreadsheets dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!