Read spreadsheets on a list
显示 更早的评论
My program is going to process thousands of spreadsheet while I listed these files in a seperate spreadsheet. How can I read the list of the spreadsheet then let the program process them? Like, the spreadsheet name list is'FundsName.xlsx' [num, txt, raw] = xlsread('FundsName.xlsx');
This is reading this spreadsheet. How could my program process the spreadsheet listed in this one. What should I do next?
Many many thanks!
Daisy
回答（1 个）
Image Analyst
2012-10-30
0 个投票
Use xlsread to get the names from the FundsName workbook. Then open Excel using ActiveX. Then get xlswrite1 from the File Exchange. Use a for loop like in the FAQ to loop over each file, opening it via ActiveX, doing your stuff, and then (if necessary) sticking stuff back into the workbook with xlswrite1(), saving it, and closing it before continuing in the loop to process additional files. Search for ActiveX and Excel and you should find examples.
类别
在 帮助中心 和 File Exchange 中查找有关 ActiveX 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
