Björn Helgason wrote:
> (1;'A') grid readexcelstring jpath '~addons/tara/test.xls'
>
> Looks relatively ok
>
> Obviously formating the date etc would need to be addressed
>
I agree readexcel is too lazy to parse date format, so for the time being it
depends on user's intelligence.
]a=: readexcel jpath '~addons/excel/tara/test.xls'
+--------+------+--------+
|1 |_2.2 |3.33 |
+--------+------+--------+
|4.444 |5.5555|_6.66666|
+--------+------+--------+
|hi there|3.3555|1 |
+--------+------+--------+
|0 |test |2 |
+--------+------+--------+
|there |38335 | |
+--------+------+--------+
load 'dates'
]a=: (todate@(+&36522)&.> (<4 1){a) (<4 1)}a
+--------+----------+--------+
|1 |_2.2 |3.33 |
+--------+----------+--------+
|4.444 |5.5555 |_6.66666|
+--------+----------+--------+
|hi there|3.3555 |1 |
+--------+----------+--------+
|0 |test |2 |
+--------+----------+--------+
|there |2004 12 14| |
+--------+----------+--------+
(1;'A') grid a
--
regards,
bill
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
