blocks|key|2555182|text|将cell+type设置为：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2555183|HSSFRow+row+=+sheet.createRow(sheet.getLastRowNum());
HSSFCell+cell+=+row.createCell(0);
cell.setCellType(Cell.CELL_TYPE_STRING);
cell.setCellType(Cell.CELL_TYPE_NUMERIC);|code-block|syntax|javascript|2555184|对于字母数字和Character单元类型，数字类型为Cell.CELL_TYPE_STRING，单元类型为CELL_TYPE_NUMERIC。|2555185|您可以从单元格和HSSFCell文档中获得更多关于单元格类型的信息。|2555186|entityMap|0|LINK|mutability|MUTABLE|url|https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Cell.html|1|http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFCell.html^0|1|9|0|0|7|9|Q|L|1H|H|0|4|3|0|8|8|1|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|12|8|@$9|13|A|14|B|C]|$9|15|A|16|B|C]|$9|17|A|18|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|19|8|@]|D|@$9|1A|A|1B|1|1C]|$9|1D|A|1E|1|1F]]|E|$]]|$1|O|3|-4|5|6|7|1G|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]|W|$5|R|S|T|E|$U|X]]]]

Set the <code>cell type</code> like :

<pre><code>HSSFRow row = sheet.createRow(sheet.getLastRowNum());
HSSFCell cell = row.createCell(0);
cell.setCellType(Cell.CELL_TYPE_STRING);
cell.setCellType(Cell.CELL_TYPE_NUMERIC);
</code></pre>

For alphanumeric and <code>Character</code> cell type will be <code>Cell.CELL_TYPE_STRING</code> for number, cell type will be <code>CELL_TYPE_NUMERIC</code>

You can get more on cell type from <a href="https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Cell.html" rel="nofollow">Cell</a> and <a href="http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFCell.html" rel="nofollow">HSSFCell</a> documentation.

blocks|key|1560995|text|旧的，但这仍然会帮助一些从.NET使用NPOI的人。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1560996|我试过|1560997|cell.SetCellType(NPOI.SS.UserModel.CellType.NUMERIC);+|code-block|syntax|javascript|1560998|根本帮不上忙。但是下面的代码会起作用|1560999|dCell.setCellValue(Convert.ToDouble(112.45));+//.NET+syntax

dCell.setCellValue(new+Double("123"));++//+Java+Syntax|1561000|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Old one But Still it This will help Some one from .NET who use NPOI

I tried with 

<pre><code>cell.SetCellType(NPOI.SS.UserModel.CellType.NUMERIC); 
</code></pre>

which didn't helped at all. but the below code will work

<pre><code>dCell.setCellValue(Convert.ToDouble(112.45)); //.NET syntax

dCell.setCellValue(new Double("123")); // Java Syntax
</code></pre>

blocks|key|2278867|text|我也面临着同样的问题。我通过检查数据(如果是整数/浮点数)并相应地放置条件(CELL_TYPE)来解决这个问题。请找到代码片段：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2278868|if(!isInteger(data))
++++++++++++{
++++++++++++cell.setCellValue(data);
++++++++++++}
++++++++++++else
++++++++++++{
++++++++++++++++cell.setCellType(Cell.CELL_TYPE_NUMERIC);
++++++++++++++++cell.setCellValue(Float.parseFloat(data));//.parseInt(data));+++
++++++++++++}
public+static+boolean+isInteger(String+s)+{
++++try+{+
++++++++java.lang.Float.parseFloat(s);+
++++}+catch(NumberFormatException+e)+{+
++++++++return+false;+
++++}
++++return+true;
}|code-block|syntax|javascript|2278869|这里的数据是来自数据源(excel/csv)的列表数组中的字符串，这解决了绿色警告。|2278870|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I was facing the same issue. I resolved it through checking the data if it is an Integer/Float and putting the condition(CELL_TYPE) accordingly. Please find the code Snippet:

<pre><code>if(!isInteger(data))
 {
 cell.setCellValue(data);
 }
 else
 {
 cell.setCellType(Cell.CELL_TYPE_NUMERIC);
 cell.setCellValue(Float.parseFloat(data));//.parseInt(data)); 
 }
public static boolean isInteger(String s) {
 try { 
 java.lang.Float.parseFloat(s); 
 } catch(NumberFormatException e) { 
 return false; 
 }
 return true;
}
</code></pre>

Here data is a String from the array of list from the data source(excel/csv)
This resolved the green warning.

