MATLAB: How to save data in excel 2010 by Matlab

export to excelsave data

When I save data by syntax: xlswrite (….), i just receive a file data of Microsoft Excel 97. How I can save file in new Excel version?

Best Answer

http://www.mathworks.com/help/matlab/ref/xlswrite.html#btmdr27-3

"To create a file compatible with Excel 97-2003 software, specify an extension of .xls. To create files in Excel 2007 formats, specify an extension of .xlsx, .xlsb, or .xlsm. If you do not specify an extension, xlswrite uses the default, .xls."

Related Solutions

MATLAB: How to save a workbook compatible with older version of Microsoft Excel using ACTXSERVER in MATLAB 7.4 (R2007a)

You can save a file in a format compatible with older versions of Microsoft Excel by using the SAVEAS method of Workbooks and specifying an input argument as in the example below:

file = 'C:\myfilename.xls';
xlswrite(file, rand(5)); 
myApp = actxserver('Excel.Application');
myApp.visible = 1;
workbook = myApp.Workbooks.Open(file);
workbook.SaveAs('C:\myfilename2.xls',43);
%Saves the file in a format compatible with MS Excel 95 and 97
myApp.Quit;

MATLAB: Is there a way to use XLSWRITE to create a backward compatible Excel file

The file extension you provide as part of filename argument to XLSWRITE determines the Excel format that xlswrite uses for the new file. An extension of .xls creates a worksheet compatible with Excel 97-2003 software. Use extensions .xlsx, .xlsb, or .xlsm to create worksheets in Excel 2007 file formats.

For example, to create a .xls file compatible with Microsoft Excel 97-2003, the following XLSWRITE call may be used:

xlswrite('foo.xls',A);

On the other hand, to create a .xlsx file for use with Microsoft Excel 2007, the following may be uased:

xlswrite('foo.xlsx',A);

If you are using Microsoft Excel 2010, you can do the same starting with MATLAB R2010b (7.11).

Best Answer

Related Solutions

MATLAB: How to save a workbook compatible with older version of Microsoft Excel using ACTXSERVER in MATLAB 7.4 (R2007a)

MATLAB: Is there a way to use XLSWRITE to create a backward compatible Excel file

Related Question