Export Vertical Text | Document Solutions for Excel, Java Edition

Export Vertical Text

In This Topic

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.

Java	Copy Code
// 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);

Java

Copy Code

        
// 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);

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 "@".