Sad to say, the crash occurs with jconsole 64 and does not occur with jconsole
64 running under cdb.
This also happens with jqt running with and without cdb.
I will have to be more imaginative with my debugging.
On 7/8/2013 21:11, bill lam wrote:
For the purpose of testing wdooo and openoffice, it can be done
inside jconsole.
Пн, 08 июл 2013, David Mitchell писал(а):
When I try the updated script from the latest J801 64 on Win7 64, I
get a 'jqt.exe has stopped working' message box.
I have not looked at the crash in more detail, so it was not clear to
me what the root of the problem was.
On 7/8/2013 11:26, bill lam wrote:
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
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
