If I use the default format of the cell(Standard) and type 'FALSE' in this cell, then I get the value 'false' in the cell by using formatCellValue method. Actually, I hope that I can get the value 'FALSE', not lowercase 'false'.
Could I achieve this by using DataFormatter? On 2016-08-19 10:48 (+0800), "Javen O'Neal" <javenon...@gmail.com> wrote: > Yes. DataFormatter does what you want: get the string representation of the > cell contents (numeric, date, string, boolean, blank, error, formula) > > On Aug 18, 2016 18:54, "é æ¨é³" <niaomingj...@outlook.com> wrote: > > > Actually, I want to get the value in cells and change them to String in > > Java.(numeric -> String, string -> String, and so on). > > Sometimes, I'm not sure what CellType it is. So I want to know the > > CellType at first, and then I can convert them to String. > > > > As you said, I can directly use DataFormatter to convert the cell value to > > a printed String. The printed String is what I want. Am I correct? > > > > > -----å ã®ã¡ãã»ã¼ã¸----- > > > å·®åºäºº: Javen O'Neal [mailto:javenon...@gmail.com] > > > éä¿¡æ¥æ: 2016å¹´8æ12æ¥ 23:35 > > > å®å : POI Users List <user@poi.apache.org> > > > 件å: Re: The CellType of a cell which is set to String > > > > > > To see how Excel actually saved the values, unzip the xlsx file and open > > > sheet1.xml. You should see a couple <c> elements, with a value and type. > > > > > > On Aug 12, 2016 8:32 AM, wrote: > > > > > > The cell data format is a distinct concept from the cell value. The > > format only > > > defines how the value should be printed, but doesn't change the > > underlying value. > > > > > > If you want to convert the cell value to a printed string, use > > > https://poi.apache.org/apidocs/org/apache/poi/ss/ > > usermodel/DataFormatter.ht > > > ml > > > > > > On Aug 12, 2016 2:59 AM, "niaomingj...@outlook.com" < > > niaomingj...@outlook.com> > > > wrote: > > > > > > Hi > > > > > > In a excel, > > > Firstly, I typed '1' in A1, then I changed the format of this cell to > > String. > > > Secondly, I changed the format of A2 to Standard(the default format), > > then I > > > typed '1' in this cell. > > > Finally, I saved this excel. > > > > > > This is my excel file for test. > > > Iâm using poi 3.14. > > > My source is very simple, as following: > > > ================================================ > > > File file = new File("1.xlsx"); > > > > > > Workbook wb = WorkbookFactory.create(file); > > > > > > Sheet sheet = wb.getSheetAt(0); > > > > > > System.out.println(sheet.getRow(0).getCell(0).getCellType()); > > > System.out.println(sheet.getRow(1).getCell(0).getCellType()); > > > > > > wb.close(); > > > ================================================ > > > > > > output: > > > ============ > > > 0 > > > 1 > > > ============ > > > > > > The result shows that A1's type is CELL_TYPE_NUMERIC, and A2's type is > > > CELL_TYPE_STRING. > > > > > > Though I set both cells to String, the results are different. > > > > > > In addition, in this excel, the appearance of these two cells are also > > different. > > > There is a green triangle at the top-right corner of A2. > > > > > > Could anyone explain this for me? > > > > > > Regards, > > > Young > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional > > > commands, e-mail: user-h...@poi.apache.org > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > > For additional commands, e-mail: user-h...@poi.apache.org > > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
