Export Vertical Text

DsExcel Java allows users to export Excel files with vertical text to PDF without any issues. While saving an Excel file with vertical text correctly to a PDF file, the following properties can be used -

• IRange.Orientation - The setOrientation() method of the IRange interface sets the orientation of the text.
• IRange.Font.Name - Sets the specific font name using the getFont method of the IRange interface. If the font name starts with "@", each double-byte character in the text is rotated to 90 degrees.

Refer to the following example code in order to export vertical text to PDF.

// Initialize workbook
Workbook workbook = new Workbook();
        
// Fetch default worksheet
IWorksheet worksheet = workbook.getWorksheets().get(0);

// Fetch the cell range A1
IRange a1 = worksheet.getRange("A1");

// Setting Cell A1 Text
a1.setValue("This is a vertical text");

// Formatting A1 cell
a1.getFont().setName("Verdana");
a1.setHorizontalAlignment(HorizontalAlignment.Right);
a1.setVerticalAlignment(VerticalAlignment.Top);
a1.setOrientation(90);
a1.setWrapText(true);
a1.setColumnWidth(27);
a1.setRowHeight(190);

// Saving workbook to PDF
workbook.save("6- ExportVerticalTextToPDF.pdf", SaveFileFormat.Pdf);

type=note

Note: The following limitations must be kept in mind while exporting Excel files with vertical text to PDF -

• The orientation can only be set to 0, 90, -90 and 255. Other values will be treated as 0 while rendering the PDF file.
• If the font name starts with "@" and the orientation is 255, DsExcel will ignore the "@".