File Operations / Export to PDF / Export Text
Export Text

DsExcel Java allows users to save worksheets with different text formats and font effects while exporting to a PDF file.

You can save an excel file with different text formats and font effects in the following ways:

  1. Export Number Formats
  2. Export Overflow Text
  3. Export Font Effects

Export Number Formats

In order to export an excel file to PDF having text with excel number formatter, refer to the following example code.

Java
Copy Code
// Create a new workbook and access the default worksheet
Workbook workbook = new Workbook();
IWorksheet sheet = workbook.getWorksheets().get(0);
        
// Assign values to the range
sheet.getRange("B3:B7").setValue(123456.789);
sheet.getRange("B9:B13").setValue(-123456.789);
        
// Set number format
sheet.getRange("B4, B10").setNumberFormat("0.00;[Red]0.00");
sheet.getRange("B5, B11").setNumberFormat("$#,##0.00;[Red]$#,##0.00");
sheet.getRange("B6, B12").setNumberFormat("0.00E+00");
sheet.getRange("B7, B13")
.setNumberFormat("_($* #,##0.00_);_($* (#,##0.00);_($* \" - \"??_);_(@_)");

// Customize other settings
sheet.getColumns().get(1).setColumnWidthInPixel(100);

// Save to a pdf file
workbook.save("ExportNumberFormats.pdf", SaveFileFormat.Pdf);

Export Overflow Text

In order to export an excel file to PDF having overflow text, refer to the following example code.

Java
Copy Code
// Settings for overflow text
sheet.getRange("F2, F4").setValue("This is a test string of overflow");
sheet.getRange("F6, F8").setValue("This is a test string of overflow with right alignment");
sheet.getRange("F6, F8").setHorizontalAlignment(HorizontalAlignment.Right);
sheet.getRange("D8, H4").setValue(123);

// Apply style
sheet.getRange("A1:J10").getBorders().setLineStyle(BorderLineStyle.Thin);
        
// Save to a pdf file
workbook.save("ExportOverflowText.pdf", SaveFileFormat.Pdf);

Export Font Effects

In order to export an excel file to PDF having font effects such as text alignment, wordwrap, text indent, shrink to fit, underline and strikethrough, refer to the following example code.

Java
Copy Code
// Set Aligment
sheet.getRange("A1").setValue("Alignment");
sheet.getRange("B2").setValue("Left Alignment");
sheet.getRange("B2").setHorizontalAlignment(HorizontalAlignment.Left);
sheet.getRange("C2").setValue("Center Alignment");
sheet.getRange("C2").setHorizontalAlignment(HorizontalAlignment.Center);
sheet.getRange("D2").setValue("Right Alignment");
sheet.getRange("D2").setHorizontalAlignment(HorizontalAlignment.Right);
sheet.getRange("B3").setValue("Top Alignment");
sheet.getRange("B3").setVerticalAlignment(VerticalAlignment.Top);
sheet.getRange("C3").setValue("Middle Alignment");
sheet.getRange("C3").setVerticalAlignment(VerticalAlignment.Center);
sheet.getRange("D3").setValue("Bottom Alignment");
sheet.getRange("D3").setVerticalAlignment(VerticalAlignment.Bottom);
sheet.getRange("B4").setValue(
"Test String. \nThis is a test string for Justify Alignment. ");
sheet.getRange("B4").setHorizontalAlignment(HorizontalAlignment.Justify);
sheet.getRange("B4").setVerticalAlignment(VerticalAlignment.Justify);
sheet.getRange("C4").setValue(
"Test String. \nThis is a test string for Distributed Alignment. ");
sheet.getRange("C4").setHorizontalAlignment(HorizontalAlignment.Distributed);
sheet.getRange("C4").setVerticalAlignment(VerticalAlignment.Distributed);
        
// Set wordwrap
sheet.getRange("A6").setValue("Wordwrap");
sheet.getRange("B7").setValue("This is a test string for Wordwrap");
sheet.getRange("C7").setValue("This is a test string \n for Wordwrap");
sheet.getRange("B7:C7").setWrapText(true);

// Set text indent
sheet.getRange("A9").setValue("Indent");
sheet.getRange("B10").setValue("Left Indent");;
sheet.getRange("B10").setIndentLevel(3);
sheet.getRange("C10").setValue("Right Indent");
sheet.getRange("C10").setIndentLevel(3);
sheet.getRange("C10").setHorizontalAlignment(HorizontalAlignment.Right);

// Apply Shrink to fit
sheet.getRange("A12").setValue("Shrink to fit");
sheet.getRange("B13").setValue("This is a test string for \"Shrink to fit\"");
sheet.getRange("B13").setShrinkToFit(true);

// Set Underline
sheet.getRange("A15").setValue("Underline");
sheet.getRange("B16").setValue("Single Underline");
sheet.getRange("B16").getFont().setUnderline(UnderlineType.Single);

// Use Strikethrough
sheet.getRange("A18").setValue("Strikthrough");
sheet.getRange("B19").setValue("Strikthrough");
sheet.getRange("B19").getFont().setStrikethrough(true);

// Customize other settings
sheet.getColumns().get(0).getFont().setBold(true);
sheet.getColumns().get(0).setColumnWidthInPixel(100);
sheet.getColumns().get(1).setColumnWidthInPixel(200);
sheet.getColumns().get(2).setColumnWidthInPixel(245);
sheet.getColumns().get(3).setColumnWidthInPixel(234);
sheet.getRows().get(2).setRowHeightInPixel(72);
sheet.getRows().get(3).setRowHeightInPixel(123);
sheet.getRows().get(6).setRowHeightInPixel(48);
sheet.getRange("A1:D19").getBorders().setLineStyle(BorderLineStyle.Thin);
sheet.getPageSetup().setPaperSize(PaperSize.A3);
        
// Save to a pdf file
workbook.save("ExportFontEffects.pdf", SaveFileFormat.Pdf);