How to obtain one excel file instead of multiple file?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Jhilam Mukherjee
le 24 Avr 2015
Réponse apportée : Image Analyst
le 24 Avr 2015
I have 10 excel file in a folder. I have fetch 1st column from each file using for loop. I want to create another excel file containing these 10 column, but I get 10 different excel file instead of one file. How can I overcome this problem?
Area{i}=xlsread(filename,sheet,'A:A');
xlswrite(strcat('D:\result_excel\AREA','.xls'),Area{i},1)
0 commentaires
Réponse acceptée
Image Analyst
le 24 Avr 2015
In the loop, get the filename, extract the first column into the next column of a double array or a cell array that you are building up. Then when the loop exits, create an output filename and write out the data. The FAQ has code samples.
0 commentaires
Plus de réponses (1)
Star Strider
le 24 Avr 2015
I would put the xlswrite call after the for loop rather than in it.
0 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!