excel from java 2004-01-07 - By David Sierra Fern�ndez
Back
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:eapereira@(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:Sumit.Kumar@(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: tomcat-user-unsubscribe@(protected)
> > For additional commands, e-mail: tomcat-user-help@(protected)
> >
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
|
|
