Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
export data from scilab to excel
3,015 views
Skip to first unread message
anne-lise
Jan 16, 2005, 1:35:17 PM1/16/05
to
Hi, I want to export a matrix from scilab to excel and I don't manage
to do it correctly.
to do it correctly.
I have a 12*90 matrix in scilab and I did the following command to
convert it in excel: write('myfile.xls', my_matrix, '(90(f10.2))')
This command put the 90 first value of the first row of my matrix in
the first box of the excel file.
I want of course to have a value per box. Do you have a solution to
help me ?
Thanks
Anne-Lise
patrick...@free.fr
Jan 17, 2005, 4:05:07 AM1/17/05
to
The synthax you used should work; it does when I try:
write("foo.xls", rand(12, 90), '(90(f10.2))')
You can check all your data are written in the file by opening it with
a text editor.
May be your pb is due to the way excel open the file and read the data;
once your file is opened in excel, "data / convert" (guess it is the
translation of my french version of excel). Also, you'd probably better
give your file a ".csv" extension, as the file you write is not exactly
an excel file, but rather an ascii file with coma - or other -
separated value file.
Does it help?
write("foo.xls", rand(12, 90), '(90(f10.2))')
You can check all your data are written in the file by opening it with
a text editor.
May be your pb is due to the way excel open the file and read the data;
once your file is opened in excel, "data / convert" (guess it is the
translation of my french version of excel). Also, you'd probably better
give your file a ".csv" extension, as the file you write is not exactly
an excel file, but rather an ascii file with coma - or other -
separated value file.
Does it help?
0 new messages