/** * Gets the fully qualified cell reference given the column, row * external sheet reference etc * * @param sheet * @param column * @param colabs TRUE if the column is an absolute reference * @param row * @param rowabs TRUE if the row is an absolute reference * @param workbook * @param buf */ public static void getCellReference (int sheet, int column, boolean colabs, int row, boolean rowabs, ExternalSheet workbook, StringBuffer buf) { // WorkbookParser now appends quotes and escapes apostrophes String name = workbook.getExternalSheetName(sheet); buf.append(name); buf.append(sheetInd); getCellReference(column, colabs, row, rowabs, buf); }
/** * Gets the fully qualified cell reference given the column, row * external sheet reference etc * * @param sheet * @param column * @param colabs TRUE if the column is an absolute reference * @param row * @param rowabs TRUE if the row is an absolute reference * @param workbook * @param buf */ public static void getCellReference (int sheet, int column, boolean colabs, int row, boolean rowabs, ExternalSheet workbook, StringBuffer buf) { // WorkbookParser now appends quotes and escapes apostrophes String name = workbook.getExternalSheetName(sheet); buf.append(name); buf.append(sheetInd); getCellReference(column, colabs, row, rowabs, buf); }
/** * Gets the fully qualified cell reference given the column, row * external sheet reference etc * * @param sheet * @param column * @param row * @param workbook * @param buf */ public static void getCellReference (int sheet, int column, int row, ExternalSheet workbook, StringBuffer buf) { // Quotes are added by the WorkbookParser String name = workbook.getExternalSheetName(sheet); buf.append(StringHelper.replace(name, "\'", "\'\'")); buf.append(sheetInd); getCellReference(column, row, buf); }
/** * Gets the fully qualified cell reference given the column, row * external sheet reference etc * * @param sheet * @param column * @param row * @param workbook * @param buf */ public static void getCellReference (int sheet, int column, int row, ExternalSheet workbook, StringBuffer buf) { // Quotes are added by the WorkbookParser String name = workbook.getExternalSheetName(sheet); buf.append(StringHelper.replace(name, "\'", "\'\'")); buf.append(sheetInd); getCellReference(column, row, 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); } }
/** * 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); } }