This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Servlets and the fly likes Reading the excel file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Reading the excel file" Watch "Reading the excel file" New topic
Author

Reading the excel file

sunitha reghu
Ranch Hand

Joined: Dec 12, 2002
Posts: 937
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30057
    
149

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
sunitha reghu
Ranch Hand

Joined: Dec 12, 2002
Posts: 937
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
 
subject: Reading the excel file
 
Similar Threads
Read a .xls,.xlsx file format using XSSF
Problem in reading Numeric value as String fom Excel file using Apache POI
How can I analize Excel file with Apache POI?
The system cannot find the path specified
NullPointerException