Prev: tsearch, dsearch to be removed == loss of functionality
Next: UKF and EKF
From: Zia on 9 Apr 2010 03:37
Hi,

I am currently working on a messy waste water project. I have doen the simulation for that. What i don't know is how i can transfer all my data into excel sheet.
In the beginning matlab read in the inputs and parameters from excel sheet, then it runs the simulation and displays the results as required. What i want is after finishing the simulation and showing the graphically results, it also writes the results in an excel sheet, in my case the same sheet from where its taking the inputs but in different tab. Does anyone know how can i do that?

Hope i will get an encouriging answer soon. Have a nice weekend!
Regards!
From: us on 9 Apr 2010 04:00
"Zia " <ziagemini(a)hotmail.com> wrote in message <hpmlfg$odn$1(a)fred.mathworks.com>...
> Hi,
>
> I am currently working on a messy waste water project. I have doen the simulation for that. What i don't know is how i can transfer all my data into excel sheet.
> In the beginning matlab read in the inputs and parameters from excel sheet, then it runs the simulation and displays the results as required. What i want is after finishing the simulation and showing the graphically results, it also writes the results in an excel sheet, in my case the same sheet from where its taking the inputs but in different tab. Does anyone know how can i do that?
>
> Hope i will get an encouriging answer soon. Have a nice weekend!
> Regards!

a hint:

help xlswrite;

us
From: Zia on 9 Apr 2010 04:15
Hi,

I used this example:

This example writes the following mixed text and numeric data to the file tempdata.xls:

d = {'Time', 'Temp'; 12 98; 13 99; 14 97};

Call xlswrite, specifying the worksheet labeled Temperatures, and the region within the worksheet to write the data to. The 4-by-2 matrix will be written to the rectangular region that starts at cell E1 in its upper left corner:

s = xlswrite('tempdata.xls', d, 'Temperatures', 'E1')
s =
1

The output status s shows that the write operation succeeded. The data appears as shown here in the output file:

Time Temp
12 98
13 99
14 97

Its nearly 20 minutes now but status is showing BUSY. Is it really takes that long??????
Regards!
From: us on 9 Apr 2010 04:30
"Zia " <ziagemini(a)hotmail.com> wrote in message <hpmnmc$r1g$1(a)fred.mathworks.com>...
> Hi,
>
> I used this example:
>
> This example writes the following mixed text and numeric data to the file tempdata.xls:
>
> d = {'Time', 'Temp'; 12 98; 13 99; 14 97};
>
> Call xlswrite, specifying the worksheet labeled Temperatures, and the region within the worksheet to write the data to. The 4-by-2 matrix will be written to the rectangular region that starts at cell E1 in its upper left corner:
>
> s = xlswrite('tempdata.xls', d, 'Temperatures', 'E1')
> s =
> 1
>
> The output status s shows that the write operation succeeded. The data appears as shown here in the output file:
>
> Time Temp
> 12 98
> 13 99
> 14 97
>
> Its nearly 20 minutes now but status is showing BUSY. Is it really takes that long??????
> Regards!

no...
seems to be a false alarm...
the fact that the function returned S and the output file contains the data tells CSSM that XLSWRITE itself is not busy anymore...
is it part of a script/function, which is still running(?)...

us
From: Zia on 9 Apr 2010 04:35
Hi,

And when i am using this command:
xlswrite('Data.xls', A, 'Output');

i get the following error:

??? Error using ==> xlswrite at 253
The file G:\Matlab_AD\Data.xls is not
writable. It may be locked by another
process.

Error in ==> RapidStartAD at 10
xlswrite('Data.xls', A, 'Output');

Any suggestions :-(
 | 
Pages: 1
Prev: tsearch, dsearch to be removed == loss of functionality
Next: UKF and EKF