DEV Community: CodeSharing

Java/ Extract Text from a Word Document

CodeSharing — Mon, 15 Nov 2021 07:07:42 +0000

TXT is a common text format that can be used on many computers and mobile devices. The TXT document is known for its small size, and it makes the storage of text content more convenient. This article will demonstrate how to extract the text content in a Word document and save it as .txt format by using Free Spire.Doc for Java.

Import JAR Dependency to Your Java Application
Method 1: Download the Free Spire.Doc for Java and unzip it. Then add the Spire.Doc.jar file to your Java application as dependency.
Method 2: You can also add the jar dependency to maven project by adding the following configurations to the pom.xml.

<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>e-iceblue</groupId>
      <artifactId>spire.doc.free</artifactId>
      <version>3.9.0</version>
   </dependency>
</dependencies>

Extract Text

import com.spire.doc.Document;

        import java.io.FileWriter;
        import java.io.IOException;

public class ExtractText {

    public static void main(String[] args) throws IOException {

        //Load Word document
        Document document = new Document();
        document.loadFromFile("Island.docx");

        //Get text from document as string
        String text=document.getText();

        //Write string to a .txt file
        writeStringToTxt(text," Extracted.txt");
    }

    public static void writeStringToTxt(String content, String txtFileName) throws IOException{

        FileWriter fWriter= new FileWriter(txtFileName,true);
        try {
            fWriter.write(content);
        }catch(IOException ex){
            ex.printStackTrace();
        }finally{
            try{
                fWriter.flush();
                fWriter.close();
            } catch (IOException ex) {
                ex.printStackTrace();
            }
        }
    }
}

Java/Convert PDF to XPS and Vice Versa

CodeSharing — Wed, 10 Nov 2021 08:23:02 +0000

XPS (XML Paper Specification) is a fixed-layout document format designed to preserve document fidelity, providing device-independent document appearance. This article will introduce how to convert PDF to XPS and XPS to PDF in high quality using Free Spire.PDF for Java.

Import JAR Dependency

Method 1: You can download the free library and unzip it. Then add the Spire.Pdf.jar file to your project as dependency.
Method 2: Or you can directly add the jar dependency to maven project by adding the following configurations to the pom.xml.

<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>e-iceblue</groupId>
        <artifactId>spire.pdf.free</artifactId>
        <version>4.4.1</version>
    </dependency>
</dependencies>

Convert PDF to XPS

The PdfDocument.saveToFile() method offered by Free Spire.PDF for Java allows you to save the input PDF document to other file Formats. All you need to do is load the PDF document using PdfDocument.loadFromFile() method and then save it to .xps file format.

import com.spire.pdf.*;

public class PDFtoXPS {
    public static void main(String[] args) {
        //Load the PDF file
        PdfDocument pdf = new PdfDocument();
        pdf.loadFromFile("sample2.pdf");

        //Save to XPS
        pdf.saveToFile("ToXPS.xps", FileFormat.XPS);
    }
}

Convert XPS to PDF

import com.spire.pdf.*;

public class XPStoPDF{
    public static void main(String[] args) {
        //Load XPS 
        PdfDocument pdf = new PdfDocument();
        pdf.loadFromXPS("ToXPS.xps");

        //Save to PDF
        pdf.saveToFile("toPDF.pdf", FileFormat.PDF);
    }
}

Java/ Protect Presentation Slides

CodeSharing — Fri, 05 Nov 2021 07:22:30 +0000

To protect a PowerPoint document from being snooped or modified， Free Spire.Presentation for Java enables developers to encrypt the PowerPoint files with password or to set write protection to make the presentation read only. In this article, you will learn how to use the above two methods to protect the presentation slides.

Import jar dependency

● You can download the free library and unzip it, and then add the Spire.Presentation.jar file to your project as dependency.

● Or you can directly add the jar dependency to your maven project by adding the following configurations to the pom.xml.

