Pardon my ignorance but what is m$excel? Is this MS Office 2007 excel? All this to say is that this does not look as straightforward as I initially hoped.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of bill lam Sent: September 14, 2010 5:22 AM To: [email protected] Subject: Re: [Jprogramming] Reading & Writing Excel worksheets I suspect this method will also need m$ excel to be installed before use. Пнд, 13 Сен 2010, gary ng писал(а): > On Mon, Sep 13, 2010 at 8:40 PM, Alex Rufon <[email protected]> wrote: > > 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. > > > Another option is the access engine, turning it into a database and > update via odbc. I used this approach in some of my work(in c#). It > has the advantage that the presentation and even formula(i.e. business > logics) are kept intact. > ---------------------------------------------------------------------- > 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
