How to copy cells from one excel sheet to another

Question

pradeep kumar 2014-11-8

评论： pradeep kumar 2014-11-8

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

Answer 1

Image Analyst 2014-11-8

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).

pradeep kumar 2014-11-8

Thanks a lot