直接PO代码:
package OpExcel;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.junit.Test;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class OperateExcelMain {
public static void main(String[] args) throws Exception{
XSSFWorkbook workbook=new XSSFWorkbook(new FileInputStream(new File("D:\\发货单测试.xlsx")));
XSSFSheet sheet=null;
int i=workbook.getSheetIndex("Sheet1");//sheet表名
sheet=workbook.getSheetAt(i);
for(int j=0;j<sheet.getLastRowNum()+1;j++) {
XSSFRow row=sheet.getRow(j);
if(row!=null) {
for(int k=0;k<row.getLastCellNum();k++) {
if(row.getCell(k)!=null) {
System.out.print(row.getCell(k)+"\t");
}
else {
System.out.print("\t");
}
}
}
System.out.print("\n");
}
}
}