如何在Excel或apache POI中“格式化为表格”?

时间:2021-10-05 20:26:04

In Excel 2010 it's possible to "format as table" a group of cells - enabling easy sorting and filtering (Home > Format As Table).

在excel2010中,可以将一组单元格“格式化为表”——使排序和过滤变得容易(Home >格式为表)。

Can I do the same in Apache POI? Alternatively, can one accomplish the above directly in Excel via a macro/formula (as opposed to CTRL+T or clicking on a toolbar button)?

我可以在Apache POI中做同样的事情吗?或者,您可以通过宏/公式(与CTRL+T或单击工具栏按钮相反)在Excel中直接完成上述任务吗?

1 个解决方案

#1


2  

There's a fairly new feature in POI that may deliver what you need. Grab a recent nightly/svn build (or wait for POI 3.8 beta 3 in a week or so), and take a look at XSSFTable. You should now be able to add one to a sheet, specify the range it applies to (the range you want to be made a table), and that hopefully will do you. It's quite new though, so you may need to join the POI dev list and help with the development of the feature if it's not quite there for you!

POI中有一个相当新的特性可以满足您的需要。获取最近的夜间/svn构建(或者在一周内等待POI 3.8 beta 3),并查看XSSFTable。现在,您应该能够向一个表中添加一个,指定它应用的范围(您希望成为一个表的范围),希望这对您有帮助。这是一个全新的东西,所以你可能需要加入POI dev列表并帮助开发这个功能,如果它不适合你的话!

#1


2  

There's a fairly new feature in POI that may deliver what you need. Grab a recent nightly/svn build (or wait for POI 3.8 beta 3 in a week or so), and take a look at XSSFTable. You should now be able to add one to a sheet, specify the range it applies to (the range you want to be made a table), and that hopefully will do you. It's quite new though, so you may need to join the POI dev list and help with the development of the feature if it's not quite there for you!

POI中有一个相当新的特性可以满足您的需要。获取最近的夜间/svn构建(或者在一周内等待POI 3.8 beta 3),并查看XSSFTable。现在,您应该能够向一个表中添加一个,指定它应用的范围(您希望成为一个表的范围),希望这对您有帮助。这是一个全新的东西,所以你可能需要加入POI dev列表并帮助开发这个功能,如果它不适合你的话!