Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
/*
* JasperReports - Free Java Reporting Library.
* Copyright (C) 2001 - 2016 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 = Integer.valueOf(styleCache.size() + 1);
exportCellStyle(gridCell, styleInfo, styleIndex, sheetInfo);
styleCache.put(styleInfo.getId(), styleIndex);
}
return styleIndex.intValue();
}
/**
*
*/
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;
}
}