Whenever I need to update an excel file, I rename it first to another file then save my in-memory updated copy. Of course you'll lose some stuff like formatting, colors, etc.
If you really need to preserve the formatting, MS-Office OLEAUTOMATION is the best bet. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of bill lam Sent: Tuesday, September 14, 2010 8:57 AM To: [email protected] Subject: Re: [Jprogramming] Reading & Writing Excel worksheets you may use oleautomation to read or write to an existing workbook file, however that requires m$ excel or openoffice to be installed. Пнд, 13 Сен 2010, Robert O'Boyle писал(а): > 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 -- 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 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
