LESSON: Why Excel Cell Exported From Jasper Server Has No Grid Displayed
来源:互联网 发布:湖南电信网络测速 编辑:程序博客网 时间:2024/06/03 13:34
1. Problem Description
Environment: Jasper Studio 5.6.2 community edition., Jasper Server 5.6.2 community edition (minimal installation).
Excel exporter setting:
<bean id="xlsExportParameters" class="com.jaspersoft.jasperserver.api.engine.jasperreports.common.XlsExportParametersBean"> <property name="detectCellType" value="true"/> <property name="onePagePerSheet" value="true"/> <property name="removeEmptySpaceBetweenRows" value="false"/> <property name="removeEmptySpaceBetweenColumns" value="false"/> <property name="whitePageBackground" value="true"/> <property name="ignoreGraphics" value="false"/> <property name="collapseRowSpan" value="true"/> <property name="ignoreCellBorder" value="false"/> <property name="fontSizeFixEnabled" value="true"/> <property name="maximumRowsPerSheet" value="0"/> <property name="xlsFormatPatternsMap" ref="formatPatternsMap"/> </bean>
During jasper report development, I met an annoying problem, there is no grid in the exported excel, and the excel looks really bad, shown as below,
2. Analysis and Solution
In short, we should set all table styles as 'transparent'.
0 0
- LESSON: Why Excel Cell Exported From Jasper Server Has No Grid Displayed
- Every 300th Row has Corrupt or Merged Cell Values When an Analysis is Exported to Excel
- Smack “No Response From Server”. Not sure why am i getting this error
- jasper报表the document has no pages的问题解决
- 【Angular】"Module '{0}' has no exported member '{1}'.": "模块“{0}”没有导出的成员“{1}”。",
- IIS 404 The page cannot be displayed because an internal server error has occurred
- AsPose.Cell 处理Excel No Problem
- Problem: Jasper Server Excel Export Configuration Doesn't Work
- NO WHY
- 在配置primeng环境时遇到Error TS2304: Cannot find name 'Map'或has no exported member 'DomSanitizer'
- LESSON: Jasper Report Table Conditional Style
- JMeter - Why response data is not displayed in .jtl file
- Data Grid Merge Cell
- Extjs5 grid cell tooltips
- Jasper Server初探
- Jasper Server Page Customization
- Jasper server Config document
- jasper server定制数据源
- 【C#】Message类的属性Msg所关联的消息ID
- sgu136:Erasing Edges
- DP 水题
- 浅析hybrid模式下地支付宝钱包和微信
- IOS开发之UIView总结
- LESSON: Why Excel Cell Exported From Jasper Server Has No Grid Displayed
- Android adb 常用命令
- hashcode()和equals()的不同之处
- java 利用反射获取类,实例化,并执行其内部方法
- 设计模式简介
- 《C陷阱与缺陷》读书笔记
- 【双连通分量】 POJ Knights of the Round Table
- Java Web应用程序的推荐目录结构
- Linked dylibs built for GC-only but object files built for retain/release for architecture x86_64