如题,其实说不失真是不肯能的,只是保证至少拉伸到图片原始大小不失真,原先自带的导出的图片到Excel,图片一拉伸就马上模糊掉了失真很厉害,为了解决这个问题,研究了jasperReport的源代码,使之不会失真
写道
sheet.addCell(new Blank(col, row, cellStyle2));
double rowspan = gridCell.getRowSpan();
double colspan = gridCell.getColSpan();
double cellHeight = gridCell.getHeight();
double cellWidth = gridCell.getWidth();
double rowspan = gridCell.getRowSpan();
double colspan = gridCell.getColSpan();
double cellHeight = gridCell.getHeight();
double cellWidth = gridCell.getWidth();
//按比例缩放
if (scale > cellWidth/cellHeight)
{
cellWidth = colspan*0.96;
cellHeight = rowspan *0.96 / scale;
}
else
{
cellWidth = (colspan*scale*0.96);
cellHeight = rowspan*0.96;
}
if (scale > cellWidth/cellHeight)
{
cellWidth = colspan*0.96;
cellHeight = rowspan *0.96 / scale;
}
else
{
cellWidth = (colspan*scale*0.96);
cellHeight = rowspan*0.96;
}
//居中显示
double offset_x = (colspan - cellWidth)/2;
double offset_y = (rowspan - cellHeight)/2;
WritableImage image =
new WritableImage(
col - emptyCols + offset_x,
row + offset_y,
cellWidth,
cellHeight,
renderer.getImageData() //主要修改了这段代码
);
sheet.addImage(image);
double offset_x = (colspan - cellWidth)/2;
double offset_y = (rowspan - cellHeight)/2;
WritableImage image =
new WritableImage(
col - emptyCols + offset_x,
row + offset_y,
cellWidth,
cellHeight,
renderer.getImageData() //主要修改了这段代码
);
sheet.addImage(image);
附件为修改后的代码,覆盖JasperReport源代码中的JExcelApiExporter.java即可
注:目前只修改了jxl的方式,poi的方式还不知道怎么修改,如果有朋友修改了,可以分析一下,谢谢