How to obtain one excel file instead of multiple file?

1 次查看（过去 30 天）
Jhilam Mukherjee
Jhilam Mukherjee 2015-4-24
回答： Image Analyst 2015-4-24
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)

请先登录，再回答此问题。

采纳的回答

Image Analyst
Image Analyst 2015-4-24
See the FAQ: http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F
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.

更多回答（1 个）

Star Strider
Star Strider 2015-4-24
I would put the xlswrite call after the for loop rather than in it.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by