Re: Export to Excel spread Sheet

2002-03-25 Thread Chanh Le 

For the opposite direction, can we transfer data from Exel spreadsheet to table rows?

Thanks,
CL







"Raghupathy, Gurumoorthy" <[EMAIL PROTECTED]>
Sent by: "A mailing list for discussion about Sun Microsystem's Java               Servlet API Technology." <[EMAIL PROTECTED]>
03/22/2002 01:32 AM
Please respond to "A mailing list for discussion about Sun Microsystem's Java               Servlet API Technology."        

        
        To:        [EMAIL PROTECTED]
        cc:        
        Subject:        Re: Export to Excel spread Sheet


simple,
            
           response.setContentType("application/vnd.ms-excel");
           
        then column seperator is \t ( td /td in html )
        then the row seperator is \n ( tr /tr in html )


guru

    
        
-Original Message-
From: tejas patel [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 19:49
To: [EMAIL PROTECTED]
Subject: Export to Excel spread Sheet


Hi all,
any one knows how to transfer data to excel spread sheet. Basically, My
servlet connect to database and display all data in Table in HTML. later on
I want to transfer all data to excel spread sheet. any example ...
thanks
tejas




Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®

___
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Re: Export to Excel spread Sheet

2002-03-22 Thread Raghupathy, Gurumoorthy 

simple,

   response.setContentType("application/vnd.ms-excel");
   
then column seperator is \t ( td /td in html )
then the row seperator is \n ( tr /tr in html )


guru



-Original Message-
From: tejas patel [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 19:49
To: [EMAIL PROTECTED]
Subject: Export to Excel spread Sheet


Hi all,
any one knows how to transfer data to excel spread sheet. Basically, My
servlet connect to database and display all data in Table in HTML. later on
I want to transfer all data to excel spread sheet. any example ...
thanks
tejas




Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®

___
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Re: Export to Excel spread Sheet

2002-03-21 Thread Richard Yee 

Tejas,
This question has been answered in the past. Check the archives.

-Richard

At 11:49 AM 3/21/2002 -0800, you wrote:

>Hi all,
>
>any one knows how to transfer data to excel spread sheet. Basically, My 
>servlet connect to database and display all data in Table in HTML. later 
>on I want to transfer all data to excel spread sheet. any example ...
>
>thanks
>
>tejas
>
>
>
>Do You Yahoo!?
>Yahoo! Movies - coverage of the 74th Academy Awards®

___
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Re: Export to Excel spread Sheet

2002-03-21 Thread Dahnke, Eric 



Yes. 
Post to the exact same page but set header values like:
 
Content-Type: application/vnd.ms-excel; 
name='excel'Content-Disposition: attachment; 
filename=filename.xls
With 
this in the http headers your browser will automatically open Excel. And the 
final trick is that Excel can read html tables. (Hopefully there is nothing 
else on your page but the html table)
 
HTH
 

  -Original Message-From: tejas patel 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, March 21, 2002 2:49 
  PMTo: [EMAIL PROTECTED]Subject: Export to 
  Excel spread Sheet
  Hi all,
  any one knows how to transfer data to excel spread sheet. Basically, My 
  servlet connect to database and display all data in Table in HTML. later on I 
  want to transfer all data to excel spread sheet. any example ...
  thanks
  tejas
  
  
  Do You Yahoo!?Yahoo! 
  Movies - coverage of the 74th Academy Awards®