<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>e-iceblue</groupId>
        <artifactId>spire.presentation.free</artifactId>
        <version>3.9.0</version>
    </dependency>
</dependencies>

Encrypt PowerPoint File

Free Spire.Presentation for Java offers the Presentation.encrypt() method to encrypt the whole document with specified password.

import com.spire.presentation.*;

public class encrypt {
    public static void main(String[] args) throws Exception {

        //Load a PPT document
        Presentation presentation = new Presentation();
        presentation.loadFromFile("Sample.pptx");


        //Encrypt the document with the password
        presentation.encrypt("abc-123");

        //Save the file
        presentation.saveToFile("output/Encrypted.pptx", FileFormat.PPTX_2010);
    }
}

Set the Presentation Slides Read Only

The Presentation.protect() method allows developers to protect the PowerPoint document with password. Unlike the Presentation.encrypt() method mentioned above, the users only need to enter the password when they want to modify the document, otherwise they can directly open the document in read-only mode.

import com.spire.presentation.*;

public class setDocumentReadOnly {
    public static void main(String[] args) throws Exception {

        //Load a PowerPoint document.
        Presentation presentation = new Presentation();
        presentation.loadFromFile("Sample.pptx");

        //Protect the document with the password
        presentation.protect("123456");

        //save the file
        presentation.saveToFile("output/Readonly.pptx", FileFormat.PPTX_2010);
    }
}

Add Data Bars in Excel using Java

CodeSharing — Mon, 01 Nov 2021 06:22:18 +0000

Data bars are a type of conditional formatting Microsoft Excel offers for visualizing the values in Excel cells. They can help you compare the values quickly because a cell with a longer bar represents a larger value, while a cell with a shorter bar represents a smaller value. This article will introduce how to add data bars in a range of cells using Free Spire.XLS for Java.

Import JAR Dependency (2 Method)

1# Download the free API and unzip it, then add the Spire.Xls.jar file to your project as dependency.
2# You can also add the jar dependency to maven project by adding the following configurations to the pom.xml.

<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>e-iceblue</groupId>
        <artifactId>spire.xls.free</artifactId>
        <version>3.9.1</version>
    </dependency>
</dependencies>

Sample Code

Free Spire.XLS for Java offers Worksheet.getCellRange() method to get a specific cell range, and you can add a new conditional formatting to the cell range using ConditionalFormats. addCondition() method. To add data bars in the selected cell range, you just need to set the type of the new conditional formatting to DataBar using ConditionalFormatWrapper.setFormatType() method.

import com.spire.xls.*;
import com.spire.xls.core.*;
import java.awt.*;

public class applyDataBars {
    public static void main(String[] args)  {

        //Create a Workbook instance
        Workbook workbook = new Workbook();

        //Load an Excel file
        workbook.loadFromFile("C:\\Users\\Administrator\\Desktop\\test.xlsx");

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

        //Get the specific cell range
        CellRange range = sheet.getCellRange("B2:B13");

        //Add the condotional format of data bar to the cell range
        IConditionalFormat format = range.getConditionalFormats().addCondition();
        format.setFormatType( ConditionalFormatType.DataBar);

        //Set color for the data bar
        format.getDataBar().setBarColor( Color.GREEN);

        //Save to file
        workbook.saveToFile("ApplyDataBars.xlsx", ExcelVersion.Version2013);
    }
}

Java/ Add Borders to Some Text in Word

CodeSharing — Mon, 25 Oct 2021 08:11:02 +0000

In a Word document, when we want to emphasize some text or paragraphs, in addition to bolding the text or changing their font color, we can also add borders to them. This article will demonstrate how to apply a border around a set of characters and a whole paragraph by using Free Spire.Doc for Java.

Installation
Method 1: Download the Free Spire.Doc for Java and unzip it. Then add the Spire.Doc.jar file to your Java application as dependency.
Method 2: You can also add the jar dependency to maven project by adding the following configurations to the pom.xml.

