poi解析xlsx

来源：互联网发布：手游java服务器端源码编辑：程序博客网时间：2024/05/01 08:05

//poi导入excel表头后缀名是.xls

StringBuffer buffer = new StringBuffer();
buffer.append("<table cellpadding='0' border='1' cellspacing='0' bordercolor='#dcdcdc' style='font-size:13px;width:100%'>");

if(hzn.equals("xlsx") ){
try {
// 构造 XSSFWorkbook 对象，strPath 传入文件路径
InputStream is = new FileInputStream(path);
XSSFWorkbook xwb = new XSSFWorkbook(is);
// 读取第一章表格内容
XSSFSheet sheet = xwb.getSheetAt(0);
// 定义 row、cell
XSSFRow row;
String cell = null;

// 循环输出表格中的内容
for (int i = sheet.getFirstRowNum(); i < sheet.getPhysicalNumberOfRows(); i++) {

buffer.append("<tr>");

row = sheet.getRow(i);
int columns = 1;

for (int j = row.getFirstCellNum(); j < row.getPhysicalNumberOfCells(); j++) {
//获取单元格内容，
cell = row.getCell(j).toString();
if(cell == ""){
columns++;
}
}
for (int j = row.getFirstCellNum(); j <= row.getPhysicalNumberOfCells(); j++) {
//获取单元格内容，
cell = row.getCell(j).toString();
buffer.append("<td align='center' height='32'");
if(row.getPhysicalNumberOfCells()==columns){
buffer.append("colspan='"+columns+"'>"+cell+"</td>");
j = columns;
}else{
buffer.append("colspan='1'>"+cell+"</td>");
}
}
buffer.append("</tr>");
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
buffer.append("</table>");

0 0