Women in Technology

Hear us Roar



Article:
  Reading and Writing Excel Files with POI
Subject:   Always Read Excel Data as a String
Date:   2008-04-28 14:32:33
From:   gyleg5
I need to take an excel workbook and turn it into a delimited text file. The only problem is some of the data are numbers that start with leading 00's. When I create a workbook, these cells that are 00431 become 431.0 since they are treated as numbers. I was wondering if there was a way to force all the cells to be read as strings. Keep in mind I have no control over how I receive the spreadsheet and would like to eliminate the step of having to go into the spreadsheet and manually format columns. Thanks.