blocks|key|3213930|text|您可以尝试如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3213931|HSSFSheet+summarySheet+=+wb.createSheet();
summarySheet.setColumnWidth(short+column,+short+width);|code-block|syntax|javascript|3213932|这里的参数是:表格中的列数和宽度，但是宽度的单位很小，例如你可以尝试4000。|3213933|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|$]]

You can try something like this:

<pre><code>HSSFSheet summarySheet = wb.createSheet();
summarySheet.setColumnWidth(short column, short width);
</code></pre>

Here params are:column number in sheet and its width
But,the units of width are pretty small, you can try 4000 for example.

blocks|key|3213948|text|在将所有数据添加到工作表后，可以在工作表上调用autoSizeColumn(int+column)来自动调整列的大小|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|3213949|这里有一个API的链接。|3213950|有关更多参考Problem+in+fitting+the+excel+cell+size+to+the+size+of+the+content+when+using+apache+poi，请参阅此帖子|3213951|entityMap|0|LINK|mutability|MUTABLE|url|http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html#autoSizeColumn-int-|1|https://stackoverflow.com/questions/4015623/problem-in-fitting-the-excel-cell-size-to-the-size-of-the-content-when-using-apac^0|0|1|N|Q|0|5|3|0|0|6|2F|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|D]]|E|@]|F|$]]|$1|G|3|H|5|6|7|Z|8|@]|E|@$9|10|A|11|1|12]]|F|$]]|$1|I|3|J|5|6|7|13|8|@]|E|@$9|14|A|15|1|16]]|F|$]]|$1|K|3|-4|5|6|7|17|8|@]|E|@]|F|$]]]|L|$M|$5|N|O|P|F|$Q|R]]|S|$5|N|O|P|F|$Q|T]]]]

After you have added all your data to the sheet, you can call <code>autoSizeColumn(int column)</code> on your sheet to autofit the columns to the proper size

Here is a link to the <a href="http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html#autoSizeColumn-int-" rel="noreferrer">API</a>.

See this post for more reference
<a href="https://stackoverflow.com/questions/4015623/problem-in-fitting-the-excel-cell-size-to-the-size-of-the-content-when-using-apac">Problem in fitting the excel cell size to the size of the content when using apache poi</a>

blocks|key|3214052|text|提示:要使自动调整大小起作用，应在将数据填充到excel后调用。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3214053|在填充数据之前调用该方法将不起作用。|3214054|entityMap^0|0|3|V|1|0|0|I|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|R|8|@]|D|@]|E|$]]]|I|$]]

Tip : To make Auto size work , the call to <code>sheet.autoSizeColumn(columnNumber)</code> should be made after populating the data into the excel.

Calling the method before populating the data, will have no effect.

blocks|key|3000755|text|对于Excel+POI：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3000756|sheetName.autoSizeColumn(cellnum);+|code-block|syntax|javascript|3000757|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|$]]

For Excel POI: 

<pre><code>sheetName.autoSizeColumn(cellnum); 
</code></pre>

blocks|key|3000779|text|下面是示例代码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3000780|HSSFWorkbook+wb+=+new+HSSFWorkbook();
HSSFSheet+sheet+=+wb.createSheet("your+sheet+name");
HSSFRow+row+=+sheet.createRow(0);

cell+=+row.createCell(0);
cell.setCellValue("A+BIG+NAME+WITH+AUTO+SIZE+FEATURE+ENABLED");|code-block|syntax|javascript|3000781|//这一点至关重要|3000782|sheet.autoSizeColumn(0);|3000783|//参数必须是单元格编号|3000784|cell+=+row.createCell(1);
cell.setCellValue("a+big+name+without+auto+size+feature+enabled");|3000785|检查输出并抓紧时间:)|3000786|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

sample code below

<pre><code>HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("your sheet name");
HSSFRow row = sheet.createRow(0);

cell = row.createCell(0);
cell.setCellValue("A BIG NAME WITH AUTO SIZE FEATURE ENABLED");
</code></pre>

//this is crucial

<pre><code>sheet.autoSizeColumn(0);
</code></pre>

//argument must be cell number

<pre><code>cell = row.createCell(1);
cell.setCellValue("a big name without auto size feature enabled");
</code></pre>

Check the output and go nuts :)

blocks|key|285862|text|如果要自动调整工作簿中所有列的大小，这里有一个可能有用的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|285863|public+void+autoSizeColumns(Workbook+workbook)+{
++++int+numberOfSheets+=+workbook.getNumberOfSheets();
++++for+(int+i+=+0;+i+<+numberOfSheets;+i%2B%2B)+{
++++++++Sheet+sheet+=+workbook.getSheetAt(i);
++++++++if+(sheet.getPhysicalNumberOfRows()+>+0)+{
++++++++++++Row+row+=+sheet.getRow(sheet.getFirstRowNum());
++++++++++++Iterator<Cell>+cellIterator+=+row.cellIterator();
++++++++++++while+(cellIterator.hasNext())+{
++++++++++++++++Cell+cell+=+cellIterator.next();
++++++++++++++++int+columnIndex+=+cell.getColumnIndex();
++++++++++++++++sheet.autoSizeColumn(columnIndex);
++++++++++++}
++++++++}
++++}
}|code-block|syntax|javascript|285864|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|$]]

If you want to auto size all columns in a workbook, here is a method that might be useful: 

<pre><code>public void autoSizeColumns(Workbook workbook) {
 int numberOfSheets = workbook.getNumberOfSheets();
 for (int i = 0; i &lt; numberOfSheets; i++) {
 Sheet sheet = workbook.getSheetAt(i);
 if (sheet.getPhysicalNumberOfRows() &gt; 0) {
 Row row = sheet.getRow(sheet.getFirstRowNum());
 Iterator&lt;Cell&gt; cellIterator = row.cellIterator();
 while (cellIterator.hasNext()) {
 Cell cell = cellIterator.next();
 int columnIndex = cell.getColumnIndex();
 sheet.autoSizeColumn(columnIndex);
 }
 }
 }
}
</code></pre>

