java - 读取 Excel 标题和行值
问题描述
我需要阅读具有标题和 N.of 行的 excel 内容。根据列标题输入,需要在JAVA中提取行。
我已经阅读了完整的 excel 内容的 java 代码。
//Create Workbook instance holding reference to .xlsx file
XSSFWorkbook workbook = new XSSFWorkbook(file);
//Get first/desired sheet from the workbook
XSSFSheet sheet = workbook.getSheetAt(0);
int totalRows = sheet.getPhysicalNumberOfRows();
//Iterate through each rows one by one
Iterator<Row> rowIterator = sheet.iterator();
while (rowIterator.hasNext())
{
Row row = rowIterator.next();
//For each row, iterate through all the columns
Iterator<Cell> cellIterator = row.cellIterator();
while (cellIterator.hasNext())
{
Cell cell = cellIterator.next();
//Check the cell type and format accordingly
switch (cell.getCellType())
{
case Cell.CELL_TYPE_NUMERIC:
System.out.print(cell.getNumericCellValue() + "\t");
break;
case Cell.CELL_TYPE_STRING:
System.out.print(cell.getStringCellValue() + "\t");
break;
}
}
System.out.println("");
Excel 内容
Coln1 Coln2 Coln3 Coln4
A 12 nice 3e
A 23 talk s2
A 43 res 23
B 11 xl 34
B 88 out r45
C 45 tr h5
预期结果
if (Coln1==B)
{
Loop the list of B rows (here its 2 rows)
Coln1 Coln2 Coln3 Coln4
B 11 xl 34
B 88 out r45
if i need , r45 , How to pass the row cell to get the value?
}
有人可以帮忙吗?谢谢
解决方案
如果标题是第 1 行,也许你可以这样做。
Row headerRow = sheet.getRow(0);
您可以为索引定义一些常量。例如
int n1ColIndex = 0; // 0-based. this is the index of row in excel.
int n2ColIndex = 1; //
int n3ColIndex = 2;
int n4ColIndex = 3;
// then you can read cell by Row.getCell() method.
// below code, you can put in loop.
XSSFCell n1Cell = row.getCell(n1ColIndex);
if ( n1Cell == null ){
continue;
}
String n1Col = n1Cell.getStringCellValue();
if( "B".equals(n1Col) ) {
// get r45 value.
XSSFCell n4Cell = row.getCell(n4ColIndex);
if ( n4Cell == null ){
continue;
}
String val = n4Cell.getStringCellValue();
// this value will be 34 or r45
// Do you understand ?
}
// update 1. how to get a row.
// method 1.
Iterator<Row> rowIterator = sheet.iterator();
while (rowIterator.hasNext())
{
Row row = rowIterator.next();
// do something with the row var.
}
// method 2.
for ( int index=0; index < sheet.getLastRowNum(); index++){
Row row = sheet.getRow(index);
// check null.
if ( row == null ){
continue;
}
// do something with the row var.
}
API DOC XSSFSheet
都是手写的,没有测试。有什么问题,回复我。
推荐阅读
- php - ip2long("012.012.012.012") 在 Linux 上返回 false
- typescript - Ionic 6 FormBuilder、FormGroup、验证器、FormControl 和 ControlContainer 错误
- java - @EventListener spring boot 编译失败
- ios - iOS Swift 遍历 Firestore 中的字典项数组
- java - CKR_SESSION_READ_ONLY 使用 keytool 创建密钥库时
- javascript - react组件中的map函数和异步函数调用
- c# - 自定义控件不会随着窗口调整大小而调整大小
- python - 根据 pandas 中的两个日期列进行过滤
- flutter - Flutter 中的变量值在 setState() 之外为空
- html - ruby on rails sidekiq worker 中的 wicked_pdf:如何使使用的模板动态化