MATLAB: Saving results in excel without overwriting

excelimage processing

I have over 500 images in which i have to find the image attributes like centroid, area and intensity. I am almost successful but i dont know how to save the results in excel file without overwriting the previous results. Any help plz?

Best Answer

If you call xlswrite(), I believe it will overwrite the data (that is, replace existing cells with new data and add any new ones to blank cells), right?

If you want to replace the whole workbook (not overwrite it), delete it before calling xlswrite().

If you want to add additional data into new worksheets in the workbook, then specify a new worksheet name in the argument list of xlswrite(). Use xlsinfo() to get existing sheet names.

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: Saving to cell2mat without overwriting

x = B(:,2)
A=[];
 for i=3: length(B) 
y = B(:,i)
[fitresult, gof] = createFit(x, y)
A=[A cell2mat(struct2cell(gof))]
 end

Best Answer

Related Solutions

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

MATLAB: Saving to cell2mat without overwriting

Related Question