The test were all that I needed, I would leave it to the more
knowledgeable people to add more examples or writing covering
verbs.
Most probably OOo guys will tell you how to do it using
starbasic (ooo basic), that should also helps.
Ср, 10 июл 2013, Mike Day писал(а):
> Spasibo, Bill. Trouble with that idea is that I probably won't
> understand the answer!
> Whoever wrote wdooo might know how and could add a couple of example
> lines to the "test" verb.
> I DID find that you can get an instance of a named worksheet for
> read/write using 'getByName' rather than 'getByIndex' .
> Your correspondence with David Mitchell suggested you are both well
> up on this stuff!
>
> Cheers,
>
> Mike
>
> On 10/07/2013 02:29, bill lam wrote:
> >No idea how to read/write a range of cells. You may get some
> >advices in openoffice programmning forums.
> >
> >Вт, 09 июл 2013, Mike Day писал(а):
> >>Having started this thread, which has growed like Topsy, I ought to
> >>report some "progress".
> >>
> >>I think my remarks about 64 and/or 32 bits were misleading. I'd
> >>misunderstood how different Open Office and Office 20xx are under the
> >>bonnet (hood).
> >>
> >>So I've managed to rejig my code so that it more properly recognises
> >>that it needs to output using wdoo rather than tara.
> >>It still reads in what it needs to with readexcel ! The s/sheet is
> >>now getting overwritten in a named worksheet as I wish.
> >>
> >>I wanted to write a boxed numeric array with some nulls but couldn't
> >>see how to do it. I suspect I need GetCellRangeByPosition, but
> >>haven't yet managed to use SetValue without some error. As I avoid
> >>Visual Basic etc like the plague, I don't really want to learn now to
> >>do this. Could wdoo(o) please have some cover functions for moving
> >>arrays in and out? As it is, I'm doing a clunky loop.
> >>
> >>Jbeta really: I haven't yet managed to fully install J801 64-bit - I
> >>want to put it into c:\d\j801* - but install 'qtide' seems not to
> >>download qt.exe - I've spent hours trying to puzzle it out and might
> >>give up choosing where I want it to reside and let the J installer
> >>use the default location. Is qt.exe somewhere in
> >>jsoftware.com/download?
> >>
> >>Mike
> >>* (c:\d is logical drive d: but the os seems not to like d: ! - the
> >>new machine didn't offer a chance to partition the c: drive)
> >>
> >>On 08/07/2013 15:20, David Mitchell wrote:
> >>>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
