Is this a problem with having to write the whole file at once?
On 4/21/08, Devon McCormick <[EMAIL PROTECTED]> wrote:
>
> 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
>
--
Devon McCormick, CFA
^me^ at acm.
org is my
preferred e-mail
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