<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>e-iceblue</groupId>
      <artifactId>spire.doc.free</artifactId>
      <version>3.9.0</version>
   </dependency>
</dependencies>

Add Borders

import com.spire.doc.Document;
import com.spire.doc.FileFormat;
import com.spire.doc.Section;
import com.spire.doc.documents.BorderStyle;
import com.spire.doc.documents.BreakType;
import com.spire.doc.documents.Paragraph;
import com.spire.doc.fields.TextRange;

import java.awt.*;

public class AddBorders {

    public static void main(String[] args) {

        //Create a Document instance
        Document doc = new Document();

        //Add a section
        Section section = doc.addSection();

        //Add a border to a set of characters
        Paragraph para = section.addParagraph();
        TextRange tr = para.appendText("The Scarlet Letter");
        tr.getCharacterFormat().getBorder().setBorderType(BorderStyle.Single);
        tr.getCharacterFormat().getBorder().setColor(Color.BLUE);
        String text = " is a true masterpiece of American Literature and a must-read for every student of literature. ";
        para.appendText(text);
        para.appendBreak(BreakType.Line_Break);

        //Add a border to a paragraph
        para = section.addParagraph();
        String text2 = "This classic novel from the cannon of American Literature exemplifies the genre of Dark Romanticism. " +
                "In this story, the consequences of Hester Prynne's adulterous affair with the reverend Arthur Dimmesdale are " +
                "borne out as she gives birth to their child and is forced to wear a Scarlet Letter A, embroidered on her bosom, as a sign of her adultery.";

        para.appendText(text2);
        para.getFormat().getBorders().setBorderType(BorderStyle.Single);
        para.getFormat().getBorders().setColor(Color.BLUE);

        //Save the document
        doc.saveToFile("AddBorder.docx", FileFormat.Docx_2013);
    }
}

Hide or Show Gridlines in Excel in Java

CodeSharing — Mon, 18 Oct 2021 07:10:32 +0000

The Excel gridlines run between the columns and row of the spreadsheet, allowing you to see where each individual cell is located. This article will share how to use a free Java API to hide or show gridlines in a Excel worksheet programmatically.

Installation (2 Method)
1# Download the free API (Free Spire.XLS for Java)and unzip it, then add the Spire.Xls.jar file to your project as dependency.
2# You can also add the jar dependency to maven project by adding the following configurations to the pom.xml.

<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>e-iceblue</groupId>
        <artifactId>spire.xls.free</artifactId>
        <version>3.9.1</version>
    </dependency>
</dependencies>

Sample code

import com.spire.xls.ExcelVersion;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;

public class HideOrShowGridlines {

    public static void main(String[] args) {

        //Create a Workbook object
        Workbook workbook = new Workbook();

        //Load a sample Excel file
        workbook.loadFromFile("C:\\Users\\Administrator\\Desktop\\input.xlsx");

        //Get the fisrt worksheet
        Worksheet worksheet = workbook.getWorksheets().get(0);

        //Hide gridlines
        worksheet.setGridLinesVisible(false);

        //Show gridlines
        //worksheet.setGridLinesVisible(true);

        //Save the document
        workbook.saveToFile("HideGridlines.xlsx", ExcelVersion.Version2016);
    }
}

Java: Add and Read Comments in Excel

CodeSharing — Mon, 11 Oct 2021 06:27:10 +0000

Excel comments can serve for various purposes, such as explaining the contents in cells, offering tips to other users, or cross-referencing with other Excel workbooks. This article will share how to add comments to an Excel file and read the comments using Free Spire.XLS for Java.

Import JAR Dependency (2 Method)
1# Download the free library and unzip it, then add the Spire.Xls.jar file to your project as dependency.
2# You can also add the jar dependency to maven project by adding the following configurations to the pom.xml.

