Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Copying text data from excel sheet  RSS feed

 
Rajat Raina
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to copy paste some data from an excel sheet to a text area in jsp page and storing it to database but it is not reading the special characters when i next time retrive it from database and display it on the page instead it shows a ? instead of the character.
e.g. i input "JAVA" bt next time i retrive it is shows ?JAVA?
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Which character code is used for those double quotes?

How are you handling encoding in the web app and the DB?
 
Rajat Raina
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you sure this is a problem of encoding because the problem is strange: if i write in text box it takes quotes and other special characters also but not when i copy the data from an excel sheet to the text box.
and which tag is used for encding in web.xml.
 
Rajat Raina
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This problem is particularly when i am saving the file in Office 2007 format while its working fine if i store it in 2003 format.
Please help......
 
ujjwal soni
Ranch Hand
Posts: 405
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Try using JXL API for copying/generating excel sheets using java. It supports MS EXCEL 2007 sheets.

Java Excel API - A Java API to read, write, and modify Excel spreadsheets. JExcelApi ...
jexcelapi.sourceforge.net/

Cheers!!!

Ujjwal B Soni
<baroda>
<gujarat>
<india>
<919998971048>
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!