How to combine multiple excel files with multiple spreadsheets of data into one

1 view (last 30 days)

Show older comments

Febin Saji on 21 Mar 2018

0
Link

Direct link to this question

https://se.mathworks.com/matlabcentral/answers/389639-how-to-combine-multiple-excel-files-with-multiple-spreadsheets-of-data-into-one

Answered: ES on 21 Mar 2018

I have multiple excel files with data in multiple sheets and each sheet has a specific format. I want to make a new excel file that has the compiled data of all the files and each sheet of this new file should contain combined data of the respective sheets.

0 Comments
Show -2 older commentsHide -2 older comments

Sign in to comment.

Sign in to answer this question.

Answers (1)

ES on 21 Mar 2018

0
Link

Direct link to this answer

https://se.mathworks.com/matlabcentral/answers/389639-how-to-combine-multiple-excel-files-with-multiple-spreadsheets-of-data-into-one#answer_311072

doc xlsread doc xlswrite

0 Comments
Show -2 older commentsHide -2 older comments

Sign in to comment.

Sign in to answer this question.

Categories

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

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