error in writing to excel sheet
조회 수: 1 (최근 30일)
이전 댓글 표시
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
답변 (2개)
Adnan
2012년 2월 21일
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
Andrei Bobrov
2012년 2월 21일
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
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!