RE: excel from java
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: JSP Editors
¿Any of this editors you mentioned (or other)supports step by step debbuging in JSP ¿or simply debugging? David Sierra Fernández e-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > -Mensaje original- > De: Shanta B [mailto:[EMAIL PROTECTED] > Enviado el: viernes, 28 de noviembre de 2003 11:35 > Para: ''Tomcat Users List' ' > Asunto: RE: JSP Editors > > > > JIDEA is also best .by using this u can go through internal > java scource > code and also option to remote debug ur servlets by using tomcat > -Original Message- > From: Bodycombe, Andrew > To: 'Tomcat Users List' > Sent: 28/11/2003 3:48 PM > Subject: RE: JSP Editors > > www.jedit.org > www.eclipse.org > > Both are free and up to the task. > > Andy > > -Original Message- > From: Duncan [mailto:[EMAIL PROTECTED] > Sent: 28 November 2003 09:54 > To: Tomcat User List > Subject: JSP Editors > > > Sorry if off topic but... > > What do people use to edit JSPs? > > I'm after an editor, free if possible, to run on windows, with syntax > colouring and possibly auto complete for java. > > Have tried vim for windows, but it doesn't seem as nice on windows as it > is on linux. > > > Any other suggestions? > > Cheers > Duncan Smith > Decker Telecom Ltd > > > - > 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] > > - > 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]
Tomcat and a DLL
Hi all, I have developed a small app with jawin (a java2COM bridge). I have used eclipse as a development tool and I referenced the jawin libraries and all works ok. the problem is when i deploy the app to Tomcat 4 and try to use a jsp to invoke my classes, I get an error that I can't solve. I think is a problem of ubication of JAWIN libraries because when I try to get other class that does not use JAWIN, all works perfectly. I simplified the JSP in order to detect the error and I let it to invoke a simple constructor but goes on crashing! I tried to put jawin.dll and jawin.jar in the same directory that the class, in the app lib directory, in the common/lib directory of tomcat, in system32, in lib of the JRE, in bin of the JRE. it's useless, I don't know how to solve the error. The JSP is just as this. * <%@ page import="es.tid.coche.correo.GestorCorreo" %> <% GestorCorreo gestor = new GestorCorreo(); %> MAIL APPLICATION * As you can see I only invoke the constructor but it crashes. I have emptied the constructor method and works pretty fine (doing nothing...obviously) but when i make a call to an object of the library it crashes. This does not happen when i use eclipse... import com.develop.jawin.*; import com.develop.jawin.win32.*; import java.util.Vector; import es.tid.coche.beans.CorreoBean; the error I get in Internet Explorer is this: org.apache.jasper.JasperException: com/develop/jawin/DispatchPtr (Illegal Class name "jawin folder/develop/jawin/DispatchPtr") at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 48) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) DispatchPtr is a java class of the library that I use... any ideas? David Sierra Fernández e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
