public MyXlsExportContext() { if (initialized == false) { initialized = true; ExportConfig.setInstance(new ExportConfig() { @Override protected ContentProvider createNewContentProvider(final ExportWorkbook workbook) { return new MyXlsContentProvider(workbook); } }.setDefaultExportContext(new MyXlsExportContext())); } }
public MyXlsContentProvider(final ExportWorkbook workbook) { super(new MyXlsExportContext(), workbook); defaultFormatMap.put(DateHolder.class, new CellFormat("YYYY-MM-DD").setAutoDatePrecision(true)); // format unused. defaultFormatMap.put(DayHolder.class, new CellFormat(DateFormats.getExcelFormatString(DateFormatType.DATE))); }
private void internalInit(ApplicationContext applicationContext, final boolean developmentMode) { log.info("Initializing..."); this.applicationContext = applicationContext; this.databaseUpdater = applicationContext.getBean(DatabaseService.class); this.userXmlPreferencesCache = applicationContext.getBean(UserXmlPreferencesCache.class); this.systemInfoCache = applicationContext.getBean(SystemInfoCache.class); Registry.getInstance().init(applicationContext); // Time zone log.info("Default TimeZone is: " + TimeZone.getDefault()); if ("UTC".equals(TimeZone.getDefault().getID()) == false) { for (final String str : UTC_RECOMMENDED) { log.error(str); } for (final String str : UTC_RECOMMENDED) { System.err.println(str); } } log.info("user.timezone is: " + System.getProperty("user.timezone")); // Initialize Excel extensions: new MyXlsExportContext(); // HIBERNATE5 // HibernateUtils.setConfiguration(hibernateConfiguration); if (DatabaseSupport.getInstance() == null) { DatabaseSupport.setInstance(new DatabaseSupport(HibernateUtils.getDialect())); } SystemInfoCache.internalInitialize(systemInfoCache); this.initialized = true; }
}.setDefaultExportContext(new MyXlsExportContext())); final ExportWorkbook workbook = new ExportWorkbook(); final ExportSheet sheet = workbook.addSheet("Test");