I need to write rows of data to an ascii file for later EXCEL conversion. this worked fine when my test script source data was originally a row. I converted it to ascii with num2str, and the resulting file was EXCEL compatible. The data I really need to write is in a column (1522x1). When I transpose it and then num2str it there are no spaces between the numbers, and Excel won't read it. Even if I don't transpose it, and the num2str result looks right, EXCEL wont take it. How can I get spaces between the numbers, or get something that excel will read? Actually the row string data is pretty worthless for anything. I considered sprint, but there were no format types for adding spaces as far as I could tell.
|