返回小数，而不是字符串（POI JAR） [英] returning decimal instead of string (POI jar)

问题描述

我需要阅读XLS或XLSX表。
成功我读了表，但它的字符串，而不是返回十进制值（例如：3 - 它返回3.0）。
我需要阅读的单元格的值，因为它是。
所以我需要返回字符串为

I need to read xls or xlsx sheet. successfully I read the sheet, but it returning decimal value instead of string (eg: for 3 -- it is returning 3.0). I need to read the cell values as it is. so I need to return as string

推荐答案

POI是给你准确的值，Excel中已存储在文件。一般来说，如果你在Excel单元格中写一个数字，Excel将存储与格式的数字。 POI提供支持做格式化你，如果你想它（多数人不 - 他们想要的号码为数字，使他们能够使用它们）

POI is giving you the exact value that Excel has stored in the File. Generally, if you write a number in an Excel cell, Excel will store that as a number with formatting. POI provides support to do that formatting for you if you want it (most people don't - they want the numbers as numbers so they can use them)

您正在寻找的类是 DataFormatter 。您code会是这样

The class you're looking for is DataFormatter. Your code would be something like

 DataFormatter fmt = new DataFormatter();
 for (Row r : sheet) {
    for (Cell c : r) {
       CellReference cr = new CellRefence(c);
       System.out.println("Cell " + cr.formatAsString() + " is " + 
                          fmt.formatCellValue(c) );
    }
 }

这篇关于返回小数，而不是字符串（POI JAR）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！