write data to excel for more than 26 (A-Z) columns

I am using xlswrite and wants to write data ranging from A column to ABC column,but when i specify the range A:ABC,i got an error,please help me what should i do.

range = 'A':'ABC'
xlswrite([filename],[my_ftn],sheet1,range)

waiting for someone's reply

Answer 1

[Image Analyst]

Don't specify the lower right cell, just the upper left, and it will put the whole thing in there:

xlswrite(fullFilename, hugeArray, 'My Results', 'A1');

Answer 2

[Guillaume]

Two things:

Your version of excel may be limited to 256 columns, i.e. you can only save range 'A:IV'.

You need to specify a row range as well, otherwise it's going to fill as many rows as excel can handle:

 xlswrite(filename, my_ftn, sprintf('A1:BZ%d', size(my_ftn, 1))); %replace BZ by the proper column or calculate it

[Muhammad Usman]

the maximum number of columns in MS Excel 2007 are upto XFD,so what i ll do in matlab now