Writing to an Excel Spreadsheet

I keep getting this error:

The specified data range is invalid or too large to write to the specified file format. _ _ Try writing to an XLSX file and use Excel A1 notation f or the range argument, for example, ‘A1:D4’.

I only have 1000 rows and 30 columns of Data but it says I should try writing to an XLSX spreadsheet and not an XLS spreadsheet. How do I do this, Currently I'm using "XLSWRITE"?

[Rik]

What is the syntax you are using?

Answer 1

[Matt Brianik]

xlswrite('TESTTESTTEST',Compound_Identifier,'MDL Sheet','B1')

[Walter Roberson]

Try with 'TESTTESTTEST.xlsx'

[ayesha abbassi]

it works in my case.. :)

[Gaurav Kumar]

Thanks a lot. Worked for me as well.

[farzad]

why should we use this command ? and when ? what does it do ?

[Rik]

Have you read the documentation for this function?

[Jingrui Ge]

Thanks Walter, that totally works