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. | ||
Women in Technology
Hear us Roar
