CSV files into separate Excel spreadsheets all within 1 workbook

1 次查看（过去 30 天）
EL
EL 2016-12-15
回答： Walter Roberson 2016-12-15
Hello,
I have a large set of CSV files (N=400; all in a single folder) that need to be added as separate sheets into a single Excel Workbook. So far I have written code to open my destination workbook. I am having trouble, however, looping through my directory to open each CSV file. I then need to write each CSV file as a separate sheet in my destination workbook.
Any help would be greatly appreciated, thank you!

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

采纳的回答

Walter Roberson
Walter Roberson 2016-12-15
http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F
When you xlswrite() provide either a worksheet name or worksheet number as the third parameter.

更多回答（0 个）

类别

在 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