Apache POI - XSSF：Row.getCell()

发布于 2024-12-08 22:29:02 字数 258 浏览 1 评论 0原文

我正在使用 XSSF 访问 .xlsx 格式。提取行数据和单元格数据是由

Row.getCell(1) // to get the first cell data.

Is there a way to access cells like

Row.getCell(A) or Row.getCell(AC).

这对我访问列非常有帮助。谁能告诉我如何做到这一点？

原文

I am using XSSF to access the .xlsx format. Extracting row data and cell data is being done by

Row.getCell(1) // to get the first cell data.

Is there a way to access cells like

Row.getCell(A) or Row.getCell(AC).

This will be very helpfull for me to access columns.
Can any one tell me the way to do this?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

东京女 2024-12-15 22:29:02

我认为您正在寻找的主要课程是 CellReference< /a> - 它处理面向用户的引用（例如“B2”）与文件格式引用（例如 row=1,col=1 ）之间的转换。那里有一个静态方法可以处理您的确切用例，convertColStringToIndex

对于您的用例，您需要类似的代码

 Cell c = row.getCell( CellReference.convertColStringToIndex("G") );

I think the main class you're looking for is CellReference - it handles converting between user facing references such as "B2" into file format references like row=1,col=1 . There's a static method on there that handles your exact use case, convertColStringToIndex

For your use case, you'd want code something like

 Cell c = row.getCell( CellReference.convertColStringToIndex("G") );

回复收藏 0 原文

你怎么敢 2024-12-15 22:29:02

如果我没记错的话，问题是关于使用其引用来访问单元格。

Sheet referenceSheet = workbook.getsheet("Sheet name your intrested in");

CellReference ref = new CellReference("C24");
Row row = referenceSheet.getRow(ref.getRow());
 // null check for the row
if(row != null)
{
Cell cell = row.getCell(ref.getCol());
}

通过这种方式，我们可以使用单元格的引用来引用单元格。

The question is regarding reaching out a cell using its references, if I am not wrong.

Sheet referenceSheet = workbook.getsheet("Sheet name your intrested in");

CellReference ref = new CellReference("C24");
Row row = referenceSheet.getRow(ref.getRow());
 // null check for the row
if(row != null)
{
Cell cell = row.getCell(ref.getCol());
}

In this way we can refer a cell using its reference.

回复收藏 0 原文

~没有更多了~