• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Problem in downloading Excel

 
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
reply
    Bookmark Topic Watch Topic
  • New Topic