RE: excel from java

[David Sierra Fern�ndez]

You can also take a look at JAWIN. it's a bridge between JAva and Win32.
You can manage any scriptable COM object from your java code.
It could be a good option if you are good in programming Excel from Visual
Basic script.

here you have an example, a piece of code to generate a new excel sheet and
write some nonsense:



import com.develop.jawin.*;
import com.develop.jawin.win32.*;


public class ExcelProp {
  public static void main(String [] args) throws Exception {
    Ole32.CoInitialize();

    DispatchPtr app = new DispatchPtr("Excel.Application");

    app.put("Visible", -1);

    DispatchPtr books = app.getObject("Workbooks");

    DispatchPtr book =
(DispatchPtr)books.invoke("Open","d:\\jawin\\demos\\src\\sierra.xls");

    DispatchPtr sheets = book.getObject("Worksheets");
    DispatchPtr sheet = sheets.getObject("Item", new Integer(1));

    DispatchPtr x = (DispatchPtr)sheet.getN("Range", new Object[] { "A2",
"C3" });
    x.invoke("Select");

    DispatchPtr range = sheet.getObject("Range", "A1:A3");


    DispatchPtr range2 = range.getObject("Item", new Integer(2));
    range.putN("Item", new Object[] {new Integer(1)}, 2, range2);

    Ole32.CoUninitialize();
  }

}


David Sierra Fern�ndez

> -----Mensaje original-----
> De: Edson Alves Pereira [mailto:[EMAIL PROTECTED]
> Enviado el: mi�rcoles, 07 de enero de 2004 18:11
> Para: 'Tomcat Users List'
> Asunto: RE: excel from java
>
>
>       I�d take a look at OpenOffice code ( www.openoffice.og )
>
> > ----------
> > De:         Kumar, Sumit[SMTP:[EMAIL PROTECTED]
> > Responder:  Tomcat Users List
> > Enviada:    quarta-feira, 7 de janeiro de 2004 13:04
> > Para:       'Tomcat Users List'
> > Assunto:    excel from java
> >
> > Hello,
> >
> > I want to generate some complex excel sheets (performing calculations,
> > using
> > pivot tables etc) from my java code. Can somebody point me to good
> > opensource tools available to do that. I looked on apache and
> came across
> > POI-HSSF project. Is this the way to go or there are any better tools..
> >
> > Thnaks
> > -sumit
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]