如何用java读取excel文件_如何在Java中读取Excel(.xlsx)文件？

从一个给定的.xlsx文件,我试图使用Java读取数据.

我读取文件的代码如下：

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

FileInputStream file = new FileInputStream(new File("E:\\test1.xlsx"));

XSSFWorkbook workbook = new XSSFWorkbook(file);

XSSFSheet test = workbook.getSheetAt(0);

student emp = new student();

Iterator itr = test.iterator();

itr.next();

while(itr.hasNext()){

Row row = itr.next();

emp.reedData(row);

System.out.println(id+","+name+","+options);

}

方法如下：

void reedData(Row row){

id= row.getCell(0).toString();

name= row.getCell(1).toString();

options= row.getCell(2).toString();

}

但是,我得到这样的输出：

1.0,X,play game

,,sing song

2.0,Y,play game

,,sing song

而不是上面,我希望输出看起来像这样：

1.0,X,{play game,sing song}

2.0,Y,{play game,sing song}

该问题是因为我正在合并.xlsx文件中的两个单元格.

有什么建议吗？

先感谢您..

解决方法:

这就是我做的.

import static java.lang.System.out;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.util.ArrayList;

import java.util.Iterator;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.DataFormatter;

import org.apache.poi.ss.usermodel.IndexedColors;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class read {

public static void main(String [] args){

FileInputStream excelFile = new FileInputStream(new File(keep));

XSSFWorkbook wb = new XSSFWorkbook(excelFile);

XSSFSheet sheet = wb.getSheetAt(0);

int rowCount; // number of rows of newly form excel files

rowCount= sheet.getPhysicalNumberOfRows();

out.println(rowCount);

//trying to iterate the excel file

int i =0;

Iterator rowIterator = sheet.iterator();

do{

Row row = rowIterator.next();

Iterator cellIterator = row.cellIterator();

while(cellIterator.hasNext()) {

Cell cell = cellIterator.next();

if(cell.getColumnIndex()==0) { // to read the first column

DataFormatter df = new DataFormatter();

String str2 = df.formatCellValue(cell);

customerNo.add(str2);

}

}

++i;

if(i>rowCount)break;

//break;

}while(rowIterator.hasNext());

wb.close();

}

}

希望这可以帮助.

标签：apache-poi,java,excel,android

来源： https://codeday.me/bug/20191118/2028888.html