JAVA POI读取XML

JAVA POI读取XML

package com.sunland.poi;

import java.io.FileInputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

/**
 * 通过poi读取xml文件的所有内容，并输出
 * @author Administrator
 *
 */
public class OperateMicc {
	public static void main(String[] args) {
		String path = "C://x.xls";
		try {
			//读取xml文件
			HSSFWorkbook work = new HSSFWorkbook(new FileInputStream(path));
			//获取xml的表
			HSSFSheet sheet = work.getSheet("sheet1");
			//循环表的行
			for (int i = 0, snum = sheet.getPhysicalNumberOfRows(); i < snum; i++) {
				//获取一行数据
				HSSFRow row = sheet.getRow(i);
				StringBuffer buffer = new StringBuffer();
				//获取不到行数退出此次循环
				if (row == null)
					continue;
				//循环某行的列数据
				for (int t = 0, cnum = row.getPhysicalNumberOfCells(); t < cnum; t++) {
					//通过行获取列
					HSSFCell cell = row.getCell(t);
					
					if (cell == null)
						continue;
					//判断该行该列的单元格的类型，并获取该类型的值
					switch (cell.getCellType()) {
					case STRING:
						buffer.append(cell.getStringCellValue());
						break;
					case NUMERIC:
						buffer.append(cell.getNumericCellValue());
						break;
					case BLANK:
						buffer.append(" ");
						break;
					case BOOLEAN:
						buffer.append(cell.getBooleanCellValue());
						break;
					}
					;
					//获取单元格数据后与另一单元格腾出一个制表符的距离
					buffer.append("\t");
				}
				//输出该行的所有列数据
				System.out.println(buffer.toString());
			}
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}