<p>Hi,</p>
<p> </p>
<p>I need to generate the report in xlsx format. Headers need to display in vertical order.</p>
<p><strong>1 | 2</strong></p>
<p><strong>E | E </strong></p>
<p><strong>M | M</strong></p>
<p><strong>A | A</strong></p>
<p><strong>N | N</strong></p>
<p>
</p>
<p>A1 | A2</p>
<p> </p>
<p>On the above sample NAME1 and NAME2 are headers. if I use label that is not displayed in expecting format.</p>
<p> </p>
<p>I am using API to generate the report. I have tried with below code.</p>
<p> </p>
<p>ExtendedItemHandle <span>rotatedText</span>=elementFactory.newExtendedItem("ex1", "RotatedText");<br><span>rotatedText</span><span>.</span><span>setProperty</span><span>(</span><span>"rotationAngle"</span><span>,</span><span> </span><span>"90"</span><span>);</span><br><span>rotatedText</span><span>.</span><span>setProperty</span><span>(</span><span>"text"</span><span>,</span><span> </span><span>"\"Test\""</span><span>);</span><br><span>rotatedText</span><span>.</span><span>setProperty</span><span>(</span><span>"wrapPoint"</span><span>,</span><span> </span><span>"0in"</span><span>);</span><br><span>rotatedText</span><span>.</span><span>setProperty</span><span>(</span><span>"linkURL"</span><span>,</span><span> </span><span>"\"<a data-ipb='nomediaparse' href=''>
http://www.Actuate.com\""</a></span><span>);</span><span> </span><span>//You can also use a relative path</span><br><span>rotatedText</span><span>.</span><span>setProperty</span><span>(</span><span>"fontFamily"</span><span>,</span><span> </span><span>"sans-serif"</span><span>);</span><br><span>rotatedText</span><span>.</span><span>setProperty</span><span>(</span><span>"fontSize"</span><span>,</span><span> </span><span>"30pt"</span><span>);</span><br><span>rotatedText</span><span>.</span><span>setProperty</span><span>(</span><span>"fontStyle"</span><span>,</span><span> </span><span>"italic"</span><span>);</span><span> </span><span>//Options: "normal" or "italic"</span><br><span>rotatedText</span><span>.</span><span>setProperty</span><span>(</span><span>"fontWeight"</span><span>,</span><span> </span><span>"bold"</span><span>);</span><span> </span><span>//Options: "normal" or "bold"</span><br><span>rotatedText</span><span>.</span><span>setProperty</span><span>(</span><span>"color"</span><span>,</span><span> </span><span>"#FF0000"</span><span>);</span><br><br>
cell.getContent().add(<span>rotatedText</span>);<span> </span></p>
<p> </p>
<p>I am getting null in <span>rotatedText. can any one tell me how to achieve this? Any JAR files required this??</span></p>
<p> </p>
<p><span>Is there any alternative way to achieve this?</span></p>
<p> </p>
<p> </p>
<p><span>Thanks in advance</span></p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
