GeeCON Prague 2014*
The moose likes Servlets and the fly likes Viewing data from database into an xls format not working Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Servlets
Bookmark "Viewing data from database into an xls format not working" Watch "Viewing data from database into an xls format not working" New topic
Author

Viewing data from database into an xls format not working

Jeff Foflygen
Greenhorn

Joined: Mar 12, 2009
Posts: 12
Hi,

I am wondering if anybody could take a look at this code and tell me if they see why my application/vnd.ms-excel is not opening. I am getting no blatant errors in the code, the only thing that is concerning me is in certain bits of the code I get "Note: This element has no attached source and the Javadoc could not be found in the attached Javadoc." for example, the setContentType("application/vnd.ms-excel"); says that note. below is the code. please help, or any suggestions are welcomed!
ujjwal soni
Ranch Hand

Joined: Mar 28, 2007
Posts: 403
Hi,

Try doing this.




Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+919909981973>
"Helping hands are better than praying lips......"
Jeff Foflygen
Greenhorn

Joined: Mar 12, 2009
Posts: 12
Hi,

I put the code in place that you suggested, no errors. Tomcat is installed and running. I go to launch and it does nothing, no errors, warnings, no succeeded, etc.... do I need to put in more code? it should just find the default excel and launch, correct?

thanks!
ujjwal soni
Ranch Hand

Joined: Mar 28, 2007
Posts: 403
Hi,

No, you dont need to put this in other code. It must open the download window as reponse. Why dont you try to execute it in mozilla firefox or google chrome ? because sometimes some browsers have popup blocker that blocks the download popup.

Cheers,
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42061
    
  64
The browser may be set to save XLS documents automatically without prompting the user - in which case it would show up in whatever directory is set as the default download directory.


Ping & DNS - my free Android networking tools app
 
GeeCON Prague 2014
 
subject: Viewing data from database into an xls format not working