java 判断excel是不是合并单元_java 解析excel，带合并单元的excel

标签：

首先，mavn导入jar包

org.apache.poi

poi

3.11

org.apache.poi

poi-ooxml

3.11

org.apache.poi

poi-ooxml-schemas

3.11

stax

stax-api

1.0.1

org.apache.xmlbeans

xmlbeans

2.6.0

其次，代码如下：

package excel;

import java.io.File;

import java.io.IOException;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;

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

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;

import org.apache.poi.ss.util.CellRangeAddress;

import org.junit.Test;

/**

*

* @author wcyong

*

* @date   2013-6-21

*/

public class TestReadMergeRegionExcel {

@Test

public void testReadExcel() {

readExcelToObj("C:\\Users\\Administrator\\Desktop\\11.xls");

}

/**

* 读取excel数据

* @param path

*/

private void readExcelToObj(String path) {

Workbook wb = null;