<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>e-iceblue</groupId>
        <artifactId>spire.xls.free</artifactId>
        <version>3.9.1</version>
    </dependency>
</dependencies>

Add Comments
The following is the sample code of adding a regular comment and a rich text comment to an Excel file

import com.spire.xls.*;

public class InsertComments {
    public static void main(String[] args){
        //Load a Excel file
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Sales1.xlsx");

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

        //Create fonts
        ExcelFont font = workbook.createFont();
        font.setFontName("Arial");
        font.setSize(11);
        font.setKnownColor(ExcelColors.Orange);
        ExcelFont fontBlue = workbook.createFont();
        fontBlue.setKnownColor(ExcelColors.LightBlue);
        ExcelFont fontRed = workbook.createFont();
        fontRed.setKnownColor(ExcelColors.Red);

        //Add regular comment to specific cell range
        CellRange range = sheet.getCellRange("A8");
        range.getComment().setText("A new employee.");
        range.autoFitColumns();

        //Add rich text comment to specific cell range
        range = sheet.getCellRange("F8");
        range.getComment().getRichText().setText("Best sales of the month.");
        range.getComment().getRichText().setFont(0, 10, fontRed);
        range.getComment().getRichText().setFont(17, 23, fontBlue);

        //Save the resultant file
        workbook.saveToFile("AddComments.xlsx", ExcelVersion.Version2013);
    }
}

Read Comments

import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;

public class ReadComments {
    public static void main(String[] args){
        //Load Excel file
        Workbook workbook = new Workbook();
        workbook.loadFromFile("AddComments.xlsx");
        //Get the first worksheet
        Worksheet sheet = workbook.getWorksheets().get(0);
        //Print out the comment
        System.out.println("The first comment: " + sheet.getCellRange("A8").getComment().getText());
        System.out.println("The second comment: " + sheet.getCellRange("F8").getComment().getRichText().getRtfText());
    }
}

[Java] Converting PDF to SVG

CodeSharing — Thu, 30 Sep 2021 06:40:10 +0000

SVG (Scalable Vector Graphics) is a vector image format that can be searched, indexed, scripted, compressed, and can be scaled in size without loss of quality. In this article, I will share the following two ways to convert a PDF file to SVG format using Free Spire.PDF for Java.
● Converting each page of the PDF file into a single SVG file.
● Converting multiple pages of the PDF file into one SVG file.

Import jar dependency
Method 1: Download the free library and unzip it. Then add the Spire.Pdf.jar file to your project as dependency.
Method 2: Directly add the jar dependency to maven project by adding the following configurations to the pom.xml.

<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>e-iceblue</groupId>
        <artifactId>spire.pdf.free</artifactId>
        <version>4.4.1</version>
    </dependency>
</dependencies>

Sample 1: Converting a 3-page PDF file to 3 SVG files

import com.spire.pdf.*;

public class ToSVG {
    public static void main(String[] args) {

        //Load the PDF file
        PdfDocument pdf = new PdfDocument();
        pdf.loadFromFile("Island.pdf");

        //Save to SVG image
        pdf.saveToFile("ToSVG.svg", FileFormat.SVG);
        pdf.close();
    }
}

Sample 2: Converting a 3-page PDF file to 1 SVG file

import com.spire.pdf.*;


public class PDFtoSVG {
    public static void main(String[] args) throws Exception {

        String inputPath = "Island.pdf";

        PdfDocument document = new PdfDocument();
        document.loadFromFile(inputPath);

        document.getConvertOptions().setOutputToOneSvg(true);

        document.saveToFile("output.svg", FileFormat.SVG);
        document.close();
    }
}

Insert Textbox to Excel Worksheet Using Java

CodeSharing — Sun, 26 Sep 2021 06:53:44 +0000

Text box allows people to enter text in it and move it arbitrarily. It can be used in some areas that need to be emphasized or highlighted. This article will demonstrate how to add textbox into Excel worksheet with Free Spire.XLS for Java. We could fill in the textbox with text and image.

