net.sf.jasperreports.engine.export.ooxml.XlsxStyleHelper Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of jasperreports Show documentation
Show all versions of jasperreports Show documentation
Free Java Reporting Library
/*
* JasperReports - Free Java Reporting Library.
* Copyright (C) 2001 - 2019 TIBCO Software Inc. All rights reserved.
* http://www.jaspersoft.com
*
* Unless you have purchased a commercial license agreement from Jaspersoft,
* the following license terms apply:
*
* This program is part of JasperReports.
*
* JasperReports is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* JasperReports 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 Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with JasperReports. If not, see .
*/
package net.sf.jasperreports.engine.export.ooxml;
import java.io.IOException;
import java.io.Writer;
import java.util.HashMap;
import java.util.Locale;
import java.util.Map;
import net.sf.jasperreports.engine.JRRuntimeException;
import net.sf.jasperreports.engine.JasperReportsContext;
import net.sf.jasperreports.engine.export.JRExporterGridCell;
import net.sf.jasperreports.engine.export.JRXlsAbstractExporter;
import net.sf.jasperreports.engine.type.LineDirectionEnum;
import net.sf.jasperreports.engine.type.RotationEnum;
import net.sf.jasperreports.engine.util.FileBufferedWriter;
import net.sf.jasperreports.export.XlsReportConfiguration;
/**
* @author Teodor Danciu ([email protected])
*/
public class XlsxStyleHelper extends BaseHelper
{
/**
*
*/
private FileBufferedWriter formatsWriter = new FileBufferedWriter();
private FileBufferedWriter fontsWriter = new FileBufferedWriter();
private FileBufferedWriter fillsWriter = new FileBufferedWriter();
private FileBufferedWriter bordersWriter = new FileBufferedWriter();
private FileBufferedWriter cellXfsWriter = new FileBufferedWriter();
private Map styleCache = new HashMap();//FIXMEXLSX use soft cache? check other exporter caches as well
private XlsxFormatHelper formatHelper;
private XlsxFontHelper fontHelper;
private XlsxBorderHelper borderHelper;
/**
*
*/
public XlsxStyleHelper(
JasperReportsContext jasperReportsContext,
Writer writer,
String exporterKey
)
{
super(jasperReportsContext, writer);
formatHelper = new XlsxFormatHelper(jasperReportsContext, formatsWriter);
fontHelper = new XlsxFontHelper(jasperReportsContext, fontsWriter, exporterKey);
borderHelper = new XlsxBorderHelper(jasperReportsContext ,bordersWriter);
}
/**
*
*/
public void setConfiguration(XlsReportConfiguration configuration)
{
fontHelper.setConfiguration(configuration);
}
/**
*
*/
public int getCellStyle(
JRExporterGridCell gridCell,
String pattern,
Locale locale,
boolean isWrapText,
boolean isHidden,
boolean isLocked,
boolean isShrinkToFit,
boolean isIgnoreTextFormatting,
RotationEnum rotation,
JRXlsAbstractExporter.SheetInfo sheetInfo,
LineDirectionEnum direction
)
{
XlsxStyleInfo styleInfo =
new XlsxStyleInfo(
formatHelper.getFormat(pattern) + 1,
fontHelper.getFont(gridCell, locale) + 1,
borderHelper.getBorder(gridCell, sheetInfo, direction) + 1,
gridCell,
isWrapText,
isHidden,
isLocked,
isShrinkToFit,
isIgnoreTextFormatting,
getRotation(rotation),
sheetInfo,
direction
);
Integer styleIndex = styleCache.get(styleInfo.getId());
if (styleIndex == null)
{
styleIndex = styleCache.size() + 1;
exportCellStyle(gridCell, styleInfo, styleIndex, sheetInfo);
styleCache.put(styleInfo.getId(), styleIndex);
}
return styleIndex;
}
/**
*
*/
private void exportCellStyle(
JRExporterGridCell gridCell,
XlsxStyleInfo styleInfo,
Integer styleIndex,
JRXlsAbstractExporter.SheetInfo sheetInfo)
{
try
{
if (Boolean.TRUE.equals(sheetInfo.ignoreCellBackground) || styleInfo.backcolor == null)
{
if (Boolean.TRUE.equals(sheetInfo.whitePageBackground))
{
fillsWriter.write(" \n");
}
else
{
fillsWriter.write(" \n");
}
}
else
{
fillsWriter.write(" \n");
}
cellXfsWriter.write(
""
+ " "
);
cellXfsWriter.write(" ");
cellXfsWriter.write(" \n");
}
catch (IOException e)
{
throw new JRRuntimeException(e);
}
}
/**
*
*/
public void export()
{
write("\n");
write("\n");
write("\n");// count=\"1\">\n");
write("\n");
formatsWriter.writeData(writer);
write(" \n");
write("\n");// count=\"1\">\n");
write(" \n");
fontsWriter.writeData(writer);
write(" \n");
write("\n");// count=\"2\">\n");
write(" \n");
write(" \n");
fillsWriter.writeData(writer);
write(" \n");
write("\n");// count=\"1\">\n");
write(" \n");
bordersWriter.writeData(writer);
write(" \n");
write(" \n");
write("\n");// count=\"1\">\n");
write("\n");
cellXfsWriter.writeData(writer);
write(" \n");
//write(" \n");
write("\n");
write(" \n");
}
/**
*
*/
protected int getRotation(RotationEnum rotation)
{
int result = 0;
if (rotation != null)
{
switch(rotation)
{
case LEFT:
{
result = 90;
break;
}
case RIGHT:
{
result = 180;
break;
}
case UPSIDE_DOWN:
case NONE:
default:
{
}
}
}
return result;
}
}