1.代码
import java.io.File
import java.io.FileInputStream
import org.apache.poi.ss.usermodel.Row
import org.apache.poi.ss.usermodel.Sheet
import org.apache.poi.ss.usermodel.Workbook
import org.apache.poi.ss.usermodel.WorkbookFactory
public class TestExcel {
public static void main(String[] args) {
try {
File file = new File("C://Users/Administrator/Desktop/test.xls")
FileInputStream is = new FileInputStream(file)
Workbook workbook = WorkbookFactory.create(is)
Sheet sheet = workbook.getSheetAt(0)
int rowCount = sheet.getPhysicalNumberOfRows()
Row row1 = sheet.getRow(0)
if(!row1.getCell(0).toString().trim().equals("序号")||
!row1.getCell(1).toString().trim().equals("评价年度")||
!row1.getCell(2).toString().trim().equals("纳税人识别号")||
!row1.getCell(3).toString().trim().equals("纳税人名称")||
!row1.getCell(4).toString().trim().equals("评价结果")){
return
}
for(int i=1
Row row = sheet.getRow(i)
int cellCount = row.getPhysicalNumberOfCells()
String xh = ""
String pjnd = ""
String nsrsbh = ""
String nsrmc = ""
String pjjg = ""
for(int c=0
String cellStr = row.getCell(c).toString().trim()
if(!cellStr.equals("")&&cellStr!=null){
if(c==0) xh=cellStr
if(c==1) pjnd=cellStr
if(c==2) nsrsbh=cellStr
if(c==3) nsrmc=cellStr
if(c==4) pjjg=cellStr
}
}
System.out.println(xh+"|"+pjnd+"|"+nsrsbh+"|"+nsrmc+"|"+pjjg)
}
} catch (Exception e) {
e.printStackTrace()
}
}
}
2.相关jar包下载
下载地址:http://pan.baidu.com/s/1nvhX3N7