MATLAB Answers

writetable command is not working

16 views (last 30 days)
Stelios Fanourakis
Stelios Fanourakis on 28 May 2019
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 Comments

Stephen Cobeldick
Stephen Cobeldick on 28 May 2019
@ Stelios Fanourakis: please upload the variable o in a .mat file by clicking the paperclip button.
Stelios Fanourakis
Stelios Fanourakis on 28 May 2019
Here is the o variable after is converted to table
Stelios Fanourakis
Stelios Fanourakis on 28 May 2019
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!

Sign in to comment.

Answers (0)

Sign in to answer this question.