How to copy cells from one excel sheet to another

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

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!