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
