Skip to main content

Posts

Showing posts from 2020

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.setFontNam

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>

Add Hyperlinks to Excel in Java

In Excel, you can create a hyperlink to a web page, a file, an email address or create an image hyperlink. In this article, I’m going to show you how to add these hyperlinks to an Excel file 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 .   Add hyperlinks import com.spire.xls.ExcelPicture ; import com.spire.xls.ExcelVersion ; import com.spire.xls.HyperLink ; import com.spire.xls.Workbook ; import com.spire.xls.Worksheet ; public class AddHyperlinks {     public static void main ( String [] args) throws Exception {         //Create a Workbook instance         Workbook workbook = new Workbook();         //Get the first worksheet         Worksheet sheet = workbook .getWorksheets().get( 0 )