How to store excel numeric as string

Question

How can i set numeric number from excel to string type? as i want to show 0001 instead of 1 in system. Below are part of the detect excel cell type function. How should i modify it ?

switch (cell.getCellType()) {
        case HSSFCell.CELL_TYPE_NUMERIC:
            if (DateUtil.isCellDateFormatted(cell)) {
                SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
                value = dateFormat.format(cell.getDateCellValue());
            } 
            else 
            {
                double value2 = cell.getNumericCellValue();
                if( Math.floor(value2) == value2 ) 
                {
                    int value3 = (int)value2;
                    value = ""+value3;
                }else{
                    value = String.valueOf(value2);
                }
            }
            break;
        case HSSFCell.CELL_TYPE_STRING:
            value = cell.getStringCellValue();
            break;
        case HSSFCell.CELL_TYPE_FORMULA:     
            if(cell.getCachedFormulaResultType()==HSSFCell.CELL_TYPE_NUMERIC)
            {
                double value2 = cell.getNumericCellValue();
                if( Math.floor(value2) == value2 ) 
                {
                    int value3 = (int)value2;
                    value = ""+value3;
                }else{
                    value = String.valueOf(value2);
                }                                       
            }else if(cell.getCachedFormulaResultType()==HSSFCell.CELL_TYPE_STRING){
                value = cell.getStringCellValue();
            }   
            break;      
        case HSSFCell.CELL_TYPE_BLANK:   
            value = "";
            break;                      
        }   
    }

When you say "store excel numeric as string", do you actually mean "get cell value as text, formatted as Excel displays it"? — Andreas, Aug 19 '15 at 02:22
possible duplicate of [Cannot get a text value from a numeric cell “Poi”](http://stackoverflow.com/questions/30125465/cannot-get-a-text-value-from-a-numeric-cell-poi) — Andreas, Aug 19 '15 at 02:26

newuser · Answer 1 · 2015-08-19T02:09:31.197

0

Thilo gave the easiest way to do this,

String.format("%04d", 1);

Use LongValidator to achieve the same by third party library.

LongValidator longValidator = new LongValidator();
String result = longValidator.format(1, "0000");

edited Aug 19 '15 at 02:09

answered Aug 19 '15 at 02:01

newuser

8,338
2
25
33

Or just `String.format("%04d", 1);` No need for external libraries. – Thilo Aug 19 '15 at 02:02
The way i store my value to database, pstmt2.setString(16,(String)VrtSub.elementAt(16)); – user3835327 Aug 19 '15 at 02:09
I failed to set this.. error on console... pstmt2.setString(16,String.format("%04d",vrtSub.elementAt(16))); – user3835327 Aug 19 '15 at 02:12
what is the exact result of the statement, pstmt2.setString(16,(String)VrtSub.elementAt(16)); – newuser Aug 19 '15 at 02:13
i system out VrtSub = 2 supposely 0002. – user3835327 Aug 19 '15 at 02:14
what is the meaning of 16 in the setString – newuser Aug 19 '15 at 02:17

How to store excel numeric as string

1 Answers1