RE: excel from java

2004-01-07 Thread Edson Alves Pereira 
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]

RE: excel from java

2004-01-07 Thread 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]

RE: excel from java

2004-01-07 Thread Shapira, Yoav 

Howdy,
If you're working with Office XP or later, you can use XML spreadsheets.
It actually work great.  See this URL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2
003_ta/html/odc_xmllists.asp
(If the link doesn't work, it's the article titled XML in Excel and the
Spreadsheet Component in the Excel 2002 section of the MSDN library).

Yoav Shapira
Millennium ChemInformatics


-Original Message-
From: Kumar, Sumit [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 11:04 AM
To: 'Tomcat Users List'
Subject: 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]




This e-mail, including any attachments, is a confidential business communication, and 
may contain information that is confidential, proprietary and/or privileged.  This 
e-mail is intended only for the individual(s) to whom it is addressed, and may not be 
saved, copied, printed, disclosed or used by anyone else.  If you are not the(an) 
intended recipient, please immediately delete this e-mail from your computer system 
and notify the sender.  Thank you.


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