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.
net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter Maven / Gradle / Ivy
/*
* JasperReports - Free Java Reporting Library.
* Copyright (C) 2001 - 2014 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 [email protected] )
*/
public class JRXlsxExporter extends JRXlsAbstractExporter
{
private static final Log log = LogFactory.getLog(JRXlsxExporter.class);
/**
* The exporter key, as used in
* {@link GenericElementHandlerEnviroment#getElementHandler(JRGenericElementType, String)}.
*/
public static final String XLSX_EXPORTER_KEY = JRPropertiesUtil.PROPERTY_PREFIX + "xlsx";
protected static final String XLSX_EXPORTER_PROPERTIES_PREFIX = JRPropertiesUtil.PROPERTY_PREFIX + "export.xlsx.";
protected static final String ONE_CELL = "oneCell";
protected static final String TWO_CELL = "twoCell";
protected static final String ABSOLUTE = "absolute";
/**
* @deprecated Replaced by {@link XlsxExporterConfiguration#PROPERTY_MACRO_TEMPLATE}.
*/
public static final String PROPERTY_MACRO_TEMPLATE = XlsxExporterConfiguration.PROPERTY_MACRO_TEMPLATE;
/**
*
*/
protected static final String JR_PAGE_ANCHOR_PREFIX = "JR_PAGE_ANCHOR_";
/**
*
*/
public static final String IMAGE_NAME_PREFIX = "img_";
protected static final int IMAGE_NAME_PREFIX_LEGTH = IMAGE_NAME_PREFIX.length();
/**
*
*/
protected XlsxZip xlsxZip;
protected XlsxWorkbookHelper wbHelper;
protected XlsxRelsHelper relsHelper;
protected XlsxContentTypesHelper ctHelper;
protected XlsxSheetHelper sheetHelper;
protected XlsxSheetRelsHelper sheetRelsHelper;
protected XlsxDrawingHelper drawingHelper;
protected XlsxDrawingRelsHelper drawingRelsHelper;
protected XlsxStyleHelper styleHelper;
protected XlsxCellHelper cellHelper;//FIXMEXLSX maybe cell helper should be part of sheet helper, just like in table helper
protected StringBuffer definedNames;
protected String firstSheetName;
protected String currentSheetName;
protected Map rendererToImagePathMap;
// protected Map imageMaps;
protected List imagesToProcess;
// protected Map hyperlinksMap;
protected int tableIndex;
protected boolean startPage;
protected LinkedList backcolorStack = new LinkedList();
protected Color backcolor;
private XlsxRunHelper runHelper;
protected String sheetAutoFilter;
protected String macroTemplate;
protected PrintPageFormat oldPageFormat;
protected Integer currentSheetPageScale;
protected Integer currentSheetFirstPageNumber;
protected class ExporterContext extends BaseExporterContext implements JRXlsxExporterContext
{
}
/**
* @see #JRXlsxExporter(JasperReportsContext)
*/
public JRXlsxExporter()
{
this(DefaultJasperReportsContext.getInstance());
}
/**
*
*/
public JRXlsxExporter(JasperReportsContext jasperReportsContext)
{
super(jasperReportsContext);
exporterContext = new ExporterContext();
}
/**
*
*/
protected Class getConfigurationInterface()
{
return XlsxExporterConfiguration.class;
}
/**
*
*/
protected Class getItemConfigurationInterface()
{
return XlsxReportConfiguration.class;
}
@Override
protected void initExport()
{
super.initExport();
}
@Override
protected void initReport()
{
super.initReport();
XlsReportConfiguration configuration = getCurrentItemConfiguration();
styleHelper.setConfiguration(configuration);
nature =
new JRXlsxExporterNature(
jasperReportsContext,
filter,
configuration.isIgnoreGraphics(),
configuration.isIgnorePageMargins()
);
}
@Override
protected int exportPage(JRPrintPage page, CutsInfo xCuts, int startRow, String defaultSheetName) throws JRException
{
if (oldPageFormat != pageFormat)
{
oldPageFormat = pageFormat;
}
return super.exportPage(page, xCuts, startRow, defaultSheetName);
}
public JRPrintImage getImage(ExporterInput exporterInput, JRPrintElementIndex imageIndex) throws JRException//FIXMECONTEXT move these to an abstract up?
{
List items = exporterInput.getItems();
ExporterInputItem item = items.get(imageIndex.getReportIndex());
JasperPrint report = item.getJasperPrint();
JRPrintPage page = report.getPages().get(imageIndex.getPageIndex());
Integer[] elementIndexes = imageIndex.getAddressArray();
Object element = page.getElements().get(elementIndexes[0].intValue());
for (int i = 1; i < elementIndexes.length; ++i)
{
JRPrintFrame frame = (JRPrintFrame) element;
element = frame.getElements().get(elementIndexes[i].intValue());
}
if(element instanceof JRGenericPrintElement)
{
JRGenericPrintElement genericPrintElement = (JRGenericPrintElement)element;
return ((GenericElementXlsxHandler)GenericElementHandlerEnviroment.getInstance(jasperReportsContext).getElementHandler(
genericPrintElement.getGenericType(),
XLSX_EXPORTER_KEY
)).getImage(exporterContext, genericPrintElement);
}
return (JRPrintImage) element;
}
/**
*
*/
protected void exportStyledText(JRStyle style, JRStyledText styledText, Locale locale, boolean isStyledText)
{
String text = styledText.getText();
int runLimit = 0;
AttributedCharacterIterator iterator = styledText.getAttributedString().getIterator();
while(runLimit < styledText.length() && (runLimit = iterator.getRunLimit()) <= styledText.length())
{
runHelper.export(
style, iterator.getAttributes(),
text.substring(iterator.getIndex(), runLimit),
locale,
invalidCharReplacement,
isStyledText
);
iterator.setIndex(runLimit);
}
}
/**
*
*/
protected String getImagePath(Renderable renderer, boolean isLazy, JRExporterGridCell gridCell)
{
String imagePath = null;
if (renderer != null)
{
if (renderer.getTypeValue() == RenderableTypeEnum.IMAGE && rendererToImagePathMap.containsKey(renderer.getId()))
{
imagePath = rendererToImagePathMap.get(renderer.getId());
}
else
{
// if (isLazy)//FIXMEDOCX learn how to link images
// {
// imagePath = ((JRImageRenderer)renderer).getImageLocation();
// }
// else
// {
JRPrintElementIndex imageIndex = getElementIndex(gridCell);
imagesToProcess.add(imageIndex);
String mimeType = renderer.getImageTypeValue().getMimeType();//FIXMEPPTX this code for file extension is duplicated
if (mimeType == null)
{
mimeType = ImageTypeEnum.JPEG.getMimeType();
}
String extension = mimeType.substring(mimeType.lastIndexOf('/') + 1);
String imageName = IMAGE_NAME_PREFIX + imageIndex.toString() + "." + extension;
imagePath = imageName;
//imagePath = "Pictures/" + imageName;
// }
rendererToImagePathMap.put(renderer.getId(), imagePath);
}
}
return imagePath;
}
protected JRPrintElementIndex getElementIndex(JRExporterGridCell gridCell)
{
JRPrintElementIndex imageIndex =
new JRPrintElementIndex(
reportIndex,
pageIndex,
gridCell.getElementAddress()
);
return imageIndex;
}
/**
*
*
protected void writeImageMap(String imageMapName, JRPrintHyperlink mainHyperlink, List imageMapAreas) throws IOException
{
writer.write("\n");
for (Iterator it = imageMapAreas.iterator(); it.hasNext();)
{
JRPrintImageAreaHyperlink areaHyperlink = (JRPrintImageAreaHyperlink) it.next();
JRPrintImageArea area = areaHyperlink.getArea();
writer.write(" \n");
}
protected void writeImageAreaCoordinates(JRPrintImageArea area) throws IOException
{
int[] coords = area.getCoordinates();
if (coords != null && coords.length > 0)
{
StringBuffer coordsEnum = new StringBuffer(coords.length * 4);
coordsEnum.append(coords[0]);
for (int i = 1; i < coords.length; i++)
{
coordsEnum.append(',');
coordsEnum.append(coords[i]);
}
writer.write(" coords=\"" + coordsEnum + "\"");
}
}
protected void writeImageAreaHyperlink(JRPrintHyperlink hyperlink) throws IOException
{
String href = getHyperlinkURL(hyperlink);
if (href == null)
{
writer.write(" nohref=\"nohref\"");
}
else
{
writer.write(" href=\"" + href + "\"");
String target = getHyperlinkTarget(hyperlink);
if (target != null)
{
writer.write(" target=\"");
writer.write(target);
writer.write("\"");
}
}
if (hyperlink.getHyperlinkTooltip() != null)
{
writer.write(" title=\"");
writer.write(JRStringUtil.xmlEncode(hyperlink.getHyperlinkTooltip()));
writer.write("\"");
}
}
/**
*
*/
public static JRPrintElementIndex getPrintElementIndex(String imageName)
{
if (!imageName.startsWith(IMAGE_NAME_PREFIX))
{
throw new JRRuntimeException("Invalid image name: " + imageName);
}
return JRPrintElementIndex.parsePrintElementIndex(imageName.substring(IMAGE_NAME_PREFIX_LEGTH));
}
/**
*
*/
protected void setBackcolor(Color color)
{
backcolorStack.addLast(backcolor);
backcolor = color;
}
protected void restoreBackcolor()
{
backcolor = backcolorStack.removeLast();
}
// private float getXAlignFactor(JRPrintImage image)
// {
// float xalignFactor = 0f;
// switch (image.getHorizontalAlignmentValue())
// {
// case RIGHT :
// {
// xalignFactor = 1f;
// break;
// }
// case CENTER :
// {
// xalignFactor = 0.5f;
// break;
// }
// case LEFT :
// default :
// {
// xalignFactor = 0f;
// break;
// }
// }
// return xalignFactor;
// }
// private float getYAlignFactor(JRPrintImage image)
// {
// float yalignFactor = 0f;
// switch (image.getVerticalAlignmentValue())
// {
// case BOTTOM :
// {
// yalignFactor = 1f;
// break;
// }
// case MIDDLE :
// {
// yalignFactor = 0.5f;
// break;
// }
// case TOP :
// default :
// {
// yalignFactor = 0f;
// break;
// }
// }
// return yalignFactor;
// }
// protected boolean startHyperlink(JRPrintHyperlink link, boolean isText)
// {
// String href = getHyperlinkURL(link);
//
// if (href != null)
// {
// String id = (String)hyperlinksMap.get(href);
// if (id == null)
// {
// id = "rIdLnk" + hyperlinksMap.size();
// hyperlinksMap.put(href, id);
// }
////
//// wbHelper.write("\n");
//
// sheetRelsHelper.exportHyperlink(id, href);
//
//// String tooltip = link.getHyperlinkTooltip();
//// if (tooltip != null)
//// {
//// wbHelper.write(" \\o \"" + JRStringUtil.xmlEncode(tooltip) + "\"");
//// }
////
//// wbHelper.write(" \n");
//// wbHelper.write(" \n");
// wbHelper.write(""+ ref +" \n");
startPage = false;
}
}
protected void addBlankCell(
JRExporterGridCell gridCell,
int colIndex,
int rowIndex
) throws JRException
{
cellHelper.exportHeader(gridCell, rowIndex, colIndex);
cellHelper.exportFooter();
}
protected void closeWorkbook(OutputStream os) throws JRException //FIXMEXLSX could throw IOException here, as other implementations do
{
styleHelper.export();
styleHelper.close();
try
{
wbHelper.exportFooter();
wbHelper.close();
if ((imagesToProcess != null && imagesToProcess.size() > 0))
{
for(Iterator it = imagesToProcess.iterator(); it.hasNext();)
{
JRPrintElementIndex imageIndex = it.next();
JRPrintImage image = getImage(exporterInput, imageIndex);
Renderable renderer = image.getRenderable();
if (renderer.getTypeValue() == RenderableTypeEnum.SVG)
{
renderer =
new JRWrappingSvgRenderer(
renderer,
new Dimension(image.getWidth(), image.getHeight()),
ModeEnum.OPAQUE == image.getModeValue() ? image.getBackcolor() : null
);
}
String mimeType = renderer.getImageTypeValue().getMimeType();
if (mimeType == null)
{
mimeType = ImageTypeEnum.JPEG.getMimeType();
}
String extension = mimeType.substring(mimeType.lastIndexOf('/') + 1);
String imageName = IMAGE_NAME_PREFIX + imageIndex.toString() + "." + extension;
xlsxZip.addEntry(//FIXMEDOCX optimize with a different implementation of entry
new FileBufferedZipEntry(
"xl/media/" + imageName,
renderer.getImageData(jasperReportsContext)
)
);
// drawingRelsHelper.exportImage(imageName);
}
}
// if ((hyperlinksMap != null && hyperlinksMap.size() > 0))
// {
// for(Iterator it = hyperlinksMap.keySet().iterator(); it.hasNext();)
// {
// String href = (String)it.next();
// String id = (String)hyperlinksMap.get(href);
//
// relsHelper.exportHyperlink(id, href);
// }
// }
relsHelper.exportFooter();
relsHelper.close();
ctHelper.exportFooter();
ctHelper.close();
xlsxZip.zipEntries(os);
xlsxZip.dispose();
}
catch (IOException e)
{
throw new JRException(e);
}
}
protected void createSheet(CutsInfo xCuts, SheetInfo sheetInfo)
{
startPage = true;
currentSheetPageScale = sheetInfo.sheetPageScale;
currentSheetFirstPageNumber = sheetInfo.sheetFirstPageNumber;
currentSheetName = sheetInfo.sheetName;
firstSheetName = firstSheetName == null ? currentSheetName : firstSheetName;
wbHelper.exportSheet(sheetIndex + 1, currentSheetName);
ctHelper.exportSheet(sheetIndex + 1);
relsHelper.exportSheet(sheetIndex + 1);
ExportZipEntry sheetRelsEntry = xlsxZip.addSheetRels(sheetIndex + 1);
Writer sheetRelsWriter = sheetRelsEntry.getWriter();
sheetRelsHelper = new XlsxSheetRelsHelper(jasperReportsContext, sheetRelsWriter);
ExportZipEntry sheetEntry = xlsxZip.addSheet(sheetIndex + 1);
Writer sheetWriter = sheetEntry.getWriter();
sheetHelper =
new XlsxSheetHelper(
jasperReportsContext,
sheetWriter,
sheetRelsHelper,
getCurrentItemConfiguration()
);
ExportZipEntry drawingRelsEntry = xlsxZip.addDrawingRels(sheetIndex + 1);
Writer drawingRelsWriter = drawingRelsEntry.getWriter();
drawingRelsHelper = new XlsxDrawingRelsHelper(jasperReportsContext, drawingRelsWriter);
ExportZipEntry drawingEntry = xlsxZip.addDrawing(sheetIndex + 1);
Writer drawingWriter = drawingEntry.getWriter();
drawingHelper = new XlsxDrawingHelper(jasperReportsContext, drawingWriter, drawingRelsHelper);
cellHelper = new XlsxCellHelper(jasperReportsContext, sheetWriter, styleHelper);
runHelper = new XlsxRunHelper(jasperReportsContext, sheetWriter, null);//FIXMEXLSX check this null
boolean showGridlines = true;
if (sheetInfo.sheetShowGridlines == null)
{
Boolean documentShowGridlines = getCurrentItemConfiguration().isShowGridLines();
if (documentShowGridlines != null)
{
showGridlines = documentShowGridlines;
}
}
else
{
showGridlines = sheetInfo.sheetShowGridlines;
}
sheetHelper.exportHeader(showGridlines, (sheetInfo.sheetPageScale == null ? 0 : sheetInfo.sheetPageScale), gridRowFreezeIndex, gridColumnFreezeIndex, jasperPrint);
sheetRelsHelper.exportHeader(sheetIndex + 1);
drawingHelper.exportHeader();
drawingRelsHelper.exportHeader();
}
@Override
protected void closeSheet()
{
if (sheetHelper != null)
{
XlsReportConfiguration configuration = getCurrentItemConfiguration();
boolean isIgnorePageMargins = configuration.isIgnorePageMargins();
if(currentSheetFirstPageNumber != null && currentSheetFirstPageNumber > 0)
{
sheetHelper.exportFooter(
sheetIndex,
oldPageFormat == null ? pageFormat : oldPageFormat,
isIgnorePageMargins,
sheetAutoFilter,
currentSheetPageScale,
currentSheetFirstPageNumber,
false,
pageIndex - sheetInfo.sheetFirstPageIndex
);
firstPageNotSet = false;
}
else
{
Integer documentFirstPageNumber = configuration.getFirstPageNumber();
if(documentFirstPageNumber != null && documentFirstPageNumber > 0 && firstPageNotSet)
{
sheetHelper.exportFooter(
sheetIndex,
oldPageFormat == null ? pageFormat : oldPageFormat,
isIgnorePageMargins,
sheetAutoFilter,
currentSheetPageScale,
documentFirstPageNumber,
false,
pageIndex - sheetInfo.sheetFirstPageIndex
);
firstPageNotSet = false;
}
else
{
sheetHelper.exportFooter(
sheetIndex,
oldPageFormat == null ? pageFormat : oldPageFormat,
isIgnorePageMargins,
sheetAutoFilter,
currentSheetPageScale,
null,
firstPageNotSet,
pageIndex - sheetInfo.sheetFirstPageIndex
);
}
}
sheetHelper.close();
sheetRelsHelper.exportFooter();
sheetRelsHelper.close();
drawingHelper.exportFooter();
drawingHelper.close();
drawingRelsHelper.exportFooter();
drawingRelsHelper.close();
}
}
protected void exportFrame(
JRPrintFrame frame,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex
) throws JRException
{
cellHelper.exportHeader(gridCell, rowIndex, colIndex);
sheetHelper.exportMergedCells(rowIndex, colIndex, gridCell.getRowSpan(), gridCell.getColSpan());
// boolean appendBackcolor =
// frame.getModeValue() == ModeEnum.OPAQUE
// && (backcolor == null || frame.getBackcolor().getRGB() != backcolor.getRGB());
//
// if (appendBackcolor)
// {
// setBackcolor(frame.getBackcolor());
// }
//
// try
// {
// JRGridLayout layout = gridCell.getLayout();
// JRPrintElementIndex frameIndex =
// new JRPrintElementIndex(
// reportIndex,
// pageIndex,
// gridCell.getWrapper().getAddress()
// );
// exportGrid(layout, frameIndex);
// }
// finally
// {
// if (appendBackcolor)
// {
// restoreBackcolor();
// }
// }
cellHelper.exportFooter();
}
public void exportImage(
JRPrintImage image,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex,
int emptyCols,
int yCutsRow,
JRGridLayout layout
) throws JRException
{
int topPadding =
Math.max(image.getLineBox().getTopPadding().intValue(), getImageBorderCorrection(image.getLineBox().getTopPen()));
int leftPadding =
Math.max(image.getLineBox().getLeftPadding().intValue(), getImageBorderCorrection(image.getLineBox().getLeftPen()));
int bottomPadding =
Math.max(image.getLineBox().getBottomPadding().intValue(), getImageBorderCorrection(image.getLineBox().getBottomPen()));
int rightPadding =
Math.max(image.getLineBox().getRightPadding().intValue(), getImageBorderCorrection(image.getLineBox().getRightPen()));
int availableImageWidth = image.getWidth() - leftPadding - rightPadding;
availableImageWidth = availableImageWidth < 0 ? 0 : availableImageWidth;
int availableImageHeight = image.getHeight() - topPadding - bottomPadding;
availableImageHeight = availableImageHeight < 0 ? 0 : availableImageHeight;
cellHelper.exportHeader(gridCell, rowIndex, colIndex);
Renderable renderer = image.getRenderable();
if (
renderer != null &&
availableImageWidth > 0 &&
availableImageHeight > 0
)
{
if (renderer.getTypeValue() == RenderableTypeEnum.IMAGE)
{
// Non-lazy image renderers are all asked for their image data at some point.
// Better to test and replace the renderer now, in case of lazy load error.
renderer = RenderableUtil.getInstance(jasperReportsContext).getOnErrorRendererForImageData(renderer, image.getOnErrorTypeValue());
}
}
else
{
renderer = null;
}
if (renderer != null)
{
int width = availableImageWidth;
int height = availableImageHeight;
double normalWidth = availableImageWidth;
double normalHeight = availableImageHeight;
// Image load might fail.
Renderable tmpRenderer =
RenderableUtil.getInstance(jasperReportsContext).getOnErrorRendererForDimension(renderer, image.getOnErrorTypeValue());
Dimension2D dimension = tmpRenderer == null ? null : tmpRenderer.getDimension(jasperReportsContext);
// If renderer was replaced, ignore image dimension.
if (tmpRenderer == renderer && dimension != null)
{
normalWidth = dimension.getWidth();
normalHeight = dimension.getHeight();
}
double cropTop = 0;
double cropLeft = 0;
double cropBottom = 0;
double cropRight = 0;
switch (image.getScaleImageValue())
{
case FILL_FRAME :
{
width = availableImageWidth;
height = availableImageHeight;
break;
}
case CLIP :
{
// if (normalWidth > availableImageWidth)
// {
switch (image.getHorizontalImageAlign())
{
case RIGHT :
{
cropLeft = 100000 * (availableImageWidth - normalWidth) / availableImageWidth;
cropRight = 0;
break;
}
case CENTER :
{
cropLeft = 100000 * (availableImageWidth - normalWidth) / availableImageWidth / 2;
cropRight = cropLeft;
break;
}
case LEFT :
default :
{
cropLeft = 0;
cropRight = 100000 * (availableImageWidth - normalWidth) / availableImageWidth;
break;
}
}
// }
// else
// {
// width = (int)normalWidth;
// }
// if (normalHeight > availableImageHeight)
// {
switch (image.getVerticalImageAlign())
{
case TOP :
{
cropTop = 0;
cropBottom = 100000 * (availableImageHeight - normalHeight) / availableImageHeight;
break;
}
case MIDDLE :
{
cropTop = 100000 * (availableImageHeight - normalHeight) / availableImageHeight / 2;
cropBottom = cropTop;
break;
}
case BOTTOM :
default :
{
cropTop = 100000 * (availableImageHeight - normalHeight) / availableImageHeight;
cropBottom = 0;
break;
}
}
// }
// else
// {
// height = (int)normalHeight;
// }
break;
}
case RETAIN_SHAPE :
default :
{
if (availableImageHeight > 0)//FIXMEXLSX this is useless. test is above. check all
{
double ratio = normalWidth / normalHeight;
if( ratio > availableImageWidth / (double)availableImageHeight )
{
width = availableImageWidth;
height = (int)(width/ratio);
switch (image.getVerticalImageAlign())
{
case TOP :
{
cropTop = 0;
cropBottom = 100000 * (availableImageHeight - height) / availableImageHeight;
break;
}
case MIDDLE :
{
cropTop = 100000 * (availableImageHeight - height) / availableImageHeight / 2;
cropBottom = cropTop;
break;
}
case BOTTOM :
default :
{
cropTop = 100000 * (availableImageHeight - height) / availableImageHeight;
cropBottom = 0;
break;
}
}
}
else
{
height = availableImageHeight;
width = (int)(ratio * height);
switch (image.getHorizontalImageAlign())
{
case RIGHT :
{
cropLeft = 100000 * (availableImageWidth - width) / availableImageWidth;
cropRight = 0;
break;
}
case CENTER :
{
cropLeft = 100000 * (availableImageWidth - width) / availableImageWidth / 2;
cropRight = cropLeft;
break;
}
case LEFT :
default :
{
cropLeft = 0;
cropRight = 100000 * (availableImageWidth - width) / availableImageWidth;
break;
}
}
}
}
}
}
XlsReportConfiguration configuration = getCurrentItemConfiguration();
if(!configuration.isIgnoreAnchors())
{
insertPageAnchor(colIndex,rowIndex);
if (image.getAnchorName() != null)
{
String ref = "'" + currentSheetName + "'!$" + XlsxCellHelper.getColumIndexLetter(colIndex) + "$" + (rowIndex + 1);
definedNames.append(""+ ref +" \n");
}
}
// boolean startedHyperlink = startHyperlink(image,false);
String imageName = getImagePath(renderer, image.isLazy(), gridCell);
drawingRelsHelper.exportImage(imageName);
sheetHelper.exportMergedCells(rowIndex, colIndex, gridCell.getRowSpan(), gridCell.getColSpan());
ImageAnchorTypeEnum imageAnchorType =
ImageAnchorTypeEnum.getByName(
JRPropertiesUtil.getOwnProperty(image, XlsReportConfiguration.PROPERTY_IMAGE_ANCHOR_TYPE)
);
if (imageAnchorType == null)
{
imageAnchorType = configuration.getImageAnchorType();
if (imageAnchorType == null)
{
imageAnchorType = ImageAnchorTypeEnum.MOVE_NO_SIZE;
}
}
drawingHelper.write("\n");
drawingHelper.write("" +
colIndex +
" " +
LengthUtil.emu(leftPadding) +
" " +
rowIndex +
" " +
LengthUtil.emu(topPadding) +
" " +
(colIndex + gridCell.getColSpan()) +
" " +
LengthUtil.emu(-rightPadding) +
" " +
(rowIndex + (configuration.isCollapseRowSpan() ? 1 : gridCell.getRowSpan())) +
" " +
LengthUtil.emu(-bottomPadding) +
" \n");
drawingHelper.write(" 0 ? image.hashCode() : -image.hashCode()) + "\" name=\"Picture\">\n");
String href = HyperlinkTypeEnum.LOCAL_ANCHOR.equals(image.getHyperlinkTypeValue()) || HyperlinkTypeEnum.LOCAL_PAGE.equals(image.getHyperlinkTypeValue()) ? "#" + getHyperlinkURL(image) : getHyperlinkURL(image);
if (href != null)
{
drawingHelper.exportHyperlink(href);
}
drawingHelper.write(" \n");
drawingHelper.write(" 0)
// drawingHelper.write(" l=\"" + (int)cropLeft + "\"");
//// if (cropTop > 0)
// drawingHelper.write(" t=\"" + (int)cropTop + "\"");
//// if (cropRight > 0)
// drawingHelper.write(" r=\"" + (int)cropRight + "\"");
//// if (cropBottom > 0)
// drawingHelper.write(" b=\"" + (int)cropBottom + "\"");
drawingHelper.write("/>");
drawingHelper.write(" 0)
drawingHelper.write(" l=\"" + (int)cropLeft + "\"");
// if (cropTop > 0)
drawingHelper.write(" t=\"" + (int)cropTop + "\"");
// if (cropRight > 0)
drawingHelper.write(" r=\"" + (int)cropRight + "\"");
// if (cropBottom > 0)
drawingHelper.write(" b=\"" + (int)cropBottom + "\"");
drawingHelper.write("/> \n");
drawingHelper.write(" \n");
drawingHelper.write(" \n");
// if(startedHyperlink)
// {
// endHyperlink(false);
// }
}
// drawingHelper.write("");
cellHelper.exportFooter();
}
protected void exportLine(
JRPrintLine line,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex
) throws JRException
{
JRLineBox box = new JRBaseLineBox(null);
JRPen pen = null;
float ratio = line.getWidth() / line.getHeight();
if (ratio > 1)
{
if (line.getDirectionValue() == LineDirectionEnum.TOP_DOWN)
{
pen = box.getTopPen();
}
else
{
pen = box.getBottomPen();
}
}
else
{
if (line.getDirectionValue() == LineDirectionEnum.TOP_DOWN)
{
pen = box.getLeftPen();
}
else
{
pen = box.getRightPen();
}
}
pen.setLineColor(line.getLinePen().getLineColor());
pen.setLineStyle(line.getLinePen().getLineStyleValue());
pen.setLineWidth(line.getLinePen().getLineWidth());
gridCell.setBox(box);//CAUTION: only some exporters set the cell box
cellHelper.exportHeader(gridCell, rowIndex, colIndex);
sheetHelper.exportMergedCells(rowIndex, colIndex, gridCell.getRowSpan(), gridCell.getColSpan());
cellHelper.exportFooter();
}
protected void exportRectangle(
JRPrintGraphicElement rectangle,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex
) throws JRException
{
JRLineBox box = new JRBaseLineBox(null);
JRPen pen = box.getPen();
pen.setLineColor(rectangle.getLinePen().getLineColor());
pen.setLineStyle(rectangle.getLinePen().getLineStyleValue());
pen.setLineWidth(rectangle.getLinePen().getLineWidth());
gridCell.setBox(box);//CAUTION: only some exporters set the cell box
cellHelper.exportHeader(gridCell, rowIndex, colIndex);
sheetHelper.exportMergedCells(rowIndex, colIndex, gridCell.getRowSpan(), gridCell.getColSpan());
cellHelper.exportFooter();
}
public void exportText(
final JRPrintText text,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex
) throws JRException
{
final JRStyledText styledText = getStyledText(text);
final int textLength = styledText == null ? 0 : styledText.length();
final String textStr = styledText.getText();
TextValue textValue = null;
String pattern = null;
XlsReportConfiguration configuration = getCurrentItemConfiguration();
if (configuration.isDetectCellType())
{
textValue = getTextValue(text, textStr);
if (textValue instanceof NumberTextValue)
{
pattern = ((NumberTextValue)textValue).getPattern();
}
else if (textValue instanceof DateTextValue)
{
pattern = ((DateTextValue)textValue).getPattern();
}
}
cellHelper.exportHeader(
gridCell, rowIndex, colIndex, textValue,
getConvertedPattern(text, pattern),
getTextLocale(text),
isWrapText(gridCell.getElement()) || Boolean.TRUE.equals(((JRXlsxExporterNature)nature).getColumnAutoFit(gridCell.getElement())),
isCellHidden(gridCell.getElement()),
isCellLocked(gridCell.getElement()),
isShrinkToFit(gridCell.getElement())
);
sheetHelper.exportMergedCells(rowIndex, colIndex, gridCell.getRowSpan(), gridCell.getColSpan());
String textFormula = getFormula(text);
if (textFormula != null)
{
sheetHelper.write("" + textFormula + " \n");
}
// if (text.getLineSpacing() != JRTextElement.LINE_SPACING_SINGLE)
// {
// styleBuffer.append("line-height: " + text.getLineSpacingFactor() + "; ");
// }
// if (styleBuffer.length() > 0)
// {
// writer.write(" style=\"");
// writer.write(styleBuffer.toString());
// writer.write("\"");
// }
//
// writer.write(">");
// tableHelper.getParagraphHelper().exportProps(text);
if(!configuration.isIgnoreAnchors())
{
insertPageAnchor(colIndex,rowIndex);
if (text.getAnchorName() != null)
{
String ref = "'" + currentSheetName + "'!$" + XlsxCellHelper.getColumIndexLetter(colIndex) + "$" + (rowIndex + 1);
definedNames.append(""+ ref +" \n");
}
}
String href = getHyperlinkURL(text);
if (href != null)
{
sheetHelper.exportHyperlink(
rowIndex,
colIndex,
href,
HyperlinkTypeEnum.LOCAL_ANCHOR.equals(text.getHyperlinkTypeValue()) || HyperlinkTypeEnum.LOCAL_PAGE.equals(text.getHyperlinkTypeValue()));
}
TextValueHandler handler =
new TextValueHandler()
{
public void handle(BooleanTextValue textValue) throws JRException {
sheetHelper.write("" + textValue.getValue() + " ");
}
public void handle(DateTextValue textValue) throws JRException {
Date date = textValue.getValue();
sheetHelper.write(
""
+ (date == null ? "" : JRDataUtils.getExcelSerialDayNumber(
date,
getTextLocale(text),
getTextTimeZone(text)
))
+ " "
);
}
public void handle(NumberTextValue textValue) throws JRException {
Number number = textValue.getValue();
sheetHelper.write(
""
+ (number == null ? "" : number)
+ " "
);
}
public void handle(StringTextValue textValue) throws JRException {
writeText();
}
private void writeText() throws JRException {
sheetHelper.write("");//FIXMENOW make writer util; check everywhere
if (textLength > 0)
{
String markup = text.getMarkup();
boolean isStyledText = markup != null && !JRCommonText.MARKUP_NONE.equals(markup);
exportStyledText(text.getStyle(), styledText, getTextLocale(text), isStyledText);
}
sheetHelper.write(" ");
}
};
if (textValue != null)
{
//detect cell type
textValue.handle(handler);
}
else
{
handler.handle((StringTextValue)null);
}
cellHelper.exportFooter();
}
protected void exportGenericElement(
JRGenericPrintElement element,
JRExporterGridCell gridCell,
int colIndex,
int rowIndex,
int emptyCols,
int yCutsRow,
JRGridLayout layout
) throws JRException
{
GenericElementXlsxHandler handler = (GenericElementXlsxHandler)
GenericElementHandlerEnviroment.getInstance(getJasperReportsContext()).getElementHandler(
element.getGenericType(), XLSX_EXPORTER_KEY);
if (handler != null)
{
handler.exportElement(exporterContext, element, gridCell, colIndex, rowIndex);
}
else
{
if (log.isDebugEnabled())
{
log.debug("No XLSX generic element handler for "
+ element.getGenericType());
}
}
}
protected void openWorkbook(OutputStream os) throws JRException
{
rendererToImagePathMap = new HashMap();
// imageMaps = new HashMap();
imagesToProcess = new ArrayList();
// hyperlinksMap = new HashMap();
definedNames = new StringBuffer();
try
{
String memoryThreshold = jasperPrint.getPropertiesMap().getProperty(FileBufferedOutputStream.PROPERTY_MEMORY_THRESHOLD);
xlsxZip = new XlsxZip(jasperReportsContext, memoryThreshold == null ? null : JRPropertiesUtil.asInteger(memoryThreshold));
wbHelper = new XlsxWorkbookHelper(jasperReportsContext, xlsxZip.getWorkbookEntry().getWriter(), definedNames);
wbHelper.exportHeader();
relsHelper = new XlsxRelsHelper(jasperReportsContext, xlsxZip.getRelsEntry().getWriter());
ctHelper = new XlsxContentTypesHelper(jasperReportsContext, xlsxZip.getContentTypesEntry().getWriter());
String macro = macroTemplate == null ? getCurrentConfiguration().getMacroTemplate() : macroTemplate;
if(macro != null)
{
xlsxZip.addMacro(macro);
relsHelper.setContainsMacro(true);
ctHelper.setContainsMacro(true);
}
relsHelper.exportHeader();
ctHelper.exportHeader();
styleHelper =
new XlsxStyleHelper(
jasperReportsContext,
xlsxZip.getStylesEntry().getWriter(),
getExporterKey()
);
firstPageNotSet = true;
firstSheetName = null;
}
catch (IOException e)
{
throw new JRException(e);
}
// runHelper = new RunHelper(sheetWriter, fontMap, null);//FIXMEXLSX check this null
}
protected void setBackground() {
// TODO Auto-generated method stub
}
// protected void setCell(JRExporterGridCell gridCell, int colIndex, int rowIndex)
// {
// }
protected void addOccupiedCell(OccupiedGridCell occupiedGridCell, int colIndex, int rowIndex)
{
ElementGridCell elementGridCell = (ElementGridCell)occupiedGridCell.getOccupier();
cellHelper.exportHeader(elementGridCell, rowIndex, colIndex);
cellHelper.exportFooter();
}
protected void setColumnWidth(int col, int width, boolean autoFit)
{
sheetHelper.exportColumn(col, width, autoFit);
}
protected void setRowHeight(
int rowIndex,
int rowHeight,
Cut yCut,
XlsRowLevelInfo levelInfo
) throws JRException
{
sheetHelper.exportRow(rowHeight, yCut, levelInfo);
}
protected void addRowBreak(int rowIndex)
{
sheetHelper.addRowBreak(rowIndex);
}
/**
*
*/
public String getExporterKey()
{
return XLSX_EXPORTER_KEY;
}
/**
*
*/
public String getExporterPropertiesPrefix()
{
return XLSX_EXPORTER_PROPERTIES_PREFIX;
}
protected void setFreezePane(int rowIndex, int colIndex, boolean isRowEdge, boolean isColumnEdge)
{
//TODO: set freeze pane for element-level defined indexes
}
protected void setSheetName(String sheetName)
{
/* nothing to do here; it's done in createSheet() */
}
@Override
protected void setAutoFilter(String autoFilterRange)
{
sheetAutoFilter = autoFilterRange;
}
protected void resetAutoFilters()
{
super.resetAutoFilters();
sheetAutoFilter = null;
}
@Override
protected void setRowLevels(XlsRowLevelInfo levelInfo, String level)
{
/* nothing to do here; it's done in setRowHeight */
}
/**
* @deprecated Replaced by {@link XlsxExporterConfiguration#getMacroTemplate()}.
*/
public String getMacroTemplatePath()
{
return macroTemplate;
}
/**
* @deprecated Replaced by {@link XlsxExporterConfiguration#getMacroTemplate()}.
*/
public void setMacroTemplate(String macroTemplate)
{
this.macroTemplate = macroTemplate;
}
protected void setScale(Integer scale)
{
/* nothing to do here; it's already done in the abstract exporter */
}
protected String getAnchorType(ImageAnchorTypeEnum anchorType)
{
switch (anchorType)
{
case MOVE_SIZE:
return TWO_CELL;
case NO_MOVE_NO_SIZE:
return ABSOLUTE;
case MOVE_NO_SIZE:
default:
return ONE_CELL;
}
}
protected String getDefinedName(String name)
{
if (name != null)
{
return name.replaceAll("\\W", "");
}
return null;
}
}
