Forums Register Login

Problem in downloading Excel

+Pie Number of slices to send: Send
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 ]
+Pie Number of slices to send: Send
You're doing this from a JSP? Big mistake. Huge. Use a servlet instead. JSPs are intended for delivering text data, not binary.
+Pie Number of slices to send: Send
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 ]
This tiny ad is guaranteed to be gluten free.
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1524 times.
Similar Threads
Problem executing SQL in SERVLET.
Problem while opening excel sheet from jsp
Problem while inserting data into MS SQL table
HttpUrlConnection - cXML PunchOutSetupRequest
Problems with java and mysql error: 1064
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 06:32:28.