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~!

Answer 1

[Rica]

Hi!

 xlswrite('data.xls', {'title1' 'title2' 'title3'}, 'Sheet1', 'A1')

 xlswrite('tempdata1.xls', ['data1 data2 data3'], 'Sheet1', 'A1')

[BB]

HI.but I steel don't know how to write excel file continuously.

Answer 2

[Image Analyst]

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().

Answer 3

[BB]

This is my code

for d=1:100;

eval(['csvwrite(''A',num2str(d),'.csv'')','=A',num2str(d)]);

end

what wrong about me?

[Image Analyst]

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.

Answer 4

[Jan]

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.

[BB]

THANK YOU~