I guess you have a way of letting tara tell you if a cell should contain
date.
After reading the lab a few times I see you can most anything with the excel
files.
Even correct excel bugs.
I think the combination of excel files and grid is really interesting.
2006/11/15, bill lam <[EMAIL PROTECTED]>:
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
--
Björn Helgason, Verkfræðingur
Fugl&Fiskur ehf, Þerneyjarsund 23, Box 127
801 Grímsnes ,t-póst: [EMAIL PROTECTED]
Skype: gosiminn, gsm: +3546985532
Landslags og skrúðgarðagerð, gröfuþjónusta
http://groups.google.com/group/J-Programming
Tæknikunnátta höndlar hið flókna, sköpunargáfa er meistari einfaldleikans
góður kennari getur stigið á tær án þess að glansinn fari af skónum
/|_ .-----------------------------------.
,' .\ / | Með léttri lund verður |
,--' _,' | Dagurinn í dag |
/ / | Enn betri en gærdagurinn |
( -. | `-----------------------------------'
| ) | (\_ _/)
(`-. '--.) (='.'=)
`. )----' (")_(")
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
