MATLAB Answers

How to copy cells from one excel sheet to another

53 views (last 30 days)
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

Accepted Answer

Image Analyst
Image Analyst on 8 Nov 2014
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).

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!