jrxml에서 pdf로 변환했습니다. 나는로 데이터를 전송하고 001 DTO에 있지만 동일한을 표시하면서 엑셀 그것으로되고있다 (1) . 다음은 데이터를 표시하는 데 사용 된 코드입니다.
암호:
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement style="table 5_CH" stretchType="RelativeToTallestObject" x="0" y="0" width="71" height="26" backcolor="#FFFFFF">
<property name="class" value="sortable"/>
</reportElement>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font pdfFontName="Helvetica"/>
<paragraph lineSpacing="Single" firstLineIndent="3" spacingAfter="5"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{reference}]]>
</textFieldExpression>
</textField>
선행 0도 표시해야합니다. 그래서 pls는이 문제를 해결하는 방법을 알려줍니다.
csv 파일 을보기 위해 MS Excel 애플리케이션을 사용하고 있습니다. CSV는 , 그것은 "데이터를 표시하는 방법"정보를 포함하지 않고 단지 일반 텍스트 형식입니다. 이러한 종류의 데이터보기는 뷰어에만 의존합니다. 따라서 Excel 형식 ( xls 또는 xlsx ) 으로 보고서를 구성 하기 위해 JRXlsExporter 또는 JExcelApiExporter 또는 JRXlsxExporter 내보내기 를 사용할 수 있습니다 .
예를 살펴 보겠습니다. 우리는 걸릴 CSV 데이터 소스로 파일을.
를 CSV 파일 데이터 ( excel_data.csv ) :
number_as_string,date,number_as_int
001,2013-09-23,1
002,2013-09-22,3
3,2013-09-21,4
004,2013-09-20,5
iReport 의 데이터 소스 구성 은 다음과 같습니다.
원하는 형식으로 정보를 얻기 위해 샘플에서 net.sf.jasperreports.export.xls.pattern 및 net.sf.jasperreports.export.xls.detect.cell.type 속성을 사용합니다 .
템플릿은 다음과 같습니다.
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="test_excel_formatting" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="952b781d-520d-4a76-aa59-f635b8759fbe">
<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
<queryString>
<![CDATA[]]>
</queryString>
<field name="number_as_string" class="java.lang.String"/>
<field name="date" class="java.util.Date"/>
<field name="number_as_int" class="java.lang.Integer"/>
<columnHeader>
<band height="42" splitType="Stretch">
<staticText>
<reportElement uuid="667b6ca6-bf50-404e-8ef1-c654456ed8e4" stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="88" height="42" backcolor="#FF99CC"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[Number as String, without pattern]]></text>
</staticText>
<staticText>
<reportElement uuid="080a5cc0-fa66-4b11-a3d3-f0b8a4e69204" stretchType="RelativeToTallestObject" mode="Opaque" x="88" y="0" width="88" height="42" backcolor="#9999FF"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[Number as Int, without pattern]]></text>
</staticText>
<staticText>
<reportElement uuid="d1fc6219-2e33-4cc9-b4fe-4ac2b5365102" stretchType="RelativeToTallestObject" mode="Opaque" x="176" y="0" width="104" height="42" backcolor="#99FFCC"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[Date without pattern]]></text>
</staticText>
<staticText>
<reportElement uuid="991837d7-a1ab-44ed-8177-756cfae9d369" stretchType="RelativeToTallestObject" mode="Opaque" x="280" y="0" width="104" height="42" backcolor="#9999FF"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[Number as Int with common pattern]]></text>
</staticText>
<staticText>
<reportElement uuid="d38154af-2017-4e10-a176-4d66e5cc9f96" stretchType="RelativeToTallestObject" mode="Opaque" x="384" y="0" width="104" height="42" backcolor="#9999FF"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[Number as Int with xls pattern]]></text>
</staticText>
<staticText>
<reportElement uuid="17f57019-8691-4643-abdb-ab15afe63f36" stretchType="RelativeToTallestObject" mode="Opaque" x="488" y="0" width="104" height="42" backcolor="#9999FF"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[Number as Int with common and xls pattern]]></text>
</staticText>
<staticText>
<reportElement uuid="f4f506bf-9511-4e1e-805b-8752a98e91ea" stretchType="RelativeToTallestObject" mode="Opaque" x="592" y="0" width="104" height="42" backcolor="#99FFCC"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[Date with common pattern]]></text>
</staticText>
<staticText>
<reportElement uuid="dffea96e-1dfa-47e0-8551-dd417c25ecbd" stretchType="RelativeToTallestObject" mode="Opaque" x="696" y="0" width="104" height="42" backcolor="#99FFCC"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[Date with common pattern]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="20" splitType="Stretch">
<textField>
<reportElement uuid="3d11d568-6e2c-4373-af7d-fa79b99a2908" mode="Opaque" x="0" y="0" width="88" height="20" backcolor="#FF99CC"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement/>
<textFieldExpression><![CDATA[$F{number_as_string}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8b8f968e-ca6d-44d0-bc2e-50a4773d0a6f" mode="Opaque" x="88" y="0" width="88" height="20" backcolor="#9999FF"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement/>
<textFieldExpression><![CDATA[$F{number_as_int}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="943a468b-491d-4955-b0c0-58d550536234" mode="Opaque" x="176" y="0" width="104" height="20" backcolor="#99FFCC"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement/>
<textFieldExpression><![CDATA[$F{date}]]></textFieldExpression>
</textField>
<textField pattern="000000">
<reportElement uuid="52a26b66-1ef5-4f77-a4a2-900a606a1171" mode="Opaque" x="280" y="0" width="104" height="20" backcolor="#9999FF"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement/>
<textFieldExpression><![CDATA[$F{number_as_int}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c26be152-fae4-4a85-ae55-c70e27739a87" mode="Opaque" x="384" y="0" width="104" height="20" backcolor="#9999FF">
<property name="net.sf.jasperreports.export.xls.pattern" value="00000000000000"/>
</reportElement>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement/>
<textFieldExpression><![CDATA[$F{number_as_int}]]></textFieldExpression>
</textField>
<textField pattern="00000">
<reportElement uuid="fab0fba1-1718-479d-841b-6cbaf1963a0b" mode="Opaque" x="488" y="0" width="104" height="20" backcolor="#9999FF">
<property name="net.sf.jasperreports.export.xls.pattern" value="00000000000000"/>
</reportElement>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement/>
<textFieldExpression><![CDATA[$F{number_as_int}]]></textFieldExpression>
</textField>
<textField pattern="dd-MMM-yyyy">
<reportElement uuid="07552f94-56c8-413d-8dd8-5b5c667c81cf" mode="Opaque" x="592" y="0" width="104" height="20" backcolor="#99FFCC"/>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement/>
<textFieldExpression><![CDATA[$F{date}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="844449f9-1578-4729-b911-18bdd17f8cd4" mode="Opaque" x="696" y="0" width="104" height="20" backcolor="#99FFCC">
<property name="net.sf.jasperreports.export.xls.pattern" value="dd mmmm yyyy"/>
</reportElement>
<box>
<topPen lineWidth="0.25"/>
<leftPen lineWidth="0.25"/>
<bottomPen lineWidth="0.25"/>
<rightPen lineWidth="0.25"/>
</box>
<textElement/>
<textFieldExpression><![CDATA[$F{date}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
iReport 의 보고서 디자인은 다음과 같습니다.
예를 들어 보고서의 속성 net.sf.jasperreports.export.xls.detect.cell.type 을 true로 설정했습니다 .
패턴이없는 number_as_string 필드를 첫 번째 열 (분홍색)에 넣었습니다 .
number_as_int 필드를 2, 4, 5, 6 (파란색) 열에 넣었습니다 .
3, 7, 8 (녹색) 열에 날짜 필드를 넣었습니다 .
결과 ( Excel 형식으로 생성 된 파일 )는 다음과 같습니다.
참고 :
보시다시피 첫 번째 열에는 원래 형식의 데이터가 포함되어 있습니다.
6 번 열에는 net.sf.jasperreports.export.xls.pattern 속성을 사용하여 설정된 형식의 데이터가 포함되어 있습니다. 이 속성은 textFields 요소의 패턴 속성 보다 "강력합니다" .
엑셀 파일의 도움으로 생성 된 iReport로 5.2.0 와 XLS 미리보기 , XLS 미리보기 (JExcel API를 사용) 및 엑셀 2007 (XLSX) 미리보기 옵션 - 결과는 동일했다.
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다