error in writing to excel sheet
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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
0 Kommentare
Antworten (2)
Adnan
am 21 Feb. 2012
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.
0 Kommentare
Andrei Bobrov
am 21 Feb. 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)
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!