public static String convert( Locale locale, DateFormat df ) { String ptrn = ((SimpleDateFormat)df).toPattern(); return convert(locale, ptrn); }
public static String convert( Locale locale, String format ) { StringBuilder result = new StringBuilder(); result.append(getPrefixForLocale(locale)); DateFormatTokenizer tokenizer = new DateFormatTokenizer(format); String token; while( ( token = tokenizer.getNextToken() ) != null ) { if( token.startsWith("'") ) { result.append( token.replaceAll("'", "\"") ); } else if( ! Character.isLetter( token.charAt( 0 ) ) ) { result.append( token ); } else { // It's a code, translate it if necessary String mappedToken = tokenConversions.get(token); result.append( mappedToken == null ? token : mappedToken ); } } result.append(";@"); return result.toString().trim(); }
public static String convert( Locale locale, DateFormat df ) { String ptrn = ((SimpleDateFormat)df).toPattern(); return convert(locale, ptrn); }
public static String convert( Locale locale, String format ) { StringBuilder result = new StringBuilder(); result.append(getPrefixForLocale(locale)); DateFormatTokenizer tokenizer = new DateFormatTokenizer(format); String token; while( ( token = tokenizer.getNextToken() ) != null ) { if( token.startsWith("'") ) { result.append( token.replaceAll("'", "\"") ); } else if( ! Character.isLetter( token.charAt( 0 ) ) ) { result.append( token ); } else { // It's a code, translate it if necessary String mappedToken = tokenConversions.get(token); result.append( mappedToken == null ? token : mappedToken ); } } result.append(";@"); return result.toString().trim(); }
public static String convert( Locale locale, DateFormat df ) { String ptrn = ((SimpleDateFormat)df).toPattern(); return convert(locale, ptrn); }
public static String convert( Locale locale, String format ) { StringBuilder result = new StringBuilder(); result.append(getPrefixForLocale(locale)); DateFormatTokenizer tokenizer = new DateFormatTokenizer(format); String token; while( ( token = tokenizer.getNextToken() ) != null ) { if( token.startsWith("'") ) { result.append( token.replaceAll("'", "\"") ); } else if( ! Character.isLetter( token.charAt( 0 ) ) ) { result.append( token ); } else { // It's a code, translate it if necessary String mappedToken = tokenConversions.get(token); result.append( mappedToken == null ? token : mappedToken ); } } result.append(";@"); return result.toString().trim(); }
public static String convert( Locale locale, DateFormat df ) { String ptrn = ((SimpleDateFormat)df).toPattern(); return convert(locale, ptrn); }
public static String convert( Locale locale, String format ) { StringBuilder result = new StringBuilder(); result.append(getPrefixForLocale(locale)); DateFormatTokenizer tokenizer = new DateFormatTokenizer(format); String token; while( ( token = tokenizer.getNextToken() ) != null ) { if( token.startsWith("'") ) { result.append( token.replaceAll("'", "\"") ); } else if( ! Character.isLetter( token.charAt( 0 ) ) ) { result.append( token ); } else { // It's a code, translate it if necessary String mappedToken = tokenConversions.get(token); result.append( mappedToken == null ? token : mappedToken ); } } result.append(";@"); return result.toString().trim(); }
public ExporterFormatter(String dateTimeFormat, String dateFormat, String timeFormat, String decimalFormat, String integerFormat, String currencyFormat, Locale locale) { this.locale = locale; this.dateTimeFormat = new SimpleDateFormat(dateTimeFormat); this.dateFormat = new SimpleDateFormat(dateFormat, locale); this.timeFormat = new SimpleDateFormat(timeFormat, locale); this.decimalFormat = new DecimalFormat(decimalFormat, DecimalFormatSymbols.getInstance(locale)); this.integerFormat = new DecimalFormat(integerFormat, DecimalFormatSymbols.getInstance(locale)); this.currencyFormat = new DecimalFormat(currencyFormat, DecimalFormatSymbols.getInstance(locale)); this.cellDateTimeFormat = DateFormatConverter.convert(locale, dateTimeFormat); this.cellDateFormat = DateFormatConverter.convert(locale, dateFormat); this.cellTimeFormat = DateFormatConverter.convert(locale, timeFormat); this.cellCurrencyFormat = DateFormatConverter.convert(locale, currencyFormat); this.cellDecimalFormat = DateFormatConverter.convert(locale, decimalFormat); this.cellIntegerFormat = DateFormatConverter.convert(locale, integerFormat); }
public ExporterFormatter(Locale locale) { this.locale = locale; this.dateTimeFormat = (SimpleDateFormat) SimpleDateFormat.getDateTimeInstance(DateFormat.MEDIUM, DateFormat.MEDIUM, locale); this.dateFormat = (SimpleDateFormat) SimpleDateFormat.getDateInstance(DateFormat.MEDIUM, locale); this.timeFormat = (SimpleDateFormat) SimpleDateFormat.getTimeInstance(DateFormat.SHORT, locale); this.decimalFormat = (DecimalFormat) DecimalFormat.getInstance(locale); this.integerFormat = (DecimalFormat) DecimalFormat.getIntegerInstance(locale); this.currencyFormat = (DecimalFormat) DecimalFormat.getCurrencyInstance(locale == Locale.ENGLISH ? Locale.US : locale); this.cellDateTimeFormat = DateFormatConverter.convert(locale, dateTimeFormat.toPattern()); this.cellDateFormat = DateFormatConverter.convert(locale, dateFormat.toPattern()); this.cellTimeFormat = DateFormatConverter.convert(locale, timeFormat.toPattern()); this.cellDecimalFormat = DateFormatConverter.convert(locale, decimalFormat.toPattern()); this.cellIntegerFormat = DateFormatConverter.convert(locale, integerFormat.toPattern()); this.cellCurrencyFormat = DateFormatConverter.convert(locale, getCurrencyFormatString()); }
style.setFont(cellFont); style.setWrapText(false); style.setDataFormat(wb.createDataFormat().getFormat( DateFormatConverter.convert( Locale.getDefault(), dateFormatPattern ))); styles.put("date_cell", style); return styles;
style.setFont(cellFont); style.setWrapText(false); style.setDataFormat(wb.createDataFormat().getFormat( DateFormatConverter.convert( Locale.getDefault(), dateFormatPattern ))); styles.put("date_cell", style); return styles;