how do i merge multiple excel files into a single input

6 次查看（过去 30 天）
Nadiah Zainudin
Nadiah Zainudin 2018-1-16
回答： KSSV 2018-1-16
I have multiple files that i would like to merge as a single input. What function do i have to use?

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

回答（1 个）

KSSV
KSSV 2018-1-16
Read about xlsread . With this you can read excel data into matlab.
files = dir('*.xls') ; % Excel file extension
N = length(files) ; % total files
iwant = cell(N,1) ;
for i = 1:N
[num,txt,raw] = xlsread(files(i).name) ;
iwant{i} = num ;
end
Now you have all the data of excel files in iwant. You can write that into a single file.

类别

在 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