I didn't use a script - I just swiped lines from the "Tara and Excel" lab:
load '~addons/tables/tara/tara.ijs'
lgmat=. ?65536 256$0
bi=: ('Courier New' ; 220) conew 'biffbook'
writenumber__bi 0 0 ; 16384{.lgmat_base_
writenumber__bi 16383 0 ; 16384}.lgmat_base_
|out of memory: writenumber
| stream__l=:stream__l,,(toHeader 515,14),("1)(_2]\toWORD0({:s)#r+i.{.s)
,("1)(_2]\toWORD0,({.s)#,:c+i.{:s),("1)(toWORD0 xf),("1)(_8]\toDouble0,yn)
save__bi 'c:\amisc\taraLg1.xls'
This saved the first half of my large matrix. This is on my 1GB RAM
machine.
On 4/21/08, bill lam <[EMAIL PROTECTED]> wrote:
>
> Devon McCormick wrote:
>
> > FWIW - since I have Excel 2007 installed on one of my machines, I
> > thought
> > I'd mention that its row and column limits are 1048576 x 16384.
> >
> > I kept running out of memory trying to use Tara to write my 65536 by 256
> > matrix of floating point numbers to a spreadsheet. I also had problems
> >
>
> */65536 256 8
> 134217728
> This is about 134MB only. Tara should handle it. Can you post your test
> script?
>
> I heard that Office 2007 only available in 32-bit. It that true? Could you
> confirm this by looking at the task manager?
>
> regards,
>
>
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
>
--
Devon McCormick, CFA
^me^ at acm.
org is my
preferred e-mail
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
