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
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: 9622
    
    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: 9622
    
    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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Writing query results to an Excel sheet