Java CellRangeAddress.getFirstColumn方法代码示例

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
/**
 * 判断单元格是否是合并的单格，如果是，获取其合并的行数。
 */
private static int getMergerCellRegionRow(HSSFSheet sheet, int cellRow, int cellCol) throws Throwable {
	int retVal = 0;
	int sheetMergerCount = sheet.getNumMergedRegions();
	for (int i = 0; i < sheetMergerCount; i++) {
		CellRangeAddress cra = sheet.getMergedRegion(i);
		int firstRow = cra.getFirstRow(); // 合并单元格CELL起始行
		int firstCol = cra.getFirstColumn(); // 合并单元格CELL起始列
		int lastRow = cra.getLastRow(); // 合并单元格CELL结束行
		int lastCol = cra.getLastColumn(); // 合并单元格CELL结束列
		if (cellRow >= firstRow && cellRow <= lastRow) { // 判断该单元格是否是在合并单元格中
			if (cellCol >= firstCol && cellCol <= lastCol) {
				retVal = lastRow - firstRow + 1; // 得到合并的行数
				break;
			}
		}
	}
	return retVal;
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
private Span getSpan(XSSFSheet sheet,int row ,int column){
	int sheetMergeCount = sheet.getNumMergedRegions(); 
	for (int i = 0; i < sheetMergeCount; i++) {
		CellRangeAddress range = sheet.getMergedRegion(i);
		int firstColumn = range.getFirstColumn();
		int lastColumn = range.getLastColumn();
		int firstRow = range.getFirstRow();
		if(row == firstRow && column==firstColumn){  
			int lastRow = range.getLastRow();
			int rowSpan=lastRow-firstRow;
			if(rowSpan>0){
				rowSpan++;
			}
			int colSpan=lastColumn-firstColumn;
			if(colSpan>0){
				colSpan++;
			}
			return new Span(rowSpan,colSpan);
		}
	}
	return new Span(0,0);
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
private boolean isMergedRegion(XSSFSheet sheet, int row, int column) {
	int sheetMergeCount = sheet.getNumMergedRegions();
	for (int i = 0; i < sheetMergeCount; i++) {
		CellRangeAddress range = sheet.getMergedRegion(i);
		int firstColumn = range.getFirstColumn();
		int lastColumn = range.getLastColumn();
		int firstRow = range.getFirstRow();
		int lastRow = range.getLastRow();
		if (row > firstRow && row < lastRow) {
			if (column > firstColumn && column < lastColumn) {
				return true;
			}
		}
	}
	return false;
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
/**
 * 判断单元格在不在合并单元格范围内，如果是，获取其合并的列数。
 */
private static int getMergerCellRegionCol(HSSFSheet sheet, int cellRow, int cellCol) throws Throwable {
	int retVal = 0;
	int sheetMergerCount = sheet.getNumMergedRegions();
	for (int i = 0; i < sheetMergerCount; i++) {
		CellRangeAddress cra = sheet.getMergedRegion(i);
		int firstRow = cra.getFirstRow(); // 合并单元格CELL起始行
		int firstCol = cra.getFirstColumn(); // 合并单元格CELL起始列
		int lastRow = cra.getLastRow(); // 合并单元格CELL结束行
		int lastCol = cra.getLastColumn(); // 合并单元格CELL结束列
		if (cellRow >= firstRow && cellRow <= lastRow) { // 判断该单元格是否是在合并单元格中
			if (cellCol >= firstCol && cellCol <= lastCol) {
				retVal = lastCol - firstCol + 1; // 得到合并的列数
				break;
			}
		}
	}
	return retVal;
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
private Span getSpan(HSSFSheet sheet,int row ,int column){
	int sheetMergeCount = sheet.getNumMergedRegions(); 
	for (int i = 0; i < sheetMergeCount; i++) {
		CellRangeAddress range = sheet.getMergedRegion(i);
		int firstColumn = range.getFirstColumn();
		int lastColumn = range.getLastColumn();
		int firstRow = range.getFirstRow();
		if(row == firstRow && column==firstColumn){  
			int lastRow = range.getLastRow();
			int rowSpan=lastRow-firstRow;
			if(rowSpan>0){
				rowSpan++;
			}
			int colSpan=lastColumn-firstColumn;
			if(colSpan>0){
				colSpan++;
			}
			return new Span(rowSpan,colSpan);
		}
	}
	return new Span(0,0);
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
private boolean isMergedRegion(HSSFSheet sheet, int row, int column) {
	int sheetMergeCount = sheet.getNumMergedRegions();
	for (int i = 0; i < sheetMergeCount; i++) {
		CellRangeAddress range = sheet.getMergedRegion(i);
		int firstColumn = range.getFirstColumn();
		int lastColumn = range.getLastColumn();
		int firstRow = range.getFirstRow();
		int lastRow = range.getLastRow();
		if (row > firstRow && row < lastRow) {
			if (column > firstColumn && column < lastColumn) {
				return true;
			}
		}
	}
	return false;
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
/**
 * @param srcSheet the sheet to copy.
 * @param destSheet the sheet to create.
 * @param srcRow the row to copy.
 * @param destRow the row to create.
 * @param styleMap -
 */
public static void copyRow(XSSFSheet srcSheet, XSSFSheet destSheet, XSSFRow srcRow, XSSFRow destRow, Map<Integer, XSSFCellStyle> styleMap) {
    // manage a list of merged zone in order to not insert two times a merged zone  
    Set<CellRangeAddressWrapper> mergedRegions = new TreeSet<CellRangeAddressWrapper>();
    destRow.setHeight(srcRow.getHeight());
    // pour chaque row  
    for (int j = srcRow.getFirstCellNum(); j <= srcRow.getLastCellNum(); j++) {
        if(j<0){
        }else{
            XSSFCell oldCell = srcRow.getCell(j);   // ancienne cell  
        XSSFCell newCell = destRow.getCell(j);  // new cell   
        if (oldCell != null) {
            if (newCell == null) {
                newCell = destRow.createCell(j);
            }
            // copy chaque cell  
            copyCell(oldCell, newCell, styleMap);
                  // copy les informations de fusion entre les cellules  
            //System.out.println("row num: " + srcRow.getRowNum() + " , col: " + (short)oldCell.getColumnIndex());  
            CellRangeAddress mergedRegion = getMergedRegion(srcSheet, srcRow.getRowNum(), (short) oldCell.getColumnIndex());

            if (mergedRegion != null) {
                //System.out.println("Selected merged region: " + mergedRegion.toString());  
                CellRangeAddress newMergedRegion = new CellRangeAddress(mergedRegion.getFirstRow(), mergedRegion.getLastRow(), mergedRegion.getFirstColumn(), mergedRegion.getLastColumn());
                //System.out.println("New merged region: " + newMergedRegion.toString());  
                CellRangeAddressWrapper wrapper = new CellRangeAddressWrapper(newMergedRegion);
                if (isNewMergedRegion(wrapper, mergedRegions)) {
                    mergedRegions.add(wrapper);
                    destSheet.addMergedRegion(wrapper.range);
                }
            }
        }
        }
        
    }

}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
/**  
 * 获取合并单元格的值  
 * @param sheet  
 * @param row  
 * @param column  
 * @return  
 */
public static String getMergedRegionValue(Sheet sheet, int row, int column) {
    int sheetMergeCount = sheet.getNumMergedRegions();

    for (int i = 0; i < sheetMergeCount; i++) {
        CellRangeAddress ca = sheet.getMergedRegion(i);
        int firstColumn = ca.getFirstColumn();
        int lastColumn = ca.getLastColumn();
        int firstRow = ca.getFirstRow();
        int lastRow = ca.getLastRow();

        if (row >= firstRow && row <= lastRow) {

            if (column >= firstColumn && column <= lastColumn) {
                Row fRow = sheet.getRow(firstRow);
                Cell fCell = fRow.getCell(firstColumn);

                return getCellValue(fCell);
            }
        }
    }

    return null;
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
/**  
 * 判断指定的单元格是否是合并单元格  
 * @param sheet  
 * @param row  
 * @param column  
 * @return  
 */
public static boolean isMergedRegion(Sheet sheet, int row, int column) {
    int sheetMergeCount = sheet.getNumMergedRegions();

    for (int i = 0; i < sheetMergeCount; i++) {
        CellRangeAddress ca = sheet.getMergedRegion(i);
        int firstColumn = ca.getFirstColumn();
        int lastColumn = ca.getLastColumn();
        int firstRow = ca.getFirstRow();
        int lastRow = ca.getLastRow();

        if (row >= firstRow && row <= lastRow) {
            if (column >= firstColumn && column <= lastColumn) {

                return true;
            }
        }
    }

    return false;
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
public static CellRangeAddress getMergedRegion(final HSSFSheet sheet, final CellLocation location) {
    for (int i = 0; i < sheet.getNumMergedRegions(); i++) {
        final CellRangeAddress region = sheet.getMergedRegion(i);

        final int rowFrom = region.getFirstRow();
        final int rowTo = region.getLastRow();

        if (rowFrom == location.r && rowTo == location.r) {
            final int colFrom = region.getFirstColumn();

            if (colFrom == location.c) {
                return region;
            }
        }
    }

    return null;
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
public static CellRangeAddress getMergedRegion(HSSFSheet sheet,
		CellLocation location) {
	for (int i = 0; i < sheet.getNumMergedRegions(); i++) {
		CellRangeAddress region = sheet.getMergedRegion(i);

		int rowFrom = region.getFirstRow();
		int rowTo = region.getLastRow();

		if (rowFrom == location.r && rowTo == location.r) {
			int colFrom = region.getFirstColumn();

			if (colFrom == location.c) {
				return region;
			}
		}
	}

	return null;
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
/**
 * Redimensionne les colonnes qui contiennent des régions fusionnées.
 * 
 * Dans POI, les régions fusionnées ne sont pas prises en compte dans le autoSizeColumn.
 * Quand on fusionne des cellules sur une même colonne, on corrige la taille de cette colonne si nécessaire.
 * 
 * @param sheet feuille de calcul
 * @param columns map contenant l'en-tête et les informations d'une colonne
 */
protected void resizeMergedColumns(Sheet sheet, Collection<ColumnInformation> columns) {
	if (sheet.getNumMergedRegions() > 0) {
		List<ColumnInformation> columnsInfo = new ArrayList<ColumnInformation>(columns);
		
		for (int i = 0; i < sheet.getNumMergedRegions(); i++) {
			CellRangeAddress mergedRegion = sheet.getMergedRegion(i);
			
			if (mergedRegion.getFirstColumn() == mergedRegion.getLastColumn()) {
				int columnIndex = mergedRegion.getFirstColumn();
				
				String headerText = getColumnLabel(columnsInfo.get(columnIndex).getHeaderKey());
				
				int headerSize = (int) (headerText.length() * 300 * COLUMN_RESIZE_RATIO);
				if (sheet.getColumnWidth(columnIndex) < headerSize) {
					sheet.setColumnWidth(columnIndex, headerSize);
				}
			}
		}
	}
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
protected A1RangeAddress(String a1address) {
    this.addresses = new LinkedList<>();
    
    if (!a1address.contains(RANGE_DELIMITER)) { this.addresses.add(A1Address.fromA1Address(a1address)); return; }
    
    CellRangeAddress addrs = CellRangeAddress.valueOf(a1address);
    int fromR = addrs.getFirstRow();
    int fromC = addrs.getFirstColumn();
    int toR = addrs.getLastRow();
    int toC = addrs.getLastColumn();

    for (int row = fromR; row <= toR; row++) {
        for (int col = fromC; col <= toC; col++) {
            this.addresses.add(A1Address.fromRowColumn(row, col));
        }
    }
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
protected Row generateRow2(ForeachRowInfo repeateRow, final ExcelTemplateValueProvider provider, int rownumb){
	Row endRow = repeateRow.getRow().getSheet().createRow(rownumb);
	endRow.setHeight(repeateRow.getRow().getHeight());
	for(Cell cell : repeateRow.getRow()){
		Cell newCell = endRow.createCell(cell.getColumnIndex());
		ExcelUtils.copyCellStyle(cell, newCell);
		Object newCellValue = provider.parseCellValue(cell, provider);
		ExcelUtils.setCellValue(newCell, newCellValue);
		
		CellRangeAddress cr = provider.getCellRange(repeateRow, cell);
		if(cr!=null){
			CellRangeAddress newCr = new CellRangeAddress(rownumb, 
											rownumb+(cr.getLastRow()-cr.getFirstRow()), 
											cr.getFirstColumn(), cr.getLastColumn());
			endRow.getSheet().addMergedRegion(newCr);
		}
	}
	return endRow;
}
 

import org.apache.poi.ss.util.CellRangeAddress; //导入方法依赖的package包/类
/**
 * 対象の行、列番号が結合されている場合は結合を解除する
 * 
 * @param sheet
 * @param removeRowNum
 * @param removeColNum
 */
private void removeRegion( Sheet sheet, int removeRowNum, int removeColNum) {
    // シート内の結合情報の数だけループする
    for ( int i = 0; i < sheet.getNumMergedRegions(); i++) {
        // 結合情報(Region)を取得する
        CellRangeAddress region = sheet.getMergedRegion( i);

        if ( removeRowNum != -1) {
            if ( region.getFirstRow() > removeRowNum || removeRowNum > region.getLastRow()) {
                continue;
            }
        }

        if ( removeColNum != -1) {
            if ( region.getFirstColumn() > removeColNum || removeColNum > region.getLastColumn()) {
                continue;
            }
        }
        // 引数の結合INDEXに該当する結合を解除する
        sheet.removeMergedRegion( i);
        return;
    }
}