Installation (2 Method)
1# Download the free library and unzip it, then add the Spire.Xls.jar file to your project as dependency.
2# You can also add the jar dependency to maven project by adding the following configurations to the pom.xml.

<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>e-iceblue</groupId>
        <artifactId>spire.xls.free</artifactId>
        <version>3.9.1</version>
    </dependency>
</dependencies>

Sample Code

import com.spire.xls.*;
import com.spire.xls.core.ITextBox;
import com.spire.xls.core.ITextBoxShape;

public class ExcelTextbox {
    public static void main(String[] args) throws Exception {

        //Create a workbook
        Workbook workbook = new Workbook();

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

        //Insert the textbox with text
        ITextBox textBox = sheet.getTextBoxes().addTextBox(5, 3, 70, 196);
        textBox.setText("Insert TextBox in Excel");
        textBox.setHAlignment(CommentHAlignType.Center);
        textBox.setVAlignment(CommentVAlignType.Center);

        //Insert the textbox with picture
        ITextBoxShape shape = sheet.getTextBoxes().addTextBox(5, 8, 128, 196);
        shape.getFill().customPicture("C:\\Users\\Administrator\\Desktop\\java.png");
        shape.getFill().setFillType(ShapeFillType.Picture);

        //Save the Excel file
        workbook.saveToFile("output/TextBox.xlsx", ExcelVersion.Version2010);
    }
}

Apply Multiple Fonts in One Cell in Java

CodeSharing — Wed, 22 Sep 2021 08:00:02 +0000

In the previous articles, I've introduced how to apply different font styles in several different Excel cells using Free Spire.XLS for Java. Now this article will share how to apply multiple font styles in a single Excel cell by using same free API.

Import the Jar dependency
Method 1: Download the Free Spire.XLS for Java and unzip it, then add the Spire.Xls.jar file to your project as dependency.

Method 2: Directly add the jar dependency to maven project by adding the following configurations to the pom.xml.

<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>e-iceblue</groupId>
        <artifactId>spire.xls.free</artifactId>
        <version>3.9.1</version>
    </dependency>
</dependencies>

Sample Code

import com.spire.xls.*;

import java.awt.*;

public class ApplyMultiFontsInCell {

    public static void main(String[] args) {

        //Create a Workbook instance
        Workbook wb = new Workbook();

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

        //Create first Excel font
        ExcelFont font1 = wb.createFont();
        font1.setFontName("Calibri");
        font1.setColor(Color.blue);
        font1.setSize(12f);
        font1.isItalic(true);

        //Create second Excel font
        ExcelFont font2 = wb.createFont();
        font2.setFontName("Times New Roman");
        font2.setColor(Color.BLACK);
        font2.setSize(12f);
        font2.isItalic(true);
        font2.setUnderline(FontUnderlineType.Double);

        //Create third Excel font
        ExcelFont font3 = wb.createFont();
        font3.setFontName("Arial");
        font3.setColor(Color.RED);
        font3.setSize(14f);
        font3.isBold(true);

        //Insert text to cell B5
        RichText richText = sheet.getCellRange("B5").getRichText();
        richText.setText("This is an example of how to apply multiple font styles in one Excel cell using Java.");

        //Apply three fonts to the text in the cell B5
        richText.setFont(0, 21, font1);
        richText.setFont(22, 55, font2);
        richText.setFont(56, 84, font3);

        //Save the document
        wb.saveToFile("MultiFonts.xlsx", ExcelVersion.Version2016);
    }
}

Insert Images to a Table in Word in Java

CodeSharing — Fri, 17 Sep 2021 07:01:48 +0000

Tables can be added to Word documents to help display data, and in the same way, images can be inserted to tables to support data or to make the whole table more eye-catching. In this article, I'm going to demonstrate how to insert images to table cells in a Word document using Free Spire.Doc for Java.

