MATLAB: Save data in an existing xls file but in new sheet

xlswrite sheet#

HI,

I would like to save (xlswrite) data in a excel file. If the files already exist, I would like to force saving the data in a new sheet that I don't really now its number.

Is this possible with matlab?

Thanks in advance!

Best Answer

Use xlsinfo :

[status, sheets] = xlsinfo(filename);
newSheetNumber   = numel(sheets) + 1;

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: Copy XLS Sheet

Yes, I'm sure it can be done with ActiveX. Look at my ExcelDemo: http://www.mathworks.com/matlabcentral/answers/18306-how-to-import-data-to-excel-through-matlab It shows you how to use ActiveX. I'm not exactly sure how to copy a sheet, but with my example of other Excel commands, and you looking up the proper method on the Microsoft Office Developer's web site (which you can do just as well as I can), you can do it. The Excel 2007 developer's web site is http://msdn.microsoft.com/en-us/library/bb242656%28office.12%29.aspx Look through that and eventually you'll find either the command to duplicate a sheet, or else you can just select a range (which my demo shows you how to do), and copy the data, then add new worksheet (again, in my demo), paste, and save the workbook (again, in my demo). Good luck.

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Copy XLS Sheet

Related Question