Re: [Jprogramming] Reading & Writing Excel worksheets

[gary ng]

On Mon, Sep 13, 2010 at 8:40 PM, Alex Rufon <alex_ru...@ist-systems.com> 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