Yes, I did go through the lab but according to the lab, bi is a new excel
file created by conew. For example
bi=: '' conew 'biffbook'
What I have is an existing excel file. So what I need to do is assign an
existing excel to, in this case, bi.
Is there a verb for this?
I also looked at using readexcel jpath 'file name.xls' and then updating
this but readexcel generates a matrix without the same cell references as
the initial excel worksheet (ie. Row and Column 0 are not A1 but C2.
Bob
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Lettow, Kenneth
Sent: September 13, 2010 4:59 PM
To: Programming forum
Subject: Re: [Jprogramming] Reading & Writing Excel worksheets
You should run the lab TARA and Excel. The lab will demonstrate the
methods that you need.
>From the lab:
writestring__bi 1 3 ; 'hello world' NB. write text in a cell:
rowcol ; text (rowcol is 0-based)
writenumber__bi 'C3' ; o.1
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Robert O'Boyle
Sent: Monday, September 13, 2010 3:38 PM
To: [email protected]
Subject: [Jprogramming] Reading & Writing Excel worksheets
Hi forum.
I have been experimenting with Tara and have a problem that no doubt has
been solved many times before. I have a saved excel worksheet to which I
have like to write J lists and tables generated by some simulation
software
that I have. Writing these to specific locations in the excel worksheet
allows automatic updating of the plots etc that are in the excel file. I
see
that one can write tables using the writexlsheets verb but it not
obvious
to me from the lab how these tables can be written to specific locations
in
already existing excel files. Can anyone help me out?
Bob
----------------------------------------------------------------------
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
