MATLAB: How to copy cells from one excel sheet to another

excelimporting excel data

Hellow everyone . I have one excel sheet like this
excelsheet1.xlsx = 
Name  Age
Tom   20
Dick  15
Harry 25
Now i want to copy the column A from excelsheet1.xlsx and make another excel file like this
excelsheet2.xlsx =
Name   Age_after_5_years
Tom       25 
dick      20
Harry     30
Please help me . Thanks in advance

Best Answer

Try something like this
[numbers, strings, raw] = xlsread('excelsheet1.xlsx');
columnA = raw(:, 1);
xlswrite('excelsheet2.xlsx', columnA);
From your example though, it looks like you might want both column A (the row headers) and column B (the numbers).
Related Question