This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem in downloading Excel  RSS feed

 
priya pratheepp
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi friends

when i try to download data from MySQL to excel sheet I am getting error of

This file is not in a recognizable format.


. If you know the file is from another program which is incompatible with Microsoft Office Excel,click Cancel then open this file in its original application.If you want to open the file later in Microsoft Office Excel,save it in a format that is compatible,such as text format.

etc

Code is

I can open them after clicking OK, but before that it is showing the above error message

thank you

[ April 02, 2008: Message edited by: priya pratheepp ]


[BSouther: Added UBB CODE tags]
[ April 03, 2008: Message edited by: Ben Souther ]
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 66184
146
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You're doing this from a JSP? Big mistake. Huge. Use a servlet instead. JSPs are intended for delivering text data, not binary.
 
TRAN THO
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

You should replace "\t" by ","
And in end of phase you add code such as:

And code program:


[ April 07, 2008: Message edited by: TRAN THO ]

[ UD: fixed CODE tags ]
[ April 07, 2008: Message edited by: Ulf Dittmer ]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!