Data transfer from excel to excel
1 view (last 30 days)
Show older comments
Hello,
I have an excel workbook with 350 columns and 15 rows. I need to pick required columns ( for example col 1:5, 80: 82, 234:268 and all the rows. Then, I need to write that into a new excel. Any help is greatly appreciated.
Thanks in advance.
0 Comments
Accepted Answer
Image Analyst
on 12 Mar 2015
Try something like this (untested)
[~,~,raw] = xlsread(oldFileName);
columns = [1:5, 80: 82, 234:268];
output = raw(:, columns); % Extract only the columns we want.
xlswrite(newFileName, output);
More Answers (0)
See Also
Categories
Find more on Spreadsheets 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!