Read excel files and write its data after transpose to another folder
조회 수: 3 (최근 30일)
이전 댓글 표시
Dear Matlab Users ,
i have 100 excel files that are saved in specific folder ( "D:\Second_folder"); with names are [ file1.xls , file2.xls , ..... file100.xls] , each file contain only single sheet and includes different data ranges , i need to read each file and then write it in another folder called ("D:\Master_folder" ) by changing its columns to rows and vice versa , so all files are read then transpose and writes to Master folder , ranges of data of each file its differ from other files some files may 100 columns and 20 rows and others may 200 columns and 50 rows , My question is there any matlab code can do that ?
this an example of one excel file
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/153498/image.jpeg)
then will be like the following format after written
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/153499/image.jpeg)
thanks
댓글 수: 0
답변 (1개)
Geoff Hayes
2016년 1월 23일
Ahmed - are you combining all files into a single file, or are you creating (say) 100 new files in a different folder with all the data transposed? See http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F to get you started on iterating over this sequence of Excel files, xlsread on how to read each file, and transpose on transposing the data.
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!