How continuously saved to excel file
显示 更早的评论
My workspace have A1 ~ A100 ,total 100 matrix
I want to save it as a excel file, the file name is the same as A1.csv ....
A100.csv
how to do it?
Thanks~!
回答（4 个）
Rica
2012-11-13
Hi!
xlswrite('data.xls', {'title1' 'title2' 'title3'}, 'Sheet1', 'A1')
xlswrite('tempdata1.xls', ['data1 data2 data3'], 'Sheet1', 'A1')
Image Analyst
2012-11-13
0 个投票
Evidently you don't want xlswrite(). You said you want csv files, so you need to use csvwrite(). You can't write continously, unless you open the file with fopen(), and write stuff out line by line with fprintf().
1 个评论
Image Analyst
2012-11-13
编辑：Image Analyst
2012-11-13
Well for one thing, you gave this as an answer when you should have edited your question. Next, this will not produce csv files - it will produce xls workbooks. Third, this will take an eternity because you will have to launch Excel and shutdown Excel 100 times. Use ActiveX if you want to do more than 1 or two writes to a workbook(s). Check out xlswrite1() in the File Exchange for instructions on how to use ActiveX. And finally, you didn't format your code as code. Highlight your code and click the {}Code icon to make it look like code.
Jan
2012-11-13
0 个投票
Remark: Using "A1" to "A100" is a bad idea. Using a cell "A{1}" to "A{100}" is much more useful, because you could process the data in a loop without the need to call the evil and confusing EVAL.
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
