Home > Back-end >  Java poi Excel operation
Java poi Excel operation

Time:01-09

Work a cell in the table format is numeric types, but the content in the cell is signed with English (such as 54 - aaaa), now can only use getNumericCellValue values () method, take the value is a decimal, so now use what way to take to the value "54 - aaaa"????? Big help!!!!!!!!!!

CodePudding user response:

Unified with String values, to take the same String, again to String handling
 cell. SetCellType (cell. CELL_TYPE_STRING); 
Cell. GetStringCellValue ()

CodePudding user response:

Junction post rate is a little low

CodePudding user response:

references a 1/f, trying to fly fish reply:
unified with String values, you can pick up to the same String, then the String handling
 cell. SetCellType (cell. CELL_TYPE_STRING); 
Cell. GetStringCellValue ()
this way out of a decimal

CodePudding user response:

Unified with String values, can take to the same String, and then the String handling
.

CodePudding user response:

Unified with String values, you can take to the same String, again to String processing
  • Related