merging excel files in another excel

Question

0 个投票

Dear all,

I have some excel files, say sa.xlxs, sd.xlsx, vb.xlsx, ki.xlsx and so forth.

Is there any command for merging all of them in one sheet of another excel file such that the new sheet to contain first the sa.xlxs then sd.xlsx and so forth?

thanks

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

antonet 2012-5-28

Any answer? Because I searched for any relevant tread but could not find anything.

Thank you again

请先登录，再进行评论。

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

Follow Question

Answer 1

Oleg Komarov 2012-5-28

2 个投票

You have to use:

[optional] list = ls() to list the .xlsx files. You can use wildcards.
Import the files with xlsread()
Concatenate the data. One of the function you might need to use is cat() or []. Or refer to the many See Also links in cat()
Write output to excel with xlswrite()

Points 2-4 will usually loop on the list created with point 1 (or user supplied list)

2 个评论
显示无隐藏无

antonet 2012-5-28

thank you for oleg. to be honest I do not know how to concatenate the data or what "Points 2-4 will usually loop on the list created with point 1 (or user supplied list)" means. could you please be more specific?

thanks

Oleg Komarov 2012-5-28

Try points 2 and 4 for a specific file, then add another file (i.e. repeat point 2) then try point 3.

Once you're able to do it for a pair, you can add point 1. and try to write a for loop.

Also give a look here: http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

请先登录，再进行评论。

merging excel files in another excel

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

采纳的回答

2 个评论
显示无隐藏无

更多回答（0 个）

类别

标签

Community Treasure Hunt

merging excel files in another excel

1 个评论 显示 -1更早的评论 隐藏 -1更早的评论

采纳的回答

2 个评论 显示 无 隐藏 无

更多回答（0 个）

类别

标签

另请参阅

Community Treasure Hunt

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

2 个评论
显示无隐藏无