/** * Gets the column letter corresponding to the 0-based column number * * @param c the column number * @return the letter for that column number */ public static String getColumnReference(int c) { return jxl.biff.CellReferenceHelper.getColumnReference(c); }
/** * Gets the column letter corresponding to the 0-based column number * * @param c the column number * @return the letter for that column number */ public static String getColumnReference(int c) { return jxl.biff.CellReferenceHelper.getColumnReference(c); }
/** * Gets the column letter corresponding to the 0-based column number * * @param column the column number * @return the letter for that column number */ public static String getColumnReference(int column) { StringBuffer buf = new StringBuffer(); getColumnReference(column, buf); return buf.toString(); }
/** * Gets the column letter corresponding to the 0-based column number * * @param column the column number * @return the letter for that column number */ public static String getColumnReference(int column) { StringBuffer buf = new StringBuffer(); getColumnReference(column, buf); return buf.toString(); }
/** * Gets the cell reference * * @param column * @param row * @param buf */ public static void getCellReference(int column, int row, StringBuffer buf) { // Put the column letter into the buffer getColumnReference(column, buf); // Add the row into the buffer buf.append(Integer.toString(row+1)); }
/** * Gets the cell reference * * @param column * @param row * @param buf */ public static void getCellReference(int column, int row, StringBuffer buf) { // Put the column letter into the buffer getColumnReference(column, buf); // Add the row into the buffer buf.append(Integer.toString(row+1)); }
/** * Gets the string representation of this item * * @param buf the string buffer */ public void getString(StringBuffer buf) { CellReferenceHelper.getColumnReference(getFirstColumn(), buf); buf.append(':'); CellReferenceHelper.getColumnReference(getLastColumn(), buf); } }
/** * Gets the string representation of this item * * @param buf the string buffer */ public void getString(StringBuffer buf) { CellReferenceHelper.getColumnReference(getFirstColumn(), buf); buf.append(':'); CellReferenceHelper.getColumnReference(getLastColumn(), buf); } }
/** * Overloaded method which prepends $ for absolute reference * * @param column * @param colabs TRUE if the column reference is absolute * @param row * @param rowabs TRUE if the row reference is absolute * @param buf */ public static void getCellReference(int column, boolean colabs, int row, boolean rowabs, StringBuffer buf) { if (colabs) { buf.append(fixedInd); } // Put the column letter into the buffer getColumnReference(column, buf); if (rowabs) { buf.append(fixedInd); } // Add the row into the buffer buf.append(Integer.toString(row+1)); }
/** * Overloaded method which prepends $ for absolute reference * * @param column * @param colabs TRUE if the column reference is absolute * @param row * @param rowabs TRUE if the row reference is absolute * @param buf */ public static void getCellReference(int column, boolean colabs, int row, boolean rowabs, StringBuffer buf) { if (colabs) { buf.append(fixedInd); } // Put the column letter into the buffer getColumnReference(column, buf); if (rowabs) { buf.append(fixedInd); } // Add the row into the buffer buf.append(Integer.toString(row+1)); }
/** * Gets the string representation of this column range * * @param buf the string buffer to append to */ public void getString(StringBuffer buf) { buf.append('\''); buf.append(workbook.getExternalSheetName(sheet)); buf.append('\''); buf.append('!'); CellReferenceHelper.getColumnReference(getFirstColumn(), buf); buf.append(':'); CellReferenceHelper.getColumnReference(getLastColumn(), buf); } }
/** * Gets the string representation of this column range * * @param buf the string buffer to append to */ public void getString(StringBuffer buf) { buf.append('\''); buf.append(workbook.getExternalSheetName(sheet)); buf.append('\''); buf.append('!'); CellReferenceHelper.getColumnReference(getFirstColumn(), buf); buf.append(':'); CellReferenceHelper.getColumnReference(getLastColumn(), buf); } }