> From: Robert O'Boyle > Sent: Tuesday, 14 September 2010 07:38 > 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?
Tara can create new files but not edit existing ones (There are also issues with writing to the same cell more than once during creation). I think this is a restriction of the format, but Bill Lam will be able to provide better info. To workaround you will need to read the data from old workbook & write that, with the new content to a new workbook. http://www.jsoftware.com/pipermail/programming/2007-March/005608.html ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
