Prev: need to kill worker process in parfor loop
Next: GUI Help
From: Anthony Brinkley on 10 May 2010 15:16
I am using xlsread to grab some number and text data in Excel. The text data contains values in the date time format as follows (I can't change the source code producing this format):

TimeStamp
02/19/2010 05:13:05.068 AM
02/19/2010 05:13:10.067 AM
02/19/2010 05:13:24.067 AM

Using:
[num text raw] = xlsread(filename,'worksheet');

The ".068", ".067", and ".067" do not pass through the function and I end up with:
02/19/2010 05:13:05 AM
02/19/2010 05:13:10 AM
02/19/2010 05:13:24 AM

Also occurs within the "raw" matrix. I can change it manually if I open Excel and serialize the values, but would like this to be automated.

thanks for any help. Anthony
From: ade77 on 10 May 2010 16:21
"Anthony Brinkley" <Anthony.Brinkley(a)dynetics.com> wrote in message <hs9m26$ojr$1(a)fred.mathworks.com>...
> I am using xlsread to grab some number and text data in Excel. The text data contains values in the date time format as follows (I can't change the source code producing this format):
>
> TimeStamp
> 02/19/2010 05:13:05.068 AM
> 02/19/2010 05:13:10.067 AM
> 02/19/2010 05:13:24.067 AM
>
> Using:
> [num text raw] = xlsread(filename,'worksheet');
>
> The ".068", ".067", and ".067" do not pass through the function and I end up with:
> 02/19/2010 05:13:05 AM
> 02/19/2010 05:13:10 AM
> 02/19/2010 05:13:24 AM
>
> Also occurs within the "raw" matrix. I can change it manually if I open Excel and serialize the values, but would like this to be automated.
>
> thanks for any help. Anthony

I tried your example , and it worked perfectly on my computer, the '0.68', '0.67', and '0.67' pass through.

What version of Excel and MATLAB are you using.
From: Anthony Brinkley on 11 May 2010 09:07
"ade77 " <ade100a(a)gmail.com> wrote in message <hs9prl$774$1(a)fred.mathworks.com>...
> "Anthony Brinkley" <Anthony.Brinkley(a)dynetics.com> wrote in message <hs9m26$ojr$1(a)fred.mathworks.com>...
> > I am using xlsread to grab some number and text data in Excel. The text data contains values in the date time format as follows (I can't change the source code producing this format):
> >
> > TimeStamp
> > 02/19/2010 05:13:05.068 AM
> > 02/19/2010 05:13:10.067 AM
> > 02/19/2010 05:13:24.067 AM
> >
> > Using:
> > [num text raw] = xlsread(filename,'worksheet');
> >
> > The ".068", ".067", and ".067" do not pass through the function and I end up with:
> > 02/19/2010 05:13:05 AM
> > 02/19/2010 05:13:10 AM
> > 02/19/2010 05:13:24 AM
> >
> > Also occurs within the "raw" matrix. I can change it manually if I open Excel and serialize the values, but would like this to be automated.
> >
> > thanks for any help. Anthony
>
> I tried your example , and it worked perfectly on my computer, the '0.68', '0.67', and '0.67' pass through.
>
> What version of Excel and MATLAB are you using.

Excel 2007. Matlab 2009a. I'm on a 64-bit machine.
 | 
Pages: 1
Prev: need to kill worker process in parfor loop
Next: GUI Help