How continuously saved to excel file
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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~!
0 Commenti
Risposte (4)
Rica
il 13 Nov 2012
Hi!
xlswrite('data.xls', {'title1' 'title2' 'title3'}, 'Sheet1', 'A1')
xlswrite('tempdata1.xls', ['data1 data2 data3'], 'Sheet1', 'A1')
Image Analyst
il 13 Nov 2012
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().
0 Commenti
BB
il 13 Nov 2012
Modificato: BB
il 13 Nov 2012
1 Commento
Image Analyst
il 13 Nov 2012
Modificato: Image Analyst
il 13 Nov 2012
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
il 13 Nov 2012
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.
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!