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
