blocks|key|1105687|text|您可能会考虑从纵向切换到横向(换句话说，调换数据)，这样您就可以在一年中的每一天使用65k行。这正是我对一个需要大量列和少量行的报告所做的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1105688|或者，您可以将一年分成6个月的子期间，每个子期间都有自己的工作表。|1105689|这些都是权宜之计，但根据您的需求，可能会为您提供一个“足够好”的解决方案。|1105690|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

You might consider switching from portrait to landscape (in other words, transposing the data) so that you get to use 65k rows for days of the year. This is exactly what I did with a report requiring a large number of columns and small number of rows.

Alternatively, you might split the year in 6-month sub periods, each one on its own sheet.

These are both stopgap solutions, but might provide you with a "good enough" solution, depending on the requirements you have.&nbsp;

blocks|key|1105707|text|您的问题可能出在Excel，而不是您的API。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1105708|The+maximum+number+of+columns+in+a+pre-Excel+2007+spreadsheet+is+256。|offset|length|1105709|entityMap|0|LINK|mutability|MUTABLE|url|http://office.microsoft.com/en-us/excel/HA101375451033.aspx^0|0|0|1W|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Your problem may be with Excel, not your API.

<a href="http://office.microsoft.com/en-us/excel/HA101375451033.aspx" rel="noreferrer">The maximum number of columns in a pre-Excel 2007 spreadsheet is 256</a>.

blocks|key|1320714|text|这是因为Excel的列数有限，请查看以下内容：http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1320715|entityMap|0|LINK|mutability|MUTABLE|url|http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx^0|N|2L|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

That's because Excel has limited number columns
See this: <a href="http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx" rel="nofollow">http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx</a>

blocks|key|1105818|text|2007年前的excel表格有256列的限制。这些工作表还会生成".xls“扩展名。Excel2007和更高版本可以容纳16K列，都是基于XML格式并生成".xlsx“格式。2007年之前的工作表的POI对象模型是org.apache.poi.hssf.usermodel，而2007年以后的工作表的对象模型是org.apache.poi.xssf.usermodel，package+org.apache.poi.ss.usermodel提供了涵盖这两种对象模型的统一接口。因此，要创建256个以上的列，必须在org.apache.poi.xssf.usermodel包或org.apache.poi.ss.usermodel中使用类。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1105819|entityMap^0|2Z|T|4B|T|5D|R|74|T|7Z|R|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|G|$]]

Pre-2007 excel sheets had a limitation of 256 columns. Those sheets also generate ".xls" extension. Excel 2007 and onwards can accommodate 16K columns, are based on an XML format and generate ".xlsx" format.
The POI object model for pre-2007 sheets is <code>org.apache.poi.hssf.usermodel</code> while the object model for 2007 onwards sheets is <code>org.apache.poi.xssf.usermodel</code>
The package <code>org.apache.poi.ss.usermodel</code> provides a uniform interface covering both the object models. So to create more than 256 columns, you will have to use classes within the <code>org.apache.poi.xssf.usermodel</code> package or within <code>org.apache.poi.ss.usermodel</code>.

blocks|key|1320863|text|如何使用Apache+POI在excel工作表中获取超过255列|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1320864|试一试|1320865|Workbook+workbook+=+new+XSSFWorkbook()

<dependency>
+++<groupId>org.apache.poi</groupId>
+++<artifactId>poi-ooxml</artifactId>`enter+code+here`
+++<version>3.15</version>
++</dependency>

++<dependency>
+++<groupId>org.apache.poi</groupId>
+++<artifactId>poi</artifactId>
+++<version>3.15</version>
++</dependency>|code-block|syntax|javascript|1320866|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

How to get more than 255 columns in an excel sheet using Apache POI 
try 

<pre><code>Workbook workbook = new XSSFWorkbook()

&lt;dependency&gt;
 &lt;groupId&gt;org.apache.poi&lt;/groupId&gt;
 &lt;artifactId&gt;poi-ooxml&lt;/artifactId&gt;`enter code here`
 &lt;version&gt;3.15&lt;/version&gt;
 &lt;/dependency&gt;

 &lt;dependency&gt;
 &lt;groupId&gt;org.apache.poi&lt;/groupId&gt;
 &lt;artifactId&gt;poi&lt;/artifactId&gt;
 &lt;version&gt;3.15&lt;/version&gt;
 &lt;/dependency&gt;
</code></pre>

I'm creating a calendar in excel. Column 1 is 01.01.2010 (dd.MM.yyyy), Column 2 is 02.01.2010 and so on. 

This is my code:

<pre><code>int day_cell = 0;

for(int i = 0; i &lt; days.size(); i++)
{
 Date day = days.get(i);

 HSSFCell cell = row.createCell(day_cell++);
 cell.setCellValue(day.toString());
}
</code></pre>

When I get to column 256 POI throws this exception:

<pre><code>java.lang.IllegalArgumentException: Invalid column index (256). Allowable column range for BIFF8 is (0..255) or ('A'..'IV')
at org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:926)
at org.apache.poi.hssf.usermodel.HSSFCell.&lt;init&gt;(HSSFCell.java:162)
at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:141)
at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:119)
</code></pre>

I found this bug-report suggesting it was fixed in the 3.6 release. We were using 3.5 but changing to 3.6 doesn't seem to do any good. Anyone got any tips?

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

Edit: Seems like the bug-issue was about formulas..

How to get more than 255 columns in an excel sheet using Apache POI 3.6

我正在用excel创建日历。第一列是01.01.2010 (dd.MM.yyyy)，第二列是02.01.2010，依此类推。这是我的代码：int day_cell = 0;for(int i = 0; i < days.size(); i++){ Date day = days.get(i); HSSF...

问如何使用Apache POI 3.6获取超过255列的excel表格
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Apache POI 3.6获取超过255列的excel表格EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Apache POI 3.6获取超过255列的excel表格
EN