Documents for Excel, Java Edition Documentation
Manage File Operations / Export to a PDF File / Export Text
In This Topic
    Export Text
    In This Topic

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