Thanks, the typo in oocalc.ijs has been fixed and package
updated.
64-bit J can call 32-bit out-of-process oleautomation server. IIRC
I had tested calling a 32-bit excel.exe from 64-bit J wdooo.
Not tested for that on Openoffice, if it fails I suspect that
should be a problem of Openoffice itself.
Пн, 08 июл 2013, David Mitchell писал(а):
> Mike,
>
> I tried the demo script oocalc.ijs on both Win7 and Win8 with the latest J801.
>
> I found out these things:
>
> 0. Open Office is only available as 32 bit executables. The wdooo
> code will only work with J801 32 bit, as far as I can see.
>
> 1. The verb test.ijs would not work for me on any version of J
> without some changes:
>
> ---
> test=: 3 : 0
>
> NB. (1!:1 <jpath '~addons/tables/wdooo/test1.ijs') 1!:2 <f=. jpath
> '~temp/test1.xls'
> (1!:1 <jpath '~addons/tables/wdooo/test1.xls') 1!:2 <f=. jpath
> '~temp/test1.xls'
>
> PATH=. '/'&(('\' I.@:= ])}) f
>
> NB. f1=. 'file:///', PATH, '/test1.xls'
> f1=. 'file:///', PATH
>
> smoutput f1
> ---
>
> I also changed test.ijs to update the second sheet rather than the first
> sheet:
>
> NB. olemethod__p temp ; 'getByIndex' ; 0
> olemethod__p temp ; 'getByIndex' ; 1
>
> Once I made these changes, with the latest version of J801 32 bit and
> the current Open Office installed, the workbook test.xls in
> j801-user\temp showed this for Sheet 2 cells D:10, E:10, F:10:
>
> OOo Calc 123 02/28/07
>
> Which is not in the original workbook.
>
> So the bottom line is that the code example in oocalc.ijs, as
> modified above, will update and save the workbook with one sheet
> modified.
>
> Good luck,
> David Mitchell
>
>
> On 7/5/2013 5:16, Mike Day wrote:
> >(copied to Bill & Ric)
> >
> >I suspect Bill Lam and/or Ric Sherlock are the people are the people to ask
> >here, and but I'll ask the forum as a whole anyway:
> >
> >I've just acquired a new laptop and am enjoying learning 64-bit Windows 8.
> >I'm
> >loth to pay big pounds for Office 2010 or whatever. My 32-bit Windows 7 still
> >supported my old Office 2003 but that doesn't run in Win 8. I've downloaded
> >Open Office which seems to be well thought of as an alternative to M/S
> >Office.
> >
> >I wonder how to continue do the following, which worked under Windows 7
> >
> >I have a multi-worksheet xls file.
> >My J application successfully reads one small named worksheet, not the
> >first,
> >using readexcel .
> >It uses that information and wished to modify the contents of that worksheet
> >ONLY.
> >Under Windows 7 it successfully called wdoowrite to do this.
> >However, I find the workbook is not updated on the new machine.
> >
> >I had used wdoowrite rather than writexlsheets as it appears that the latter
> >overwrites the whole file, but I might have misunderstood it.
> >It looks as if writeshtdat might do the job, but I'm not sure what locale
> >info
> >to offer as the x argument.
> >
> >Advice would be welcome!
> >
> >Thanks
> >
> >Mike
> >
> >
> >
> >----------------------------------------------------------------------
> >For information about J forums see http://www.jsoftware.com/forums.htm
> >
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
--
regards,
====================================================
GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
