首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >如何使用POIjava[onHolding]读取单行中的excel多列?

如何使用POIjava[onHolding]读取单行中的excel多列?
EN

Stack Overflow用户
提问于 2018-08-13 23:36:39
回答 1查看 0关注 0票数 0

查看下面的代码,并帮助我获得单行中的多列值

代码语言:txt
复制
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;

public class ApachePOIExcelRead {
    public static String cellValue = "";

    private static final String FILE_NAME = "./DealerExcel.xlsx";// ./PoiWorkbook.xlsx

    public static void main(String[] args) throws IOException {

        XSSFWorkbook workbook = new XSSFWorkbook(FILE_NAME);

        XSSFSheet sheet = workbook.getSheetAt(0);

        ArrayList<String> columndata = null;

        Iterator<Row> rowIterator = sheet.iterator();
        columndata = new ArrayList<>();

        while (rowIterator.hasNext()) {
            Row row = rowIterator.next();
            Iterator<Cell> cellIterator = row.cellIterator();
            while (cellIterator.hasNext()) {
                Cell cell = cellIterator.next();

                if (row.getRowNum() > 0) { // To filter column headings
                    if (cell.getColumnIndex() == 0) {// To match column
                                                        // index
                        switch (cell.getCellType()) {
                        case Cell.CELL_TYPE_NUMERIC:
                            columndata.add(cell.getNumericCellValue() + "");
                            System.out.println("Number: "
                                    + cell.getNumericCellValue());
                            break;
                        case Cell.CELL_TYPE_STRING:
                            columndata.add(cell.getStringCellValue());
                            System.out.println("String: "
                                    + cell.getStringCellValue());
                            break;
                        }

                        System.out.println();
                    }

                }
            }
        }
    }
}
EN

回答 1

Stack Overflow用户

发布于 2018-08-14 08:57:47

下面是我们如何读取一行中所有列的方法:

代码语言:txt
复制
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Sheet1");
sheet = wb.getSheetAt(0);

for (Row myrow : sheet) { //iterating row by row
    for (Cell mycell : myrow) {
       //Iterating through all the columns in a row
    }
}
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/-100002118

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档