MATLAB: Special xlswrite save

xlswrite

Before creating an excel sheet, can we save the excel file dependent on an option selected for convenience?

For example, I would like it to save the excel sheet as; if option 1 is selected, xlswrite('filename_' num2str(option1), parameter, 'A1');

or if option 2 is selected, xlswrite('filename_' num2str(option2),parameter,'A1');

Best Answer

outputfilename = sprintf('filename_%d', option);
xlswrite( outputfilename, parameter, 'A1')

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: Can you help me how to extract a matrix of image and put it in Excel. more precisely how individual color, R G B this matrix to extract and put it in excel

Try this:

% Extract the individual red, green, and blue color channels.
redChannel = rgbImage(:, :, 1);
greenChannel = rgbImage(:, :, 2);
blueChannel = rgbImage(:, :, 3);
% Write out to separate sheets in an Excel workbook.
xlswrite(filename, redChannel, 'Red', 'A1');
xlswrite(filename, greenChannel, 'Green', 'A1');
xlswrite(filename, blueChannel, 'Blue', 'A1');

Best Answer

Related Solutions

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

MATLAB: Can you help me how to extract a matrix of image and put it in Excel. more precisely how individual color, R G B this matrix to extract and put it in excel

Related Question