Java CellReference.getCol方法代碼示例

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
public static A1Address fromA1Address(String a1address) {
    //check in pool
    A1Address address = A1AddressPool.get(a1address);
    if (address != null) { return address; }
    
    //check if range
    if (isRange(a1address)) { return new A1RangeAddress(a1address); }
    
    //create
    A1Address a = new A1Address();
    a.address = a1address;

    CellReference cr = new CellReference(a.address);
    a.row = cr.getRow();
    a.column = cr.getCol();

    return a;
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
public boolean isReferenceValid(CellReference ref) {
    if(ref == null)
        return false;
    
    String sheet = ref.getSheetName();
    if(sheet == null || sheet.length()==0 || !sheets.contains(sheet))
        return false;
    
    if(ref.getCol() >= getMaxCol())
        return false;
    
    if(ref.getRow() >= getMaxRow())
        return false;
    
    return true;
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
public final static int[] getXY(String xy) {
	xy = xy.trim();
	if (StringUtils.isEmpty(xy)) {
		return new int[] { -1, -1 };
	}
	if (!StringUtils.isAlphanumeric(xy)) {
		return null;
	}
	CellReference ref = new CellReference(xy);
	return new int[] { ref.getRow() < 0 ? -1 : ref.getRow(), ref.getCol() < 0 ? -1 : ref.getCol() };
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
protected int[] getXY(String xy) {
	xy = xy.trim();
	if (StringUtils.isEmpty(xy)) {
		return new int[] { -1, -1 };
	}
	if (!StringUtils.isAlphanumeric(xy)) {
		return null;
	}
	CellReference ref = new CellReference(xy);
	return new int[] { ref.getRow() < 0 ? -1 : ref.getRow(), ref.getCol() < 0 ? -1 : ref.getCol() };
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
/**
 * Excelのアドレス形式'A1'を、Pointに変換する。
 * @param address
 * @return 変換できない場合は、nullを返す。
 */
public static Point parseCellAddress(final String address) {
    
    if(isEmpty(address)) {
        return null;
    }
    
    final Matcher matcher = PATTERN_CELL_ADREESS.matcher(address);
    if(!matcher.matches()) {
        return null;
    }
    
    final CellReference ref = new CellReference(address.toUpperCase());
    return new Point(ref.getCol(), ref.getRow());
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
/**
 * 文字列の形式のセルのアドレスを、Point形式に変換する。
 * @param address
 * @return
 */
public static Point toPointAddress(final String address) {
    ArgUtils.notEmpty(address, "address");
    
    CellReference ref = new CellReference(address);
    return new Point(ref.getCol(), ref.getRow());
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
@Override
public void cell(String cellReference, String formattedValue,XSSFComment comment) {
	if(currentOutputRow!=-1){
		CellReference ref = new CellReference(cellReference);
		int col = ref.getCol();
		if(col < table.getColumnCount()){
			table.setValueAt(formattedValue, currentOutputRow, col);					
		}
	}
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
public boolean isOverlapped(Name name) {
	String ref = name.getRefersToFormula();
	int idx = ref.indexOf('!');
	if (idx != -1) {
		ref = ref.substring(idx + 1);
	}
	AreaReference area = new AreaReference(ref);
	CellReference topLeft = area.getFirstCell();
	CellReference bottomRight = area.getLastCell();
	CellRangeAddress cra = new CellRangeAddress(
		topLeft.getRow(), bottomRight.getRow(), 
		topLeft.getCol(), bottomRight.getCol()
	);
	return isOverlapped(cra);
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
private String setColumnName(String cellReference, String columnName)
{
  CellReference reference = new CellReference(cellReference);
  Integer column = new Integer(reference.getCol());

  return this.map.put(column, columnName);
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
private String getColumnName(String cellReference)
{
  CellReference reference = new CellReference(cellReference);
  Integer column = new Integer(reference.getCol());

  return this.map.get(column);
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
public Field getField(String cellReference)
{
  CellReference reference = new CellReference(cellReference);
  Integer column = new Integer(reference.getCol());

  if (!this.map.containsKey(column))
  {
    this.map.put(column, new Field());
  }

  return this.map.get(column);
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
public static CellReference getValidCellReference(Workbook wb, String ref) {
    CellReference cr = getCellReference(wb, ref);
    String shName = cr.getSheetName();
    if(shName == null || wb.getSheetIndex(shName) < 0 || 
            cr.getRow() < 0 || cr.getCol() < 0)
        return null;
    return cr;
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
public XlsxTableReader(CellReference ref, TableFactory<T> factory) {
    this.factory = factory;
    sheetName = ref.getSheetName();
    firstRow = ref.getRow();
    prevRow = firstRow;
    firstColumn = ref.getCol();
    prevColumn = firstColumn;
    lastColumn = firstColumn;
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
public XlsTableReader(CellReference ref, TableFactory<T> factory) {
    this.factory = factory;
    sheetName = ref.getSheetName();
    firstRow = ref.getRow();
    firstColumn = ref.getCol();
    lastColumn = firstColumn;
    prevRow = firstRow;
}
 

import org.apache.poi.ss.util.CellReference; //導入方法依賴的package包/類
public static int getColumnIndex(String name) {
	CellReference ref = new CellReference(name);
	return ref.getCol();
}