javacsvjasper-reports
JRCsvExporter generates csv with blank first line
I have a Java code which generates csv file using JRCsvExporter class. For some reason, it adds blank line in the top. When open in text editor it looks like this:
And when open in Excel it looks like this:
The issue is due the double quotes the file begins with. When I remove those, it will appear as expected. Yet, I am note sure why those quotes generated, for what reason they good for, and how I removed them safely.
The code is:
reportOutputName = generateReportOutputName(".csv");
JRCsvExporter exporter = new JRCsvExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
PrintStream ps = new PrintStream(new FileOutputStream(reportOutputName), true, "UTF-8");
addBOMToStream(ps);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ps);
exporter.setParameter(JRCsvExporterParameter.FIELD_DELIMITER, ",");
exporter.setParameter(JRCsvExporterParameter.RECORD_DELIMITER, System.getProperty("line.separator"));
exporter.setParameter(JRExporterParameter.CHARACTER_ENCODING, "UTF-8");
exporter.exportReport();
Edit: The relevant part of .jrxml is: How can I make JRCsvExporter ignore element when creating the csv file?
<title>
<band height="610" isSplitAllowed="true" >
<image scaleImage="Clip" vAlign="Middle" hAlign="Right" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="5"
width="945"
height="40"
key="image-1"/>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<graphicElement stretchType="NoStretch"/>
<imageExpression class="java.lang.String"><![CDATA["etc/report/jasper/img/TopBanner_Report.png"]]></imageExpression>
</image>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Transparent"
x="0"
y="5"
width="945"
height="40"
forecolor="#FFFFFF"
backcolor="#FFFFFF"
key="textField-51">
<printWhenExpression><![CDATA[new Boolean(!(($P{is_excel}).booleanValue()))]]></printWhenExpression>
</reportElement>
<box leftPadding="10"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#E8D59C"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#E8D59C"/>
<bottomPen lineWidth="0.0" lineColor="#E8D59C"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#E8D59C"/>
</box>
<textElement verticalAlignment="Middle">
<font fontName="Times-Roman" pdfFontName="etc/report/jasper/fonts/ARIALUNI.TTF" size="14" isBold="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{report_name}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="0"
y="60"
width="945"
height="25"
forecolor="#000000"
backcolor="#B8CFF2"
key="textField-52"
isRemoveLineWhenBlank="true">
<printWhenExpression><![CDATA[new Boolean(!(($P{is_excel}).booleanValue()))]]></printWhenExpression>
</reportElement>
<box leftPadding="10"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#B2E66F"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#B2E66F"/>
<bottomPen lineWidth="0.0" lineColor="#B2E66F"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#B2E66F"/>
</box>
<textElement verticalAlignment="Middle">
<font fontName="Arial Unicode MS" pdfFontName="etc/report/jasper/fonts/ARIALUNI.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Report Details"]]></textFieldExpression>
</textField>
<rectangle radius="0" >
<reportElement
mode="Opaque"
x="0"
y="85"
width="945"
height="505"
forecolor="#535353"
backcolor="#ECECEC"
key="rectangle-1"
stretchType="RelativeToTallestObject"/>
<graphicElement stretchType="RelativeToTallestObject">
<pen lineWidth="0.0" lineStyle="Solid"/>
</graphicElement>
</rectangle>
<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="0"
y="110"
width="945"
height="25"
forecolor="#535353"
backcolor="#EBEDEF"
key="textField-48"
isRemoveLineWhenBlank="true">
<printWhenExpression><![CDATA[new Boolean(!(($P{is_excel}).booleanValue()))]]></printWhenExpression>
</reportElement>
<box leftPadding="10"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#E8D59C"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#C1CDD8"/>
<bottomPen lineWidth="0.0" lineColor="#E8D59C"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#C1CDD8"/>
</box>
<textElement verticalAlignment="Middle">
<font fontName="Arial Unicode MS" pdfFontName="etc/report/jasper/fonts/ARIALUNI.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Generated By: "+$P{report_generatedby}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="0"
y="85"
width="945"
height="25"
forecolor="#535353"
backcolor="#EBEDEF"
key="textField-46"
isRemoveLineWhenBlank="true">
<printWhenExpression><![CDATA[new Boolean(!(($P{is_excel}).booleanValue()))]]></printWhenExpression>
</reportElement>
<box leftPadding="10"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#C1CDD8"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#C1CDD8"/>
<bottomPen lineWidth="0.0" lineColor="#E8D59C"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#C1CDD8"/>
</box>
<textElement verticalAlignment="Middle">
<font fontName="Arial Unicode MS" pdfFontName="etc/report/jasper/fonts/ARIALUNI.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" />
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Hosts: '"+$P{ip_range_text}+"'"]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="0"
y="135"
width="945"
height="25"
forecolor="#535353"
backcolor="#EBEDEF"
key="textField-49"
isRemoveLineWhenBlank="true">
<printWhenExpression><![CDATA[new Boolean(!(($P{is_excel}).booleanValue()))]]></printWhenExpression>
</reportElement>
<box leftPadding="10" bottomPadding="5"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#E8D59C"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#C1CDD8"/>
<bottomPen lineWidth="0.0" lineColor="#E8D59C"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#C1CDD8"/>
</box>
<textElement verticalAlignment="Middle">
<font fontName="Arial Unicode MS" pdfFontName="etc/report/jasper/fonts/ARIALUNI.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Generated At: "+(new java.util.Date()).toString()]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="0"
y="160"
width="945"
height="100"
forecolor="#535353"
backcolor="#EBEDEF"
key="textField-47"
isRemoveLineWhenBlank="true">
<printWhenExpression><![CDATA[new Boolean(!(($P{is_excel}).booleanValue()))]]></printWhenExpression>
</reportElement>
<box leftPadding="10" rightPadding="10" bottomPadding="5"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#C1CDD8"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#C1CDD8"/>
<bottomPen lineWidth="0.0" lineColor="#C1CDD8"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#C1CDD8"/>
</box>
<textElement textAlignment="Justified" verticalAlignment="Middle">
<font fontName="Arial Unicode MS" pdfFontName="etc/report/jasper/fonts/ARIALUNI.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{report_description}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
mode="Transparent"
x="0"
y="260"
width="945"
height="330"
forecolor="#535353"
backcolor="#EBEDEF"
key="notice-text"/>
<box leftPadding="10" rightPadding="10" bottomPadding="5"></box>
<textElement textAlignment="Justified" verticalAlignment="Middle" markup="html">
<font fontName="Arial Unicode MS" pdfFontName="etc/report/jasper/fonts/ARIALUNI.TTF" size="12" isBold="true" isPdfEmbedded ="true" pdfEncoding ="Identity-H"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{notice_text}+"<p><span style='color:#D8000C'>"+$V{missingDataWrapper}+"</span></p>"]]></textFieldExpression>
</textField>
</band>
</title>
Solution
The issue was due to reportElement "notice-text".
The data of its textFieldExpression in many cases can be empty or null, In order to avoid printing it when it's null or empty we shall add:
so it will looks like:
- Keep numbers which appear in both columns, in J lang
- Differentiation in J
- How to reshape an array with an arbitrary size in one dimension?
- Why is Insert (fold) right associative
- Write 4 : 'x&{.&.;: y' tacitly
- Alignment issue when printing formatted prime numbers in J language
- How can I define a verb in J that applies a different verb alternately to each atom in a list?
- How to get user input in the J programming language
- How to unbox a list of boxed lists of differing lengths in J?
- How can I fix 'noun result was required' error in J?
- In j, how can I define a verb locally in one scope and pass it to a defined adverb?
- Convert boxed array to normal array?
- Read column of CSV file as array
- Replace atom in array of strings
- What does the dyad `=` do to boxed strings?
- Index of minimum element using J
- How can I take the outer product of string vectors in J?
- Building an array of verbs in J
- Reading in multidigit command line parameter
- Amend with bond to new data shows unexpected behaviour
- How to turn a table or matrix into a (flat) list in J
- How to run dissect in J?
- How to define selection using index function in J
- How to exit the J console?
- Find 4-neighbors using J
- Writing custom verbs in J
- How do I negate a selector in J lang?
- How to use arbitrary selector in interchange in J lang?
- different result once square root is added inside tacit
- Sum of arrays with repeated indices