automatic date detection

Ok I saw this thread
http://www.phpclasses.org/discuss/package/6279/thread/9/

but what I want to know is I may not know which columns are date fields , is there any way this can be done automatically, or any way to find the type of column

I would like to bump this thread. It would be nice to automatically output the date field in a spreadsheet as a lot of spreadsheets will include date data rather than needed to figure out which row or column contains the data, and then using a unixstamp or PHP date function.

Is there a plan to develop this?
Otherwise this is a nice project. Thanks,
-Kavel

check 0.6.3 version

print_r( $xlsx->rowsEx() ); // there type = 'd' for dates now

type index for date column is still empty
rows ex print out for a sample file is
Array
(
[0] => Array
(
[0] => Array
(
[type] => s
[name] => A1
[value] => Numbers
[href] =>
[f] =>
[format] => General
)

[1] => Array
(
[type] => s
[name] => B1
[value] => Message
[href] =>
[f] =>
[format] => General
)

[2] => Array
(
[type] => s
[name] => C1
[value] => Date
[href] =>
[f] =>
[format] =>
)

)

[1] => Array
(
[0] => Array
(
[type] =>
[name] => A2
[value] => 9591283838
[href] =>
[f] =>
[format] => General
)

[1] => Array
(
[type] => s
[name] => B2
[value] => Dear Anbu testing
[href] =>
[f] =>
[format] =>
)

[2] => Array
(
[type] =>
[name] => C2
[value] => 41339
[href] =>
[f] =>
[format] =>
)

)

[2] => Array
(
[0] => Array
(
[type] =>
[name] => A3
[value] => 7760030193
[href] =>
[f] =>
[format] => General
)

[1] => Array
(
[type] => s
[name] => B3
[value] => Dear Niranjan
[href] =>
[f] =>
[format] =>
)

[2] => Array
(
[type] =>
[name] => C3
[value] => 41339
[href] =>
[f] =>
[format] =>
)

)

)

column C2 and C3 are date,, but type is blank

hey sergey thanks for replying ,
here is the row output for the same sample file

SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => 1
[spans] => 1:3
)

[c] => Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => A1
[s] => 2
[t] => s
)

[v] => 0
)

[1] => SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => B1
[s] => 3
[t] => s
)

[v] => 1
)

[2] => SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => C1
[s] => 5
[t] => s
)

[v] => 4
)

)

)
SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => 2
[spans] => 1:3
)

[c] => Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => A2
[s] => 1
)

[v] => 9591283838
)

[1] => SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => B2
[t] => s
)

[v] => 2
)

[2] => SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => C2
[s] => 6
)

[v] => 41339
)

)

)
SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => 3
[spans] => 1:3
)

[c] => Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => A3
[s] => 1
)

[v] => 7760030193
)

[1] => SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => B3
[t] => s
)

[v] => 3
)

[2] => SimpleXMLElement Object
(
[@attributes] => Array
(
[r] => C3
[s] => 6
)

[v] => 41339
)

)

)

hmmm

send me your xlsx to sergey.shuchkin[ Who let the dogs out? ]gmail.com

done its from [email protected]

try 0.6.4

yo its working , thanks man

Automatic date detection still fails on my spreadsheet. I still get columns with 41090.