Splitting columns of Excel files
Show older comments
I have Excel file having 50 rows and 4000 columns, I want to split the columns in this manners B=A(:,1:200); B=A(:,201:400); --- --- B=A(:,3801:4000) in the folder all 20 .xlsx files get automatically saved..
Answers (1)
dpb
on 23 Sep 2015
A=reshape(A,size(A,1),200,[]);
then iterate over planes to save.
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!