https://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/usermodel/DataFormatter.java?revision=1753122&view=markup#l897
Looks like it isn't being uppercased. String.valueOf(false) -> "false" Do you want to open a bug at https://bz.apache.org/bugzilla and submit a patch with a unit test? On Fri, Aug 19, 2016 at 12:01 AM, Young <niaomingj...@outlook.com> wrote: > 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 > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
