MATLAB: Writing date on an excel sheet

dateexcel sheet

Hi folk,

Got a question about writing date on an excel sheet. I am using the following codes:

DATE=datestr(now);

xlswrite('test.xls', DATE, 'A1')

The problem is that it separates each number and letter and put them in separate cells. I want the whole date in one cell like 'A1' but it appears from 'A1' to 'T1'

I appreciate your help. Thank you.

S:-)

Best Answer

xlswrite('test.xls', {datestr(now)})

Related Solutions

MATLAB: Remove weekends and holidays data from excel file

% Read data 
T1 = readtable('ABC.xlsx','sheet',1) ;
T2 = readtable('ABC.xlsx','sheet',2) ;
% Get dates common in both 
idx = ismember(T1.(1),T2.(1)) ;
% Pick which are not common 
T = T1(~idx,:) ;
% write to a file 
writetable(T,'test.xlsx')

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: Remove weekends and holidays data from excel file

MATLAB: Write results in Excel under multiple If statements

Related Question