Use Multiple Fonts and Font Colors in one Excel Cell in Java

At some point, you may want to use multiple fonts and font colors for outstanding some specific words in one Excel cell. In this article, I’m going to show you how to use multiple fonts and font colors in one Excel cell programmatically in Java by using Free Spire.XLS for Java API.

Before using the following code, you need to download Free Spire.XLS for Java API, unzip the package and then add Spire.Xls.jar in the lib folder into your project. If you’re creating maven projects, you can install Free Spire.XLS for Java API from maven repository.

Using the code

import com.spire.xls.*;

import java.awt.*;

public class UseMultipleFontsAndFontColors {
    public static void main(String[] args) throws Exception {
        //Create a Workbook instance
        Workbook wb = new Workbook();

        //Get the first worksheet
        Worksheet sheet = wb.getWorksheets().get(0);

        //Create one Excel font
        ExcelFont font1 = wb.createFont();
        font1.setFontName("Calibri");
        //Set font color
        font1.setColor(Color.blue);
        font1.setSize(12f);
        font1.isBold(true);

        //Create another Excel font
        ExcelFont font2 = wb.createFont();
        font2.setFontName("Times New Roman");
        //Set font color
        font2.setColor(Color.red);
        font2.setSize(12f);
        font2.isBold(true);

        //Insert text to cell B5
        RichText richText = sheet.getCellRange("B5").getRichText();
        richText.setText("Blue and Read");

        //Apply two fonts to the text in the cell B5
        richText.setFont(0, 3, font1);
        richText.setFont(9, 12, font2);

        //Save the document
        wb.saveToFile("MultipleFonts.xlsx", ExcelVersion.Version2013);
    }
}

Output:

Comments

3 Ways to Generate Word Documents from Templates in Java

A template is a document with pre-applied formatting like styles, tabs, line spacing and so on. You can quickly generate a batch of documents with the same structure based on the template. In this article, I am going to show you the different ways to generate Word documents from templates programmatically in Java using Free Spire.Doc for Java library. Prerequisite First of all, you need to add needed dependencies for including Free Spire.Doc for Java into your Java project. There are two ways to do that. If you use maven, you need to add the following code to your project’s pom.xml file. <repositories> <repository> <id>com.e-iceblue</id> <name>e-iceblue</name> <url>http: //repo.e-iceblue.com/nexus/content/groups/public/</url> </repository> </repositories> <dependencies> <dependency> <g

Simple Java Code to Convert Excel to PDF in Java

This article demonstrates a simple solution to convert an Excel file to PDF in Java by using free Excel API – Free Spire.XLS for Java . The following examples illustrate two possibilities to convert Excel to PDF: Convert the whole Excel file to PDF Convert a particular Excel Worksheet to PDF Before start with coding, you need to Download Free Spire.XLS for Java package , unzip it and import Spire.Xls.jar file from the lib folder in your project as a denpendency. 1. Convert the whole Excel file to PDF Spire.XLS for Java provides saveToFile method in Workbook class that enables us to easily save a whole Excel file to PDF. import com.spire.xls.FileFormat; import com.spire.xls.Workbook; public class ExcelToPDF { public static void main(String[] args){ //Create a Workbook Workbook workbook = new Workbook(); workbook.loadFromFile( "Sample.xlsx" ); //Fit to page workbook.getConverterSetting().setShee

Insert and Extract OLE objects in Word in Java

You can use OLE (Object Linking and Embedding) to include content from other programs, such as another Word document, an Excel or PowerPoint document to an existing Word document. This article demonstrates how to insert and extract embedded OLE objects in a Word document in Java by using Free Spire.Doc for Java API. Add dependencies First of all, you need to add needed dependencies for including Free Spire.Doc for Java into your Java project. There are two ways to do that. If you use maven, you need to add the following code to your project’s pom.xml file. <repositories> <repository> <id>com.e-iceblue</id> <name>e-iceblue</name> <url>http://repo.e-iceblue.com/nexus/content/groups/public/</url> </repository> </repositories> <dependencies> <dependency> <groupId>

File APIs for Word/Excel/PowerPoint/PDF

Search This Blog