Splitting columns of Excel files

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)

A=reshape(A,size(A,1),200,[]);
then iterate over planes to save.

Asked:

on 23 Sep 2015

Answered:

dpb
on 23 Sep 2015

Community Treasure Hunt

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

Start Hunting!