File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reading the excel file

 
sunitha reghu
Ranch Hand
Posts: 937
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using hssf to read an excel which users uploading to a servlet.
The problem is that it can not read the SSN . So i made ssn as text. But i already have name as text. I am geteting ssn and anem as text. My que how to take ssn out frm that.
I pasting the portion of the code.


The name of the employee is coming up with ssn and the name.
Can anyone help me??
[ November 17, 2003: Message edited by: sunitha raghu ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33696
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you saying that SSN and name are in the same cell? If so, you would get the whole cell as text and parse it.
 
sunitha reghu
Ranch Hand
Posts: 937
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No ssn and name are in diff cell.
so both are getting are string values.
i solved that using regular expression.
but if some enters ssn with hyphen then it will be problem
then i will get that in name field. so have to find some way for that.
Originally posted by Jeanne Boyarsky:
Are you saying that SSN and name are in the same cell? If so, you would get the whole cell as text and parse it.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic