/////////////////////////////////////////////////////////////////////////////
//
// Project ProjectForge Community Edition
// www.projectforge.org
//
// Copyright (C) 2001-2014 Kai Reinhard (k.reinhard@micromata.de)
//
// ProjectForge is dual-licensed.
//
// This community edition is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License as published
// by the Free Software Foundation; version 3 of the License.
//
// This community edition is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General
// Public License for more details.
//
// You should have received a copy of the GNU General Public License along
// with this program; if not, see http://www.gnu.org/licenses/.
//
/////////////////////////////////////////////////////////////////////////////
package org.projectforge.export;
import java.lang.reflect.Field;
import org.projectforge.common.DateFormatType;
import org.projectforge.common.DateFormats;
import org.projectforge.core.PropertyInfo;
import org.projectforge.core.PropertyType;
import org.projectforge.excel.CellFormat;
import org.projectforge.excel.ContentProvider;
import org.projectforge.excel.ExcelExporter;
import org.projectforge.excel.ExportColumn;
import org.projectforge.excel.ExportSheet;
/**
* @author Kai Reinhard (k.reinhard@micromata.de)
*
*/
public class MyExcelExporter extends ExcelExporter
{
/**
* @param filename
*/
public MyExcelExporter(final String filename)
{
super(filename);
}
public ExportSheet addSheet(final String sheetTitle)
{
final ContentProvider contentProvider = new MyXlsContentProvider(getWorkbook()) {
/**
* @see org.projectforge.export.MyXlsContentProvider#getCustomizedCellFormat(org.projectforge.excel.CellFormat, java.lang.Object)
*/
@Override
protected CellFormat getCustomizedCellFormat(final CellFormat format, final Object value)
{
return null;
}
};
return addSheet(contentProvider, sheetTitle);
}
/**
* Adds customized formats. Put here your customized formats to your ExportSheet.
* @param field
* @param propInfo may-be null.
* @param column
* @return true, if format is handled by this method, otherwise false.
*/
@Override
public void putFieldFormat(final ContentProvider sheetProvider, final Field field, final PropertyInfo propInfo,
final ExportColumn exportColumn)
{
final PropertyType type = propInfo.type();
if (type == PropertyType.DATE) {
sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE));
exportColumn.setWidth(10);
} else if (type == PropertyType.DATE_TIME) {
sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_MINUTES));
exportColumn.setWidth(10);
} else if (type == PropertyType.DATE_TIME_SECONDS) {
sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_SECONDS));
exportColumn.setWidth(16);
} else if (type == PropertyType.DATE_TIME_MILLIS) {
sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_MILLIS));
exportColumn.setWidth(18);
} else if (type == PropertyType.UNSPECIFIED) {
if (java.sql.Date.class.isAssignableFrom(field.getType()) == true) {
sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE));
exportColumn.setWidth(10);
} else if (java.util.Date.class.isAssignableFrom(field.getType()) == true) {
sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_MINUTES));
exportColumn.setWidth(16);
} else {
super.putFieldFormat(sheetProvider, field, propInfo, exportColumn);
}
} else {
super.putFieldFormat(sheetProvider, field, propInfo, exportColumn);
}
}
}