It's not a secret anymore!*
The moose likes JDBC and the fly likes Writing query results to an Excel sheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Writing query results to an Excel sheet" Watch "Writing query results to an Excel sheet" New topic
Author

Writing query results to an Excel sheet

Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9345
    
    2

Guys,

I'm writing the results of a query to an Excel sheet and what I have in my tables are encoded form of some chineese characters. So when I do it, I'm not able to decode those chineese characters and print in the excel sheet but instead I'm getting the same encoded value as it is from the database. Please help me on this.


SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!
Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9345
    
    2

Exactly here is what I want,

Through my JSP, I store some chineese names in my Oracle database. The chineese letters gets stored in an encoded form. Now I want to generate a xls report where I just run a query with a java helper class and write the output to a xls. Now in the xls, I'm just getting the encoded form but I'm not able to get the chineese letters back. Please help me!
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
Which character set is supported by your database installation? It is stored in the NLS_PARAMETER table.

Select NLS_CHARACTERSET From NLS_PARAMETER
 
Don't get me started about those stupid light bulbs.
 
subject: Writing query results to an Excel sheet
 
Similar Threads
Character decoding in Java
Writing chineese characters to a txt file
write and read Excel File
How to export Non-English Data from jsp file to excel file
Transfer Excel Sheet information to database