Re: open excel template and insert data by click button from JSP

Article View: borland.public.jbuilder.java.language

Article #8617

Back to borland.public.jbuilder.java.language Previous Next

#8617

From: Ivo B. Limmen
Date: Mon, 12 Mar 2001 07:40

34 lines
2067 bytes

Yes you should use ActiveX to do that... but you will have to do that client
side. I suggest you start looking at http://msdn.microsoft.com for more
information regarding ActiveX object and using Excel.

You can also use VBScript and use the 'CreateObject' feature using the
'Excel' VBA object. Example:

---
dim x as Object
Set x = CreateObject("Excel.workbook")
---
(Don't know if this is a 100% I might be a bit rusty... but it is in the
right direction)

Remember that this works client-side unless you have IIS (Internet
Information Server) running Tomcat for the JSPs.

Ivo

"Stephen Zeng" <chinafax1@cmmail.com> wrote in message
news:3aac6c5a_2@dnews...
> I have print button in my JSP, when I click the print button, I want to
open
> excel template and insert some data in it and print the excel file?  How
to
> do this?
>
> Can ActiveX do that and how?
>
> Thanks a lot!
>
> Stephen
>
>

Technical Details

Message-ID: <98huj5$eae$1@porthos.nl.uu.net>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sf.pbi.net!63.208.208.143!feed2.onemain.com!feed1.onemain.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.esat.net!newsfeed2.news.nl.uu.net!sun4nl!reader1.news.nl.uu.net!not-for-mail

References: <3aac6c5a_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f74b3,174dbcbd26fe19a4
X-Google-Attributes: gidf74b3,public
X-Google-ArrivalTime: 2001-03-11 23:42:08 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sf.pbi.net!63.208.208.143!feed2.onemain.com!feed1.onemain.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.esat.net!newsfeed2.news.nl.uu.net!sun4nl!reader1.news.nl.uu.net!not-for-mail
From: "Ivo B. Limmen" <limmen@furore.nl>
Newsgroups: borland.public.jbuilder.java.language
Subject: Re: open excel template and insert data by click button from JSP
Date: Mon, 12 Mar 2001 08:40:23 +0100
Organization: UUNET-NL (http://www.nl.uu.net)
Lines: 36
Message-ID: <98huj5$eae$1@porthos.nl.uu.net>
References: <3aac6c5a_2@dnews>
NNTP-Posting-Host: 1cust142.tnt2.rtm1.nl.uu.net
X-Trace: porthos.nl.uu.net 984382884 14670 213.116.98.142 (12 Mar 2001 07:41:25 GMT)
X-Complaints-To: abuse@nl.uu.net
NNTP-Posting-Date: 12 Mar 2001 07:41:25 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400

Reply to Parent Message