Prev: how to display 3D histogram and intensity map at the same time?
Next: load multiple files
From: Christopher on 25 Mar 2010 10:24
I had code that ran without issues. Now all of a sudden, MATLAB is treating imported dates from Excel (formatted) as numbers instead of strings. The behavior is sporadic.

For example, using "importdata" I imported this:

1/1/2010 1 1/1/2011
2/1/2010 2 2/1/2011


It is importing as
1/1/2010 1 40544
2/1/2010 2 40575

Both column 1 and 3 are date fields in Excel, formatted the same way. The first two columns shown in the import are actually in the "textdata" part of the structure, where I'd expect them.

The behavior is sporadic and not predictable to me. Any help is appreciated.
From: Christopher on 25 Mar 2010 10:36
I should also note that the command works exactly as expected on a colleagues computer.

Mine opens up a messsage from Excel that says "File conversion in progress" when running the matlab importdata function.

"Christopher " <christophermcleester(a)removethisexeloncorp.com> wrote in message <hofrm4$390$1(a)fred.mathworks.com>...
> I had code that ran without issues. Now all of a sudden, MATLAB is treating imported dates from Excel (formatted) as numbers instead of strings. The behavior is sporadic.
>
> For example, using "importdata" I imported this:
>
> 1/1/2010 1 1/1/2011
> 2/1/2010 2 2/1/2011
>
>
> It is importing as
> 1/1/2010 1 40544
> 2/1/2010 2 40575
>
> Both column 1 and 3 are date fields in Excel, formatted the same way. The first two columns shown in the import are actually in the "textdata" part of the structure, where I'd expect them.
>
> The behavior is sporadic and not predictable to me. Any help is appreciated.
 | 
Pages: 1
Prev: how to display 3D histogram and intensity map at the same time?
Next: load multiple files