Excel in Java

Thread view:

Greg - 12 Jun 2006 10:04 GMT

Hi All,

Could anyone recommend a good product created in java (independed from
Microsoft) to work with excel files. I have a good mathematical model in
excel with some charts which relies on formulas. I would like to use it in a
different java application as a part of it. I need to enable users to view
this file and manipulate a bit with rows and formulas. Also I need to
develop some additional classes that will work on this excel file (like
VBA).

Could you please recommend me anything? I found Actuate e.Spreadsheet. Do
you know anything about this product?

Thanks

Greg

Reply to this Message

David Kerber - 12 Jun 2006 12:58 GMT

Have you looked at OpenOffice.org? I don't know if their spreadsheet
does macros, but it does handle handle .xls format files with no trouble
that I've run into yet.

> Hi All,
>
[quoted text clipped - 12 lines]
>
> Greg

Signature

Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Reply to this Message

tnleeuw - 12 Jun 2006 13:10 GMT

> Have you looked at OpenOffice.org? I don't know if their spreadsheet
> does macros, but it does handle handle .xls format files with no trouble
> that I've run into yet.

But how feasible would it be to access it from a Java application? What
if that Java application has to be portable or self-contained? What
about server-side Java applications? Don't know if the O-P wants a
server-side application, but I think the other concerns are valid
nonetheless:instead of making your app. dependant on MS-Excel, you're
making your app dependant on another huge beast.

I think the O-P wanted more something along the lines of a pure Java
spreadsheet-engine, that can be bundled as a library, and also still
read&execute Excel files?

Cheers,

--Tim

Reply to this Message

Greg - 12 Jun 2006 13:32 GMT

In fact I need something like pure Java spreadsheet engine as library. The
application will be standalone. I do not want users to think that this model
is excel based. Most Excel features will be disabled. At the moment my Excel
files combines extended business plan. I though it should be quite quick and
efficient to work on this file by using Java spreadsheet engine library with
good API, so I could totally change the look and write some additional
functions integrated with my business plan model. I addition I will have to
provide some input data from my current Java app. Users should be allowed
only to modify designated part of model by inserting new rows, updating
cells and creating simple formulas (in Excel based way).

Cheers,

Greg

>> Have you looked at OpenOffice.org? I don't know if their spreadsheet
>> does macros, but it does handle handle .xls format files with no trouble
[quoted text clipped - 14 lines]
>
> --Tim

Reply to this Message

David Kerber - 12 Jun 2006 13:42 GMT

> > Have you looked at OpenOffice.org? I don't know if their spreadsheet
> > does macros, but it does handle handle .xls format files with no trouble
[quoted text clipped - 10 lines]
> spreadsheet-engine, that can be bundled as a library, and also still
> read&execute Excel files?

Ok; I misunderstood what he wanted. OO wouldn't be a candidate for this
application, AFAICS.

Signature

Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Reply to this Message

Axel Hallez - 12 Jun 2006 14:10 GMT

Looks like you're looking for this:
http://jakarta.apache.org/poi/hssf/index.html

Axel Hallez

> Hi All,
>
[quoted text clipped - 12 lines]
>
> Greg

Reply to this Message

Greg - 13 Jun 2006 15:48 GMT

I though about this as well. It looks quite good, but it seems to me that
this product is still far from it's final state (good formulas support,
charts, etc). I would need something more stable.

Thanks,

Greg

> Looks like you're looking for this:
> http://jakarta.apache.org/poi/hssf/index.html
[quoted text clipped - 17 lines]
>>
>> Greg

Reply to this Message

Excel in Java

Free Magazines