writetable command is not working

조회 수: 8 (최근 30일)
Stelios Fanourakis
Stelios Fanourakis 2019년 5월 28일
댓글: Stelios Fanourakis 2019년 5월 28일
Hi
I am using this command to export from Matlab to Excel
o = array2table(Pd)
writetable(o,'ManualVsAutomated.xls','Sheet',9,'Range','B2:B824')
I am not getting any error. Supposely it works, but it won't export anything to the specidfied sheet and column I have assigned.
The values I am trying to export are Double where I am converting them to table prior to exporting
Here is a sample of my data if that helps
1.69061699951815
1.68312189837353
1.68095380407105
1.67073607284844
1.6599464457171
1.64856723848689
1.63658043945657
  댓글 수: 3
Stelios Fanourakis
Stelios Fanourakis 2019년 5월 28일
Here is the o variable after is converted to table
Stelios Fanourakis
Stelios Fanourakis 2019년 5월 28일
I found the mistake.
Sheet 9 was displaced among the sheets in excel and Matlab couldn't trace as its name to fill the data. So, it took the last sheet which was Sheet8 and filled the data there, since sheet9 had been moved at the beggining of the sheet series. Weird!

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by