MATLAB: How to use xlswrite to write in a numbered column in excel

xlswrite for numbered columns of excel sheet instead of alphabets.

actually i have a excel sheet with columns being numbered instead of A B C. i have to use xlswrite to write my matrix in 31 numbered column of excel sheet with row numbered 1. what to use in 'xRange' of xlswrite?plz guide me

Best Answer

You need something like

xlsrange(): http://www.mathworks.com/matlabcentral/fileexchange/41449-xlsrange

or ExcelCol : http://www.mathworks.com/matlabcentral/fileexchange/27182-excel-column-conversion

Related Solutions

MATLAB: XLSWRITE

name = inputdlg('Name excel file as: ','Name excel',1);

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;

Best Answer

Related Solutions

MATLAB: XLSWRITE

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

Related Question