How to convert xlswrite to writematrix?

I have a code that uses xlswrite and works in R2016. When I run it in R2019a Matlab online, it gives an error on xlswrite and suggests to use writematrix instead. I followed the format of writematrix, however, there is still an error using writematrix. How do I convert xlswrite to writematrix? Thanks.

[dpb]

Not enough details...what's the xlswrite error, specifically, first, and attach the data as .mat file...or at least tell us what the content is.

If xlswrite really fails in R2019a and succeeds with the identical data on the same system with earlier release, I'd say that would qualify as a bug...just having introduced some new feature should not break earlier.

However, writematrix can only deal with homogeneous data altho one would hope the error message would suggest writecell instead if that were the issue...

All in all, just not enough info for even the crystal ball...

[Guillaume]

If you say you get an error always give us the full text of the error message (everything that is red).

Note that matlab online runs on linux, so writematrix and more so xlswrite are limited in what they can write to an excel file.

[dpb]

Ah...I was unaware of that tho makes sense...that in fact is likely the root cause indeed for xlswrite; still indeterminate for writematrix

Answer 1

[Jeremy Hughes]

XLSWRITE can write either a matrix (e.g. [ 1 2 4;5 7 8] or a cell {'a' 'b';'c' 'd'})

If your input is a cell, use WRITECELL.

[Jojo Blanza]

The input to the matrix are numbers (values). Does it mean that I should use writematrix? Also, Matlab Online suggests writematrix instead of xlswrite.

Thanks.

[Jeremy Hughes]

Based on the comment below:

writematrix(dataset,filename,sheet,xlRange)

should be:

writematrix(dataset,filename,'Sheet',sheet,'Range',xlRange)

Answer 2

[Jojo Blanza]

Appreciate your responses.

Here are the errors:

Error using writematrix (line 134)
Invalid parameter name: Indo_Sing_Wide_LOS-1

Error in A_DataGeneration (line 207)
        writematrix(dataset,filename,sheet,xlRange)

Apologies for forgeting to include the errors.

Thanks for your answers.

[dpb]

What if you use writematrix but to a text file? I'm betting odds are good that will work and if so it's related to the issue of is Excel actually supported for the platform you're trying to write to as Guillaume suggested.

But, it would still be agoodthing™ if we could see the actual form of the data you're trying to write; I wonder with the variable name dataset are you, by any chance, using a ML table or the old Statistics TB dataset class, are you??? But, if the latter, that variable name is aliasing the constructor for the class...

What does

whos dataset

return at command line?