package test.excel;
import java.io.FileInputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.ss.usermodel.FormulaEvaluator;
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.util.CellRangeAddress;
import org.apache.poi.ss.util.NumberToTextConverter;
public class MergedRegionValue {
public static void main(String[] args) throws Exception{
FileInputStream f;
f = new FileInputStream("C:\\temp\\Book3.xls");
HSSFWorkbook b = new HSSFWorkbook(f);
HSSFSheet s = b.getSheet("Sheet1");
CellRangeAddress ca = s.getMergedRegion(0);//取得第一个合并单元格
System.out.println("合并区域的第一行:"+ca.getFirstRow()+" 合并区域的最后一行"+ca.getLastRow());
System.out.println("合并区域的第一列:"+ca.getFirstColumn()+" 合并区域的最后一列"+ca.getLastColumn());
f.close();
}
java取得合并单元格的属性
最新推荐文章于 2024-07-16 15:48:46 发布