poi 取消科学计数法

[size=medium;]<br>[/size]


<p style="color: #333333; line-height: 26px; text-align: left; padding-top: 0px; padding-bottom: 0px;"><span>[size=medium;]?[/size]</span>

<p style="color: #333333; line-height: 26px; text-align: left; padding-top: 0px; padding-bottom: 0px;"><span>[size=medium;]1.利用String.format()[/size]</span>

<p style="color: #333333; line-height: 26px; text-align: left; padding-top: 0px; padding-bottom: 0px;">[b]<span style="color: #ff0000;"><span>[size=medium;]String.format("%.0f", row.getCell(0).getNumericCellValue())//15145117218，取整！[/size]</span></span>[/b]

<p style="color: #333333; line-height: 26px; text-align: left; padding-top: 0px; padding-bottom: 0px;"><span>[size=medium;]2.利用DecimalFormat类[/size]</span>

<p style="line-height: 26px; text-align: left; padding-top: 0px; padding-bottom: 0px;"><span style="color: #ff0000;"><span>[size=medium;]saleUnilateImport.setPhone(df.format(row.getCell(1).getNumericCellValue()));[/size]</span></span>

<p style="color: #333333; line-height: 26px; text-align: left; padding-top: 0px; padding-bottom: 0px;"><span>[size=medium;]3.利用DecimalFormat类[/size]</span>

<p style="line-height: 26px; text-align: left; padding-top: 0px; padding-bottom: 0px;"><span><span style="color: #ff0000;">[size=medium;]saleUnilateImport.setPhone(df.format(row.getCell(1).getNumericCellValue()));[/size]</span></span>