blocks|key|2555273|text|显然，这在Apache中目前是不可能的。有许多关于这一问题的错误报告/RFE：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2555274|bug.cgi?id=58641|offset|length|2555275|bug.cgi?id=54868|2555276|bug.cgi?id=46136|2555277|实际属性(表示忽略此类警告的属性)以Excel持久格式存在，并按每个单元格记录。据我所知，从bug报告中可以看出，Apache并没有公开它。|2555278|为了让您了解Excel的xlsx格式是什么样子：|2555279|</worksheet>
++++...
++++<ignoredErrors>
++++++++<ignoredError+sqref="K192+E181+E186"+numberStoredAsText="1"/>
++++</ignoredErrors>++++
</worksheet>|code-block|syntax|javascript|2555280|我在某些地方读到，这只在xlsx+(即OOXML)中持久存在，而不是以xls格式保存，这意味着如果Apache团队实现这一点，它将位于XSSF包中。|style|CODE|2555281|entityMap|0|LINK|mutability|MUTABLE|url|https://issues.apache.org/bugzilla/show_bug.cgi?id=58641|1|https://issues.apache.org/bugzilla/show_bug.cgi?id=54868|2|https://issues.apache.org/bugzilla/show_bug.cgi?id=46136^0|0|0|G|0|0|0|G|1|0|0|G|2|0|0|0|0|C|4|Z|3|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@]|9|@$D|1A|E|1B|1|1C]]|A|$]]|$1|F|3|G|5|6|7|1D|8|@]|9|@$D|1E|E|1F|1|1G]]|A|$]]|$1|H|3|I|5|6|7|1H|8|@]|9|@$D|1I|E|1J|1|1K]]|A|$]]|$1|J|3|K|5|6|7|1L|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1M|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|1N|8|@]|9|@]|A|$Q|R]]|$1|S|3|T|5|6|7|1O|8|@$D|1P|E|1Q|U|V]|$D|1R|E|1S|U|V]]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]|14|$5|Z|10|11|A|$12|15]]|16|$5|Z|10|11|A|$12|17]]]]

Apparently this is not currently possible with Apache POI. There are a number of bug reports / RFEs on the subject:

<a href="https://issues.apache.org/bugzilla/show_bug.cgi?id=58641" rel="nofollow">https://issues.apache.org/bugzilla/show_bug.cgi?id=58641</a>

<a href="https://issues.apache.org/bugzilla/show_bug.cgi?id=54868" rel="nofollow">https://issues.apache.org/bugzilla/show_bug.cgi?id=54868</a>

<a href="https://issues.apache.org/bugzilla/show_bug.cgi?id=46136" rel="nofollow">https://issues.apache.org/bugzilla/show_bug.cgi?id=46136</a>

The actual attribute (the attribute that says to ignore such warning) exists in the Excel persistent format and is recorded on a per cell basis. It is just that Apache POI doesn't expose it, as far as I can tell from the bug reports.

To give you an idea of what this looks like in Excel's xlsx format:

<pre><code>&lt;/worksheet&gt;
 ...
 &lt;ignoredErrors&gt;
 &lt;ignoredError sqref="K192 E181 E186" numberStoredAsText="1"/&gt;
 &lt;/ignoredErrors&gt; 
&lt;/worksheet&gt;
</code></pre>

I've read somewhere that this is persisted only in <code>xlsx</code> (i.e. OOXML), not in <code>xls</code> format which means that if and when the Apache POI team implements this it will be in the XSSF package.

blocks|key|2555294|text|API现在提供了一个相应的方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2555295|public+void+addIgnoredErrors(CellRangeAddress+region,
++++++++++++++++++++IgnoredErrorType...+ignoredErrorTypes)|code-block|syntax|javascript|2555296|entityMap|0|LINK|mutability|MUTABLE|url|https://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html#addIgnoredErrors(org.apache.poi.ss.util.CellRangeAddress,%2520org.apache.poi.ss.usermodel.IgnoredErrorType...)^0|0|G|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

<a href="https://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html#addIgnoredErrors(org.apache.poi.ss.util.CellRangeAddress,%20org.apache.poi.ss.usermodel.IgnoredErrorType...)" rel="noreferrer">The API now provides a corresponding method</a>

<pre><code>public void addIgnoredErrors(CellRangeAddress region,
 IgnoredErrorType... ignoredErrorTypes)
</code></pre>

