MATLAB: MATLAB EXCEL

excel remove

Hello guys!

For example:

This code will insert my name in A1 cell in Excel:

xlswrite('test.xls',{'Aldin'},1,'A1');

Right? But what is if i will to remove my name from A1 cell. Is there a function in MATLAB for removing data from Excel? And also for updating…..

Thanks.

Best Answer

From:

doc xlswrite

I would actually conclude the opposite, and that it can be done easily:

MATLAB converts NaN values to empty cells

Related Solutions

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

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');

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 delete a certain cell area in an Excel table using MATLAB 7.8 (R2009a)

MATLAB: Write results in Excel under multiple If statements

Related Question