Import JAR Dependency (2 methods)
● Download the Free Spire.Doc for Java and unzip it, then add the Spire.Doc.jar file to your Java application as dependency.

● Directly add the jar dependency to maven project by adding the following configurations to the pom.xml.

<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>e-iceblue</groupId>
      <artifactId>spire.doc.free</artifactId>
      <version>3.9.0</version>
   </dependency>
</dependencies>

Sample Code

import com.spire.doc.AutoFitBehaviorType;
import com.spire.doc.Document;
import com.spire.doc.Section;
import com.spire.doc.Table;
import com.spire.doc.fields.DocPicture;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.InputStream;

public class InsertImageToTableCell {

    public static void main(String[] args) throws FileNotFoundException {

        //Create a Document object
        Document document = new Document();

        //Add a section
        Section section  = document.addSection();

        //Add a table
        Table table = section.addTable(true);
        table.resetCells(2,2);
        table.autoFit(AutoFitBehaviorType.Auto_Fit_To_Contents);

        //Load an image to InputStream
        InputStream inputStream = new FileInputStream("C:\\Users\\Administrator\\Desktop\\logo1.jpg");

        //Insert the image to the cell(0,0)
        DocPicture picture = table.get(0,0).addParagraph().appendPicture(inputStream);

        //Set the width and height of the image
        picture.setWidth(100);
        picture.setHeight(100);

        //Insert another image to the cell(1,1)
        inputStream = new FileInputStream("C:\\Users\\Administrator\\Desktop\\logo2.jpg");
        picture = table.get(1,1).addParagraph().appendPicture(inputStream);
        picture.setWidth(100);
        picture.setHeight(100);

        //Save the document
        document.saveToFile("InsertImgToCell.docx");
    }
}

Print Excel Documents Using Java

CodeSharing — Mon, 13 Sep 2021 08:13:01 +0000

After finish editing an Excel document, it's inevitably that sometimes we may need to print it. And this article will introduce how to print Excel documents using Free Spire.XLS for Java.

<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>e-iceblue</groupId>
        <artifactId>spire.xls.free</artifactId>
        <version>3.9.1</version>
    </dependency>
</dependencies>

Sample code

import com.spire.xls.Workbook;

import javax.print.PrintService;
import java.awt.print.PageFormat;
import java.awt.print.Paper;
import java.awt.print.PrinterException;
import java.awt.print.PrinterJob;

public class PrintExcel {

    public static void main(String[] args) throws Exception{

        //Create a workbook and load an Excel file
        Workbook workbook = new Workbook();
        workbook.loadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");

        //Create a PrinterJob object
        PrinterJob printerJob = PrinterJob.getPrinterJob();

        //Specify printer name
        PrintService myPrintService = findPrintService("\\\\192.168.1.104\\HP LaserJet P1007");
        printerJob.setPrintService(myPrintService);

        //Create a PageFormat object and set it to the default size and orientation
        PageFormat pageFormat  = printerJob.defaultPage();

        //Return a copy of the Paper object associated with this PageFormat.
        Paper paper = pageFormat .getPaper();

        //Set the imageable area of this Paper.
        paper.setImageableArea(0,0,pageFormat .getWidth(),pageFormat .getHeight());

        //Set the Paper object for this PageFormat.
        pageFormat .setPaper(paper);

        //Set the number of copies
        printerJob .setCopies(1);

        //Call painter to render the pages in the specified format
        printerJob .setPrintable(workbook,pageFormat);

        //execute print
        try {
            printerJob.print();
        } catch (PrinterException e) {
            e.printStackTrace();
        }
    }
    //Get print service by printer name
    private static PrintService findPrintService(String printerName) {

        PrintService[] printServices = PrinterJob.lookupPrintServices();
        for (PrintService printService : printServices) {
            if (printService.getName().equals(printerName)) {
                return printService;
            }
        }
        return null;
    }
}