How to copy cells from one excel sheet to another

17 Ansichten (letzte 30 Tage)
pradeep kumar
pradeep kumar am 8 Nov. 2014
Kommentiert: pradeep kumar am 8 Nov. 2014
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

Akzeptierte Antwort

Image Analyst
Image Analyst am 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).

Weitere Antworten (0)

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by