MATLAB: How to delete a certain cell area in an Excel table using MATLAB 7.8 (R2009a)

MATLAB

I would like to delete the existing values in a certain cell area of an Excel table using MATLAB.

Best Answer

When XLSWRITE is used to write to cells in a spreadsheet, by default it overwrites the existing data in the cells. Thus deleting the existing values in a certain cell area can also be accomplished by writing empty cells.

The following example shows how to use the XLSWRITE command to write an empty cell to a cell area in order to clear the existing values:

xlswrite('test.xls', cell(29, 1), 'Table1', 'A3:A31');

Related Solutions

MATLAB: How to add a Header or a Footer to an EXCEL worksheet using MATLAB 7.7 (R2008b)

The ability to programmatically add the Header and Footer to an Excel worksheet can be implemented in MATLAB using the COM interface.

The ACTXSERVER command can be used to create a COM server running Microsoft Excel. You can then add the Header and Footer using the different methods for the workbook and then call XLSWRITE to write the data to the Excel worksheet as follows:

a = actxserver('Excel.Application');
a.Visible =1;
a.Workbooks.Add;
a.activeWorkbook.activesheet.PageSetup.LeftFooter = 'MyFooter';
a.activeWorkbook.activesheet.PageSetup.LeftHeader = 'MyHeader';
a.activeWorkbook.SaveAs('test.xlsx');
a.activeWorkbook.Close;
xlswrite('test.xlsx',[1 2 3]);

The following options can also be modified in a similar way:

a.activeWorkbook.activeWorksheet.PageSetup.CenterHeader 
a.activeWorkbook.activeWorksheet.PageSetup.RightHeader 
a.activeWorkbook.activeWorksheet.PageSetup.CenterFooter 
a.activeWorkbook.activeWorksheet.PageSetup.RightFooter

MATLAB: Write results in Excel under multiple If statements

You need to close every if statement:

for j = 1 : 2
    x = randn(10,1);
    for k=1:2
        y = randn(10,1);
        if j == 1 && k == 1
            xlswrite('Test.xls', [x y], 'Test1', 'b2');
        end
        if j == 1 && k == 2
            xlswrite('Test.xls', [x y], 'Test1', 'p2');
        end
        if j == 2 && k == 1
            xlswrite('Test.xls', [x y], 'Test1', 'b20');
        end
        if j == 2 && k == 2
            xlswrite('Test.xls', [x y], 'Test1', 'p20');
        end
    end
end

Best Answer

Related Solutions

MATLAB: How to add a Header or a Footer to an EXCEL worksheet using MATLAB 7.7 (R2008b)

MATLAB: Write results in Excel under multiple If statements

Related Question