java 读取excel表格内容出现小数_Java读取excel小数点的问题

使用Java读取excel的时候，小数自动转为为不精确的小数点了。

读取excel的代码

public static List readExcel(File file) throws Exception {

//初始化结果集

List dataList = new ArrayList();

//获得Workbook工作薄对象

Workbook workbook = getWorkBook(file);

if (workbook == null)

throw new Exception("读取excel数据失败，workbook build null。");

for (int sheetNum = 0; sheetNum < workbook.getNumberOfSheets(); sheetNum++) {

//获得当前sheet工作表

Sheet sheet = workbook.getSheetAt(sheetNum);

if (sheet == null)

continue;

if (sheet.getNumMergedRegions() > 0)

setSheetMergedRegionsValue(sheet);

//获得当前sheet的开始行

int firstRowNum = sheet.getFirstRowNum();

//获得当前sheet的结束行

int lastRowNum = sheet.getLastRowNum();

//循环所有行

for (int rowNum = firstRowNum; rowNum