blocks|key|2278951|text|对我来说，上面的解决方案都不起作用，但最后还是用了一些复杂的方法来消除警告:将这些值写成这样的公式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2278952|String+asFormula+=+"\""+%2B+value+%2B+"\"";
cell.setCellType(SXSSFCell.CELL_TYPE_FORMULA);
cell.setCellFormula(asFormula);|code-block|syntax|javascript|2278953|不要认为它总是一个好的解决方案，但在我的例子中，输出文件的值从未被修改过。但它可能会对某人有帮助。|2278954|我正在使用apache的3.14版本，以防它会产生影响(在解决之前，我已经尝试过几个不同的版本，但没有效果)。|2278955|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

For me, none of the solutions above worked, but at the end got rid of the warnings with a bit convoluted workaround: writting the values as formulas like this.

<pre><code>String asFormula = "\"" + value + "\"";
cell.setCellType(SXSSFCell.CELL_TYPE_FORMULA);
cell.setCellFormula(asFormula);
</code></pre>

Don't think it is always a good solution, but in my case the values of the output file are never modified. But it might help somebody.

I'm using version 3.14 of apache POI, in case it makes a difference (I've tried a few different versions before the workaround, with no effect).

blocks|key|2555332|text|我知道这个问题被问了很久了，但是.你试过这个吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2555333|DataFormat+df+=+workbook.createDataFormat();
cellStyle.setDataFormat(df.getFormat("@"));|code-block|syntax|javascript|2555334|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I know it has been a long time since the question was asked, but still...
Did you try this:

<pre><code>DataFormat df = workbook.createDataFormat();
cellStyle.setDataFormat(df.getFormat("@"));
</code></pre>

blocks|key|2555336|text|很老但仍然相关。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2555337|你应该用“。”在文本中作为十进制分隔符，并将单元格格式化为数字。|2555338|同时使用DataFormat和de模式"#.00“和”瞧！“没有警告，一切都很好。|2555339|cell.setCellType(Cell.CELL_TYPE_NUMERIC);
cell.setCellValue(Double.parseDouble(data));
DataFormat+format+=+hwb.createDataFormat();
CellStyle+numbercellStyle+=+hwb.createCellStyle();
numbercellStyle.setDataFormat(format.getFormat("#.00"));
cell.setCellStyle(numbercellStyle);|code-block|syntax|javascript|2555340|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Old but still relevant. 

You should use "." in text as decimal separator and to format cell as NUMERIC.

Use also DataFormat with de pattern "#.00" and voila! No warning and everything gones fine. 

<pre><code>cell.setCellType(Cell.CELL_TYPE_NUMERIC);
cell.setCellValue(Double.parseDouble(data));
DataFormat format = hwb.createDataFormat();
CellStyle numbercellStyle = hwb.createCellStyle();
numbercellStyle.setDataFormat(format.getFormat("#.00"));
cell.setCellStyle(numbercellStyle);
</code></pre>

blocks|key|2555349|text|简单来说，您还可以在poi+4.1.1中使用下面的代码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2555350|cell.setCellValue(Double.parseDouble(yourvalue))；|2555351|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Simple, You can also use below code in poi 4.1.1

cell.setCellValue(Double.parseDouble(yourvalue));

I am using <code>apache poi api</code> to generate Excel sheet in my application in java. Data that are set in excel are coming dynamically with type string. For column1, values are alphanumeric. When I generate Excel, it will give me green indication with warning "Number Stored as Text" or "Text date with 2-digit year" on cell.

I want to remove that warning.
I found that from excel we can flag a cell as 'ignore error', to ignore the warning.

How to do it programmatically or is there any other alternative to achieve this task ?

I also have attached screenshot that shows warning with green mark.

<img src="https://i.stack.imgur.com/BpbfW.png" alt="enter image description here">

Code : 

<pre><code>if (cellValue != null &amp;&amp; (shouldBeRightAlign))
{
 cellType = Cell.CELL_TYPE_NUMERIC;
}
else if (cellValue != null)
{
 cellType = Cell.CELL_TYPE_STRING;
}
cell.setCellValue(cellValue);
</code></pre>

How to remove warning in Excel using apache poi in JAVA?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在使用apache poi api在我的java应用程序中生成Excel表。excel中设置的数据是以string类型动态出现的。表示column1，值为字母数字。当我生成Excel时，它会给我绿色的指示，上面有警告“数字存储为文本”或“文本日期，在单元格上有2位数的年份”“。我想移除那个警告。我发现，在excel...

问如何在Excel中使用JAVA中的apache删除警告？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Excel中使用JAVA中的apache删除警告？EN