blocks|key|3214129|text|如果你想扩展你的单元格，你可以使用setColumnWidth()。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3214130|entityMap^0|H|G|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

You can use <code>setColumnWidth()</code> if you want to expand your cell more.

blocks|key|285874|text|很简单，使用这一行代码dataSheet.autoSizeColumn(0)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|285875|或者给出方括号dataSheet.autoSizeColumn中的列数(单元格编号)|285876|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|$]]

Its very simple, use this one line code
dataSheet.autoSizeColumn(0)

or give the number of column in bracket
dataSheet.autoSizeColumn(cell number )

blocks|key|3214158|text|如果你知道你的列数(f.e.它等于一个集合列表)。您可以简单地使用这一行来调整一个工作表的所有列(如果您至少使用java+8)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3214159|IntStream.range(0,+columnCount).forEach((columnIndex)+->+sheet.autoSizeColumn(columnIndex));|code-block|syntax|javascript|3214160|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|$]]

If you know the count of your columns (f.e. it's equal to a collection list). You can simply use this one liner to adjust all columns of one sheet (if you use at least java 8):

<pre><code>IntStream.range(0, columnCount).forEach((columnIndex) -&gt; sheet.autoSizeColumn(columnIndex));
</code></pre>

blocks|key|3214176|text|您也可以对文本进行换行。PFB示例代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3214177|CellStyle+wrapCellStyle+=+new_workbook.createCellStyle();
++++++++++++++++++++wrapCellStyle.setWrapText(true);|code-block|syntax|javascript|3214178|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|$]]

You can wrap the text as well. PFB sample code:

<pre><code>CellStyle wrapCellStyle = new_workbook.createCellStyle();
 wrapCellStyle.setWrapText(true);
</code></pre>

blocks|key|286901|text|我使用以下简单的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|286902|这是您的工作簿和工作表：|286903|XSSFWorkbook+workbook+=+new+XSSFWorkbook();
XSSFSheet+sheet+=+workbook.createSheet("YOUR+Workshhet");|code-block|syntax|javascript|286904|然后将数据添加到包含列和行的工作表中。将数据添加到工作表后，将以下代码写入autoSizeColumn+width。|offset|length|style|CODE|286905|for+(int+columnIndex+=+0;+columnIndex+<+15;+columnIndex%2B%2B)+{
++++++++++++++++++++sheet.autoSizeColumn(columnIndex);
++++++++++++++++}|286906|在这里，您可以添加工作表中的列数，而不是15列。|286907|希望有人能帮上忙。|286908|entityMap^0|0|0|0|11|E|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Z|8|@$K|10|L|11|M|N]]|9|@]|A|$]]|$1|O|3|P|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|14|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

I use below simple solution:

This is your workbook and sheet:

<pre><code>XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet("YOUR Workshhet");
</code></pre>

then add data to your sheet with columns and rows. Once done with adding data to sheet write following code to <code>autoSizeColumn</code> width.

<pre><code>for (int columnIndex = 0; columnIndex &lt; 15; columnIndex++) {
 sheet.autoSizeColumn(columnIndex);
 }
</code></pre>

Here, instead 15, you add the number of columns in your sheet.

Hope someone helps this.

blocks|key|285966|text|你可以在你的循环之后添加这个。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|285967|for+(int+i+=+0;+i<53;i%2B%2B)+{
++++sheet.autoSizeColumn(i);
}|code-block|syntax|javascript|285968|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|$]]

You can add this, after your loop.
<pre><code>for (int i = 0; i&lt;53;i++) {
 sheet.autoSizeColumn(i);
}
</code></pre>

I am using <code>Apache POI API</code> to generate <code>excel spreadsheet</code> to output some data.

The problem I am facing is when the spreadsheet is created and opened, columns are not expanded so that some long text like Date formatted text is not showing up on first glance.

I could just double click the column border in excel to expand or drag the border to adjust the column width but there could be 20+ columns and there is no way I want to do that manually every time I open the spreadsheet :(

I found out (though could be wrong method) <code>groupRow()</code> and <code>setColumnGroupCollapsed()</code> might be able to do the trick but no luck. Maybe I'm using it in wrong way.

Sample Code snippet

<pre><code> Workbook wb = new HSSFWorkbook();
 CreationHelper createHelper = wb.getCreationHelper();
 //create sheet
 Sheet sheet = wb.createSheet("masatoSheet");

 //not really working yet.... :(
 //set group for expand/collapse
 //sheet.groupRow(0, 10); //just random fromRow toRow argument values...
 //sheet.setColumnGroupCollapsed(0, true);

 //create row
 Row row = sheet.createRow((short)0);
 //put a cell in the row and store long text data
 row.createCell(0).setCellValue("Loooooooong text not to show up first");
</code></pre>

When this spreadsheet is created, the "Looooooong text not to show up first" string is in the cell but since the column is not expanded only "Loooooooo" is showing up.

How can I configure it so that when I open my spreadsheet, the column is already expanded???

Apache POI Excel - how to configure columns to be expanded?

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我正在使用Apache POI API生成excel spreadsheet来输出一些数据。我面临的问题是，当创建和打开电子表格时，列没有展开，因此一些长文本，如日期格式的文本，不会第一眼就显示出来。我可以在excel中双击列边框来展开或拖动边框来调整列宽，但可能有20+列，我不可能每次打开电子表格时都手动执行此操作:...

问Apache POI Excel -如何配置要展开的列？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Apache POI Excel -如何配置要展开的列？EN