DEV Community: Alexis

Java - Add or Read Math Equations in Word Documents

Alexis — Wed, 26 Apr 2023 03:44:22 +0000

An equation is a mathematical formula or expression that represents a particular concept, principle, or calculation. It is an essential element in scientific papers and mathematics books. By incorporating equations in your document, you can effectively communicate complex mathematical concepts and calculations to your readers in a clear and professional manner. In this article, we will describe how to add or read math equations in Word documents in Java using Spire.Doc for Java library.

Add Math Equations to Word Documents in Java
Read Math Equations in Word Documents in Java

Add Dependencies

Before coding, you need to add needed dependencies for including Spire.Doc for Java into your Java project. There are two ways to do that.

Method 1: If you are using maven, you can easily import the JAR file of Spire.Doc for Java into your application by adding the following code to your project’s pom.xml file.

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.doc </artifactId>
        <version>11.4.2</version>
    </dependency>
</dependencies>

Method 2: If you are not using maven, you can download Spire.Doc for Java from this link, extract the zip file and then import the Spire.Doc.jar file under the lib folder into your project as a dependency.

Add Math Equations to Word Documents in Java

With Spire.Doc, you can easily create math equations by specifying their LateX code or MathML code using the OfficeMath.fromLatexMathCode(String latexMathCode) or OfficeMath.fromMathMLCode(String mathMLCode) method. After that, you can add the equations to specific paragraphs of your Word document using the Paragraph.getItems().add(IDocumentObject entity) method.

The following steps explain how to create and add math equations to a Word document:

Put the LateX code into a String array.
Put the MathML code into a String array.
Initialize an instance of the Document class and load a Word document using the Document.loadFromFile(String fileName) method.
Get a specific section using the Document.getSections().get(int index) method.
Iterate through all the LateX code in the String array.
Add a paragraph to the section using the Section.addParagraph() method.
Initialize an instance of the OfficeMath class, then convert the current LateX code to a math equation using the OfficeMath.fromLatexMathCode(String latexMathCode) method.
Add the math equation to the paragraph using the Paragraph.getItems().add(IDocumentObject entity) method.
Iterate through all the MathML code in the string array.
Add a paragraph to the section using the Section.addParagraph() method.
Initialize an instance of the OfficeMath class, then convert the current MathML code to a math equation using the OfficeMath.fromMathMLCode(String mathMLCode) method.
Add the math equation to the paragraph using the Paragraph.getItems().add(IDocumentObject entity) method.
Save the result document using the Document.saveToFile(String filename, FileFormat fileFormat) method.

import com.spire.doc.*;
import com.spire.doc.documents.Paragraph;
import com.spire.doc.fields.omath.OfficeMath;

public class AddMathEquations {
    public static void main(String[] args) {
        //Put the LateX code into a String array
        String[] latexMathCode = {
                "\\left(a+\\frac{b}{c}\\right)",
                "\\rect{\\frac{a}{b}}",
                "\\frac{a}{b+c}",
                "\\sqrt[5]{a^2}",
        };

        //Put the MathML code into a String array
        String[] mathMLCode = {
                "<mml:math xmlns:mml=\"http://www.w3.org/1998/Math/MathML\" xmlns:m=\"http://schemas.openxmlformats.org/officeDocument/2006/math\"><mml:msup><mml:mrow><mml:mi>x</mml:mi></mml:mrow><mml:mrow><mml:mn>2</mml:mn></mml:mrow></mml:msup><mml:mo>+</mml:mo><mml:msqrt><mml:msup><mml:mrow><mml:mi>x</mml:mi></mml:mrow><mml:mrow><mml:mn>2</mml:mn></mml:mrow></mml:msup><mml:mo>+</mml:mo><mml:mn>1</mml:mn></mml:msqrt><mml:mo>+</mml:mo><mml:mn>1</mml:mn></mml:math>",
                "<mml:math xmlns:mml=\"http://www.w3.org/1998/Math/MathML\" xmlns:m=\"http://schemas.openxmlformats.org/officeDocument/2006/math\"><mml:mn>2</mml:mn><mml:mi>α</mml:mi><mml:mo>-</mml:mo><mml:mi>s</mml:mi><mml:mi>i</mml:mi><mml:mi>n</mml:mi><mml:mi>y</mml:mi><mml:mo>+</mml:mo><mml:mi>x</mml:mi></mml:math>",
                "<mml:math xmlns:mml=\"http://www.w3.org/1998/Math/MathML\" xmlns:m=\"http://schemas.openxmlformats.org/officeDocument/2006/math\"><mml:mfrac><mml:mrow><mml:mn>1</mml:mn></mml:mrow><mml:mrow><mml:mn>2</mml:mn><mml:mo>+</mml:mo><mml:mi>x</mml:mi></mml:mrow></mml:mfrac></mml:math>",
                "<mml:math xmlns:mml=\"http://www.w3.org/1998/Math/MathML\" xmlns:m=\"http://schemas.openxmlformats.org/officeDocument/2006/math\"><mml:mfenced><mml:mrow><mml:mn>1</mml:mn><mml:mo>+</mml:mo><mml:mo>|</mml:mo><mml:mi>x</mml:mi><mml:mo>-</mml:mo><mml:mfenced open=\"[\" close=\"]\"><mml:mrow><mml:mi>a</mml:mi><mml:mo>-</mml:mo><mml:mi>b</mml:mi></mml:mrow></mml:mfenced><mml:mo>|</mml:mo></mml:mrow></mml:mfenced></mml:math>",
        };

        //Initialize an instance of the Document class.
        Document doc = new Document();
        //Load a Word document
        doc.loadFromFile("Sample.docx");

        //Get the first section of the document
        Section section = doc.getSections().get(0);

        Paragraph paragraph = null;
        OfficeMath officeMath;

        //Add math equations to the section by specifying their LaTeX code
        for (int i = 0; i < latexMathCode.length; i++) {
            paragraph = section.addParagraph();
            officeMath = new OfficeMath(doc);
            officeMath.fromLatexMathCode(latexMathCode[i]);
            paragraph.getItems().add(officeMath);
        }

        //Add math equations to the section by specifying their MathML code
        for (int i = 0; i < mathMLCode.length; i++) {
            paragraph = section.addParagraph();
            officeMath = new OfficeMath(doc);
            officeMath.fromMathMLCode(mathMLCode[i]);
            paragraph.getItems().add(officeMath);
        }

        //Save the result document
        String result = "AddMathEquations.docx";
        doc.saveToFile(result, FileFormat.Docx_2013);
    }
}

Read Math Equations in Word Documents in Java

You can read the math equations in a Word document back to MathML code by iterating through the elements in the document, then finding the elements that are of the OfficeMath type and converting them to MathML code using the OfficeMath.toMathMLCode() method.

The following steps explain how to read the math equations in a Word document back to MathML code:

Initialize an instance of the Document class and load a Word document using the Document.loadFromFile(String fileName) method.
Initialize an instance of the StringBuilder class.
Iterate through all the sections in the document.
Iterate through all the paragraphs in each section.
Iterate through all the child objects in each paragraph.
Check if the objects are of the OfficeMath type.
If the result is true, typecast the objects to OfficeMath type, then convert them to MathML code using the OfficeMath.toMathMLCode() method and append the result to the StringBuilder instance.
Write the content of the StringBuilder instance into a TXT file.

import com.spire.doc.*;
import com.spire.doc.fields.omath.OfficeMath;

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;

public class ReadMathEquations {
    public static void main(String[] args) {        
        //Initialize an instance of the Document class
        Document doc = new Document();
        //Load a Word document
        doc.loadFromFile("AddMathEquations.docx");

        //Initialize an instance of the StringBuilder class
        StringBuilder stringBuilder = new StringBuilder();

        //Iterate through all the sections in the document
        for(int i = 0; i < doc.getSections().getCount(); i++){
            //Iterate through all the paragraphs in each section
            for(int j = 0; j < doc.getSections().get(i).getParagraphs().getCount(); j++){
                //Iterate through all the child objects in each paragraph
                for(int k = 0;k < doc.getSections().get(i).getParagraphs().get(j).getChildObjects().getCount(); k++){
                    DocumentObject obj =doc.getSections().get(i).getParagraphs().get(j).getChildObjects().get(k);
                    //Check if the objects are of OfficeMath type
                    if (obj instanceof OfficeMath) {
                        OfficeMath math=(OfficeMath)doc.getSections().get(i).getParagraphs().get(j).getChildObjects().get(k);
                        //Read the math equations back to MathML code and append the result to the StringBuilder
                        stringBuilder.append(math.toMathMLCode()+"\n");
                    }
                }
            }
        }

        //Write the content of the StringBuilder into a TXT file
        File file = new File("ReadMathEquations.txt");
        try (BufferedWriter writer = new BufferedWriter(new FileWriter(file))) {
            writer.append(stringBuilder);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }        
    }
}

Java Protect Excel Files

Alexis — Tue, 25 Apr 2023 08:59:26 +0000

Excel files are widely used to store and organize data, from personal finances to business records. To prevent the changes or sharing of important data in your Excel files, Spire.XLS for java offers many ways to protect your Excel files. This article will show you how to protect the MS Excel files in Java applications from the following four parts.

Set Password to Protect Excel Files using Java
Mark as final
Java Protect Excel Worksheets with a Specific Protection Type
Add digital signature to Excel

Install Spire.XLS for Java

First of all, you're required to add the Spire.Xls.jar file as a dependency in your Java program. The JAR file can be downloaded from this link. If you use Maven, you can easily import the JAR file in your application by adding the following code to your project's pom.xml file.

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>

<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls</artifactId>
        <version>13.4.1</version>
    </dependency>
</dependencies>

Protect Excel Files using Java

Spire.XLS for java offers Workbook.protect() method to restrict the access to Excel spreadsheet with a password. This prevents unauthorized users from opening or modifying the file without the correct password. The following are the steps to password protect a workbook using Spire.XLS for Java.

Create a Workbook object.
Load an Excel file using Workbook.loadFromFile() method.
Protect the workbook using a password using Workbook.protect() method.
Save the workbook to another Excel file using Workbook.saveToFile() method.

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

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

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

        //Load an Excel file
        workbook.loadFromFile("Sample.xlsx");

        //Protect workbook with a password
        workbook.protect("psd123");

        //Save the workbook to another Excel file
        workbook.saveToFile("Encrypted.xlsx", ExcelVersion.Version2016);
    }
}

Mark as Final

The Mark as Final command makes the Excel workbook read-only and prevents changes to the document. When you share an Excel that is marked as final, you're telling viewers the spreadsheet is final and no changes on it are wanted.

Create a Workbook object.
Load an Excel file using Workbook.loadFromFile() method.
Set the document property MarkAsFinal as true
Save the workbook to another Excel file using Workbook.saveToFile() method

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

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

        //Create a Workbook object and load the sample file
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Sample.xlsx");

        //Set the document property MarkAsFinal as true
        workbook.getCustomDocumentProperties().add("_MarkAsFinal", true);

        //Save the workbook to another Excel file
        workbook.saveToFile("Final.xlsx", ExcelVersion.Version2016);
    }

Protect Worksheets using Java

If you wish to grant people permission to read your Excel document but restrict the types of modifications they are allowed to make on a worksheet, you can protect the worksheet with a specific protection type. Here are the steps:

Create a Workbook object.
Load an Excel file using Workbook.loadFromFile() method.
Get a specific worksheet using Workbook.getWorksheets().get(index) method.
Protect the worksheet with a protection type using Worksheet.protect(String password, EnumSet.of options) method.
Save the workbook to another Excel file using Workbook.saveToFile() method.

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

import java.util.EnumSet;

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

        //Create a Workbook object
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Sample.xlsx");

        //Get a specific worksheet
        Worksheet worksheet = workbook.getWorksheets().get(1);

        //Protect the worksheet with the permission password and the specific protect type
        worksheet.protect("psd-permission", EnumSet.of(SheetProtectionType.None));

        //Save the workbook to another Excel file
        workbook.saveToFile("ProtectWorksheet.xlsx", ExcelVersion.Version2016);
    }
}

Add digital signatures to Excel

You can add a digital signature to verify the authenticity of an Excel file. Once the digital signature is added, the file becomes read-only to discourage further editing. If someone makes changes to the file, the digital signature will become invalid immediately.

Instantiate a Workbook instance.
Load an Excel file using Workbook.loadFromFile() method.
Instantiate a CertificateAndPrivateKey instance with the specified certificate (.pfx) file path and the password of the .pfx file.
Add a digital signature to the file using Workbook.addDigitalSignature(CertificateAndPrivateKey, String, Date) method.
Save the result file using Workbook.saveToFile() method.

import com.spire.xls.ExcelVersion;
import com.spire.xls.Workbook;
import com.spire.xls.digital.CertificateAndPrivateKey;
import java.util.Date;

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

        //Create a Workbook object
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Sample.xlsx");

        //Add a digital signature to the file
        CertificateAndPrivateKey cap = new CertificateAndPrivateKey("test.pfx","e-iceblue");
        workbook.addDigitalSignature(cap, "e-iceblue",new Date());

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

Conclusion:

In this article, you have learned how to protect Excel Spreadsheets using Java by password protection, read-only access, worksheet protection, and digital signatures. Furthermore, Spire.XLS for Java also supports to unprotect the Excel workbook nor a particular worksheet in an Excel workbook. You can explore more about Spire.XLS for Java in Excel Forum.

Java - How to Split a PDF into Multiple PDFs

Alexis — Fri, 21 Apr 2023 10:46:23 +0000

Sometimes you may only need to share certain pages or sections of a PDF file, rather than the entire document. By splitting the PDF file, you can easily extract the information you need and share it with others, while keeping the rest of the file private. In this article, I will introduce how to split a PDF file into multiple PDF files using Java.

Split a PDF File by Each Page in Java
Split a PDF File by Page Ranges in Java
Split a PDF Page into Multiple Pages in Java

Java Library to Split PDF

In order to split PDF files, this article uses a third-party library called Spire.PDF for Java, which is a feature-rich library for creating, manipulating, converting, and printing PDF files in Java applications.

Before coding, you need to add needed dependencies for including Spire.PDF for Java into your Java project. There are two ways to do that.

Method 1: If you are using maven, you can easily import the JAR file of Spire.PDF for Java into your application by adding the following code to your project’s pom.xml file.

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.pdf</artifactId>
        <version>9.3.11</version>
    </dependency>
</dependencies>

Method 2: If you are not using maven, you can download Spire.PDF for Java from the official website, extract the zip file and then import the Spire.Pdf.jar file under the lib folder into your project as a dependency.

Split a PDF File by Each Page in Java

You can split a PDF file by each page using the PdfDocument.split(String destFilePattern, int startNumber) method. After splitting, each page in the PDF file will be saved as a separate PDF file.

The following steps demonstrate how to split a PDF file by each page:

Initialize an instance of the PdfDocument class and pass the PDF file’s path to the constructor of the class as a parameter.
Split every page of the PDF file into a separate file using the PdfDocument.split(String destFilePattern, int startNumber) method.

import com.spire.pdf.PdfDocument;

public class SplitPdfByEachPage {
    public static void main(String[] args) {
        //Initialize an instance of the PdfDocument class and pass the PDF file’s path to the constructor of the class as a parameter
        PdfDocument doc = new PdfDocument("Sample.pdf");

        //Split every page of the PDF into a separate file
        doc.split("Output/Split-{0}.pdf", 1);
        doc.close();
    }
}

Split a PDF File by Page Ranges in Java

Spire.PDF for Java offers the PdfDocument.insertPageRange(PdfDocument doc, int startIndex, int endIndex) method which enables you to import a range of pages from a PDF file into another PDF file. By using this method, you can easily split a PDF file by page ranges.

The detailed steps demonstrate how to split a PDF file by two page ranges (page 1~2, and page 3~5):

Initialize an instance of the PdfDocument class and pass the PDF file’s path to the constructor of the class as a parameter.
Initialize an instance of the PdfDocument class to create a new PDF file.
Import the 1st and 2nd pages of the source PDF document to the new PDF file using the PdfDocument.insertPageRange(PdfDocument doc, int startIndex, int endIndex) method.
Save the new PDF file using the PdfDocument.SaveToFile() method.
Initialize an instance of the PdfDocument class to create a new PDF file.
Import the 3rd, 4th, and 5th pages of the source PDF document to the new PDF file using the PdfDocument.insertPageRange(PdfDocument doc, int startIndex, int endIndex) method.
Save the new PDF file using the PdfDocument.SaveToFile() method.

import com.spire.pdf.PdfDocument;

public class SplitPdfByPageRanges {
    public static void main(String[] args) {
        //Initialize an instance of the PdfDocument class and pass the PDF file’s path to the constructor of the class as a parameter
        PdfDocument doc = new PdfDocument("Sample.pdf");

        //Initialize an instance of the PdfDocument class to create a new PDF file
        PdfDocument newDoc1 = new PdfDocument();
        //Import 1-2 pages of the source PDF to the new PDF
        newDoc1.insertPageRange(doc, 0, 1);
        //Save the result document
        newDoc1.saveToFile("File1.pdf");

        //Initialize an instance of the PdfDocument class to create a new PDF file
        PdfDocument newDoc2 = new PdfDocument();
        //Import 3-5 pages of the source PDF to the new PDF
        newDoc2.insertPageRange(doc, 2, 4);
        //Save the result document
        newDoc2.saveToFile("File2.pdf");
    }
}

Split a PDF Page into Multiple Pages in Java

The way to split a PDF page into multiple pages is to create a new PDF file with a smaller page size, then draw different parts of the content on the source PDF page to different pages of the new PDF file using the PdfPageBase.createTemplate().draw() method.

The following steps demonstrate how to split a PDF page into two pages:

Initialize an instance of the PdfDocument class.
Load a PDF file using the PdfDocument.loadFromFile() method.
Get a specific page using the PdfDocument.getPages().get() method.
Initialize an instance of the PdfDocument class to create a new PDF file, and set its page margins to 0.
Set the page size of the new PDF to half or a fraction of that of the source PDF.
Add a page to the new PDF document using the PdfDocument.getPages().add() method.
Draw the content of the specific page of the source PDF on the newly added page of the new PDF using the PdfPageBase.createTemplate().draw() method.
Save the document to another file using PdfDocument.saveToFile() method.

import com.spire.pdf.PdfDocument;
import com.spire.pdf.PdfPageBase;
import com.spire.pdf.graphics.PdfLayoutBreakType;
import com.spire.pdf.graphics.PdfLayoutType;
import com.spire.pdf.graphics.PdfTextLayout;

import java.awt.geom.Point2D;

public class SplitPdfPage {
    public static void main(String[] args) {
        //Initialize an instance of the PdfDocument class
        PdfDocument pdf = new PdfDocument();
        //Load the source PDF file
        pdf.loadFromFile("Input.pdf");

        //Get the first page
        PdfPageBase page = pdf.getPages().get(0);

        //Initialize an instance of the PdfDocument class to create a new PDF file
        PdfDocument newPdf = new PdfDocument();
        //Remove page margins
        newPdf.getPageSettings().getMargins().setAll(0);

        //Set the page width of the new PDF as the same as that of the source PDF
        newPdf.getPageSettings().setWidth((float) page.getSize().getWidth());
        //Set the page height of the new PDF as 1/2 of the source PDF
        newPdf.getPageSettings().setHeight((float) page.getSize().getHeight()/2);

        //Add a page to the new PDF
        PdfPageBase newPage = newPdf.getPages().add();

        //Set the PdfLayoutType to Paginate to make the content paginated automatically
        PdfTextLayout layout = new PdfTextLayout();
        layout.setBreak(PdfLayoutBreakType.Fit_Page);
        layout.setLayout(PdfLayoutType.Paginate);

        //Draw the content of the source page onto the page of the new PDF
        page.createTemplate().draw(newPage, new Point2D.Float(0, 0), layout);

        //Save the new PDF to file
        newPdf.saveToFile("SplitPdfPage.pdf");
        newPdf.close();
    }
}

Conclusion

This article introduced how to split a PDF file by each page and by page ranges, along with how to split a PDF page to multiple pages in Java using Spire.PDF for Java library. In addition to splitting PDF files, this library also supports merging PDF files along with many other manipulations on PDF files, it’s worth giving them a try by yourself.

Java Extract data from PDF table

Alexis — Fri, 21 Apr 2023 03:33:26 +0000

PDF table is one of the mainly factor on the PDF file and it contains data that may be useful for various purposes, such as analysis, reporting, or data entry. When you deal with financial reports, you usually need to extract the data from the PDF table. Spire.PDF for Java supports extracting the table data from the PDF files and converting the data into other files formats such as TXT or Excel, where the data can be easily analyzed. This article will demonstrate how to extract data from the PDF table from the following two parts:

Extract Data from PDF Tables in Java
Extract Table Data from PDF to Excel

Install Spire.Office for Java

The scenario actually uses Spire.PDF for Java for extracting tables from PDF, and Spire.XLS for Java for generating Excel files. In order to use them in the same project, you’ll need to add the Spire.Office.jar file as a dependency in your Java program. The JAR file can be downloaded from this link. If you use Maven, you can easily import the JAR file in your application by adding the following code to your project's pom.xml file.

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>

<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.office</artifactId>
        <version>8.3.6</version>
    </dependency>
</dependencies>

Extract Data from PDF Table in Java

Spire.PDF for java offers PdfTable.GetText() method to get all the text from the PDF table. Here comes to the steps of extracting data from the tables in PDF.

Create a PdfDocument instance and load a sample PDF file using PdfDocument.loadFromFile() method.
Create a StringBuilder and PdfTableExtractor object.
Loop through all the PDF pages and get all the tables in the PDF and store it to PdfTable[] array
Loop through all tables to get the table rows and columns, and the use PdfTable.GetText() method to obtain the text data in the table.
Write the extracted data to a txt document using Writer.write() method.

import com.spire.pdf.PdfDocument;
import com.spire.pdf.utilities.PdfTable;
import com.spire.pdf.utilities.PdfTableExtractor;

import java.io.FileWriter;

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

        //Load a sample PDF document
        PdfDocument pdf = new PdfDocument("Sample.pdf");

        //Create a StringBuilder instance
        StringBuilder builder = new StringBuilder();

        //Create a PdfTableExtractor object
        PdfTableExtractor extractor = new PdfTableExtractor(pdf);

        //Traverse every page of PDF
        for (int page = 0; page < pdf.getPages().getCount(); page++)
        {
            //Extract tables from the PDF page and store them in the PdfTable[] array
            PdfTable[] tableLists = extractor.extractTable(page);
            if (tableLists != null && tableLists.length > 0)
            {
                //Traverse every table
                for (PdfTable table : tableLists)
                {
                    //Get the table rows
                    int row = table.getRowCount();
                    //Get the table columns
                    int column = table.getColumnCount();
                    for (int i = 0; i < row; i++)
                    {
                        for (int j = 0; j < column; j++)
                        {
                            //Get the text from table
                            String text = table.getText(i, j);

                            //Write the obtained text into a StringBuilder container
                            builder.append(text+" ");
                        }
                        builder.append("\r\n");
                    }
                }
            }
        }

        //Write to txt
        FileWriter fileWriter = new FileWriter("ExtractedTable.txt");
        fileWriter.write(builder.toString());
        fileWriter.flush();
        fileWriter.close();
    }
}

Extract Table Data from PDF to Excel

The following are the main steps to extract all tables from a certain page and save each of them as an individual worksheet in an Excel document.

Create a PdfDocument instance and load a sample PDF file using PdfDocument.loadFromFile() method.
Create a PdfTableExtractor object, and call extactTable() method to extract all tables in the first page.
Create a Workbook instance.
Loop through the tables in the PdfTable[] array, and get the specific one by its index.
Add a worksheet to the workbook using Workbook.getWorksheets.add() method.
Loop through the cells in the PDF table, and get the value of a specific cell using PdfTable.getText() method. Then insert the value to the worksheet using Worksheet.get().setText() method.
Save the workbook to an Excel document using Workbook.saveToFile() method.

import com.spire.pdf.PdfDocument;
import com.spire.pdf.utilities.PdfTable;
import com.spire.pdf.utilities.PdfTableExtractor;
import com.spire.xls.ExcelVersion;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;

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

        //Load a sample PDF document
        PdfDocument pdf = new PdfDocument("Sample7.pdf");

        //Create a PdfTableExtractor instance
        PdfTableExtractor extractor = new PdfTableExtractor(pdf);
        //Extract the table from the first page of PDF
        PdfTable[] pdfTables  = extractor.extractTable(0);

        //Create a Workbook object and clear the default worksheets
        Workbook wb = new Workbook();
        wb.getWorksheets().clear();

        //If any tables are found
        if (pdfTables != null && pdfTables.length > 0) {

            //Loop through the tables
            for (int tableNum = 0; tableNum < pdfTables.length; tableNum++) {
                //Add a worksheet to workbook
                String sheetName = String.format("Table - %d", tableNum + 1);
                Worksheet sheet = wb.getWorksheets().add(sheetName);
                //Loop through the rows in the current table
                for (int rowNum = 0; rowNum < pdfTables[tableNum].getRowCount(); rowNum++) {
                    //Loop through the columns in the current table
                    for (int colNum = 0; colNum < pdfTables[tableNum].getColumnCount(); colNum++) {
                        //Extract data from the current table cell
                        String text = pdfTables[tableNum].getText(rowNum, colNum);
                        //Insert data into a specific cell
                        sheet.get(rowNum + 1, colNum + 1).setText(text);
                    }
                }
                //Auto fit column width
                for (int sheetColNum = 0; sheetColNum < sheet.getColumns().length; sheetColNum++) {
                    sheet.autoFitColumn(sheetColNum + 1);
                }
            }
        }
        //Save the workbook to an Excel file
        wb.saveToFile("ExportTableToExcel.xlsx", ExcelVersion.Version2016);
    }
}

Conclusion

In this article, we have demonstrated how to extract text from table in PDF pages using Java. With Spire.PDF for Java, we could also extract all the texts and images from PDF file for different scenarios. You can check the PDF forum for more features to operate the PDF files.

Java – How to Add Stamps to a PDF Document

Alexis — Fri, 14 Apr 2023 08:03:48 +0000

A PDF Stamp is a PDF annotation that acts like a rubber stamp on paper. Like a rubber stamp, a PDF stamp has a custom graphic that is created from text or an image. Usually, it will be something that will effectively communicate your intent. In this article, you will learn how to stamp a PDF document with an image or dynamic text in Java using Spire.PDF for Java.

Add an Image Stamp to PDF in Java
Add a Custom Dynamic Stamp to PDF in Java

Add Spire.Pdf.jar as dependency

If you are working on a maven project, you can include the dependency in pom.xml file using this:

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.pdf</artifactId>
        <version>9.3.11</version>
    </dependency>
</dependencies>

If you are not using maven, then you can find the required jar files from the zip file available in this location. Include all the jar files into the application lib folder to run the sample code given in this tutorial.

Prerequisite Knowledge

To help you better understand the code examples provided in this tutorial, I have listed below some of the core classes, methods, and properties.

The PdfTemplate class represents a piece of canvas, on which you can draw whatever information you want, such as text, images, date, and time. The PdfRubberStampAnnotation class represents a rubber stamp annotation that displays text or graphics on a PDF page with a rubber stamp. The PdfTemplate here is used to create the appearance of a rubber stamp.

Add an Image Stamp to PDF in Java

An image stamp is a stamp created based on an existing image. The following are the steps to add an image stamp to a PDF document using Free Spire.PDF for Java.

Create a PdfDocument object.
Load a PDF file using PdfDocument.loadFromFile() method.
Get a specific page using PdfDocument.getPages().get() method.
Create a PdfTemplate object, which is used to create the appearance of stamp.
Load an image using PdfImage.fromImage() method.
Draw the image on the template using PdfTemplate.getGraphics().drawImage() method.
Create a PdfRubberStampAnnotation object, and apply the template to the stamp as the appearance.
Add the stamp to the selected page using PdfPageBase.getAnnotationsWidget().add() method.
Save the document to a PDF file using PdfDocument.saveToFile() method.

import com.spire.pdf.PdfDocument;
import com.spire.pdf.PdfPageBase;
import com.spire.pdf.annotations.PdfRubberStampAnnotation;
import com.spire.pdf.annotations.appearance.PdfAppearance;
import com.spire.pdf.graphics.PdfImage;
import com.spire.pdf.graphics.PdfTemplate;

import java.awt.geom.Rectangle2D;

public class ImageStamp {

    public static void main(String[] args) {

        //Create a PdfDocument object
        PdfDocument doc = new PdfDocument();

        //Load a PDF document
        doc.loadFromFile("C:\\Users\\Administrator\\Desktop\\sample.pdf");

        //Get the last page
        PdfPageBase page = doc.getPages().get(doc.getPages().getCount() - 1);

        //Load an image file
        PdfImage image = PdfImage.fromFile("C:\\Users\\Administrator\\Desktop\\paid.png");

        //Get the width and height of the image
        int width = image.getWidth();
        int height = image.getHeight();

        //Create a PdfTemplate object based on the size of the image
        PdfTemplate template = new PdfTemplate(width, height);

        //Draw image on the template
        template.getGraphics().drawImage(image, 0, 0, width, height);

        //Create a rubber stamp annotation, specifying its location and position
        Rectangle2D rect = new Rectangle2D.Float((float) (page.getActualSize().getWidth() - width - 20), (float) (page.getActualSize().getHeight() - height - 200), width, height);
        PdfRubberStampAnnotation stamp = new PdfRubberStampAnnotation(rect);

        //Create a PdfAppearance object
        PdfAppearance pdfAppearance = new PdfAppearance(stamp);

        //Set the template as the normal state of the appearance
        pdfAppearance.setNormal(template);

        //Apply the appearance to the stamp
        stamp.setAppearance(pdfAppearance);

        //Add the stamp annotation to PDF
        page.getAnnotationsWidget().add(stamp);

        //Save the file
        doc.saveToFile("AddImageStamp.pdf");
        doc.close();
    }
}

Add a Custom Dynamic Stamp to PDF in Java

A dynamic stamp takes information from your computer and identity panel, allowing you to include the user name, date and time information on the stamp. The following are the steps to add a dynamic stamp to a PDF document using Free Spire.PDF for Java.

Create a PdfDocument object.
Load a PDF file using PdfDocument.loadFromFile() method.
Get a specific page using PdfDocument.getPages().get() method.
Create a PdfTemplate object, which is used to create the appearance of stamp.
Draw a rounded rectangle on the template using PdfTemplate.getGraphics().drawPath() method.
Draw strings on the template using PdfTemplate.getGraphics().drawString() method.
Create a PdfRubberStampAnnotation object, and apply the template to the stamp as the appearance.
Add the stamp to the selected page using PdfPageBase.getAnnotationsWidget().add() method.
Save the document to a PDF file using PdfDocument.saveToFile() method.

import com.spire.pdf.PdfDocument;
import com.spire.pdf.PdfPageBase;
import com.spire.pdf.annotations.PdfRubberStampAnnotation;
import com.spire.pdf.annotations.appearance.PdfAppearance;
import com.spire.pdf.graphics.*;

import java.awt.*;
import java.awt.geom.Point2D;
import java.awt.geom.Rectangle2D;
import java.text.SimpleDateFormat;
import java.util.Map;

public class AddDynamicStamp {

    public static void main(String[] args) {

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

        //Load a PDF file
        document.loadFromFile("C:\\Users\\Administrator\\Desktop\\sample.pdf");

        //Get the last page
        PdfPageBase page = document.getPages().get(document.getPages().getCount() - 1);

        //Create a pdf template
        PdfTemplate template = new PdfTemplate(220, 50);

        //Create two fonts
        PdfTrueTypeFont font1 = new PdfTrueTypeFont(new Font("Elephant", Font.ITALIC, 16), true);
        PdfTrueTypeFont font2 = new PdfTrueTypeFont(new Font("Times New Roman", Font.ITALIC, 12), true);

        //Create a solid brush and a gradient brush
        PdfSolidBrush solidBrush = new PdfSolidBrush(new PdfRGBColor(Color.blue));
        Rectangle2D rect1 = new Rectangle2D.Float();
        rect1.setFrame(new Point2D.Float(0, 0), template.getSize());
        PdfLinearGradientBrush linearGradientBrush = new PdfLinearGradientBrush(rect1, new PdfRGBColor(Color.white), new PdfRGBColor(113,191,234), PdfLinearGradientMode.Horizontal);

        //Create a rounded rectangle path
        int CornerRadius = 10;
        PdfPath path = new PdfPath();
        path.addArc(template.getBounds().getX(), template.getBounds().getY(), CornerRadius, CornerRadius, 180, 90);
        path.addArc(template.getBounds().getX() + template.getWidth() - CornerRadius, template.getBounds().getY(), CornerRadius, CornerRadius, 270, 90);
        path.addArc(template.getBounds().getX() + template.getWidth() - CornerRadius, template.getBounds().getY() + template.getHeight() - CornerRadius, CornerRadius, CornerRadius, 0, 90);
        path.addArc(template.getBounds().getX(), template.getBounds().getY() + template.getHeight() - CornerRadius, CornerRadius, CornerRadius, 90, 90);
        path.addLine(template.getBounds().getX(), template.getBounds().getY() + template.getHeight() - CornerRadius, template.getBounds().getX(), template.getBounds().getY() + CornerRadius / 2);

        //Draw path on the template
        template.getGraphics().drawPath(linearGradientBrush, path);
        template.getGraphics().drawPath(PdfPens.getBlue(), path);

        //Draw dynamic text on the template
        String s1 = "APPROVED\n";
        Map<String, String> map = System.getenv();
        String userName = map.get("USERNAME");
        String s2 = "By " + userName + " at ";
        String s3 = dateToString(new java.util.Date(), "yyyy-MM-dd HH:mm:ss");
        template.getGraphics().drawString(s1, font1, solidBrush, new Point2D.Float(5, 5));
        template.getGraphics().drawString(s2 + s3, font2, solidBrush, new Point2D.Float(5, 28));

        //Create a rubber stamp, specifying its size and location
        Rectangle2D rect2 = new Rectangle2D.Float();
        rect2.setFrame(new Point2D.Float((float) (page.getActualSize().getWidth() - template.getWidth() - 35), (float) (page.getActualSize().getHeight() - template.getHeight() - 220)), template.getSize());
        PdfRubberStampAnnotation stamp = new PdfRubberStampAnnotation(rect2);

        //Create a PdfAppearance object and apply the template as its normal state
        PdfAppearance appearance = new PdfAppearance(stamp);
        appearance.setNormal(template);

        //Apply the appearance to stamp
        stamp.setAppearance(appearance);

        //Add the stamp annotation to annotation collection
        page.getAnnotationsWidget().add(stamp);

        //Save the file
        document.saveToFile("AddDynamicStamp.pdf");
        document.close();
    }
    //Convert date to string
    public static String dateToString(java.util.Date poDate, String pcFormat) {
        SimpleDateFormat loFormat = new SimpleDateFormat(pcFormat);
        return loFormat.format(poDate);
    }
}

Java Combine Multiple Word Documents into One Single Word

Alexis — Mon, 10 Apr 2023 09:33:56 +0000

When creating reports or presentations, it can be beneficial to consolidate data from various sources into a single document. In order to produce a more comprehensive and lengthy document, it may be necessary to merge data from multiple separate Word documents into one cohesive file. In this article, you will learn how to combine two Word documents into one single Word document by using Spire.Doc for Java from the following three parts:

Combine Two Word Document Files into one single Word
Merge Word Documents by Cloning Contents
Merge Word Documents with Additional Options

Install Spire.Doc for Java

First of all, you're required to add the Spire.Doc.jar file as a dependency in your Java program. The JAR file can be downloaded from this link. If you use Maven, you can easily import the JAR file in your application by adding the following code to your project's pom.xml file.

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.doc</artifactId>
        <version>11.3.11</version>
    </dependency>
</dependencies>

Combine Documents by Inserting the Entire File

Spire.Doc for Java offers Document.insertTextFromFile() method to insert the entire contents of other documents into the desired document on a new page. The detailed steps of merging documents by inserting the entire file are as follows:

Create an object of Document class and load a Word document from disk.
Insert another Word document entirely to the loaded document using Document.insertTextFromFile() method.
Save the result document using Document.saveToFile() method.

import com.spire.doc.*;

public class merge {
    public static void main(String[] args) throws Exception {
        //Load the Word document
        Document doc = new Document();
        doc.loadFromFile("Sample1.docx");

        //Insert another Word document entirely to the document
        doc.insertTextFromFile( "Sample2.docx", FileFormat.Auto);

        //Save the document
        String output = "simpleInsertFile_out.docx";
        doc.saveToFile(output, FileFormat.Docx_2010);
        }
    }

Merge Documents by Cloning Contents

In order to combine documents while maintaining the same style and without starting a new page, you can clone the contents of other documents and append them to the end of a document. The detailed steps of merging documents by cloning contents are as follows:

Create two objects of Document and load the two Word documents from disk.
Loop through the second document to get all the sections using Document.getSections() method, then loop through all the sections to get their child objects using Section.getBod().getChildObjects() method.
Get the last section of the first document using Document.getLastSection() method, and then add the child objects to the last section of the first document using Body.getChildObjects().add() method.
Save the result document using Document.saveToFile() method.

import com.spire.doc.*;

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

        //Create two Document objects and load two Word documents from disk
        Document document1 = new Document();
        document1 .loadFromFile("Sample1.docx");
        Document document2 = new Document();
        document2.loadFromFile("Sample2.docx");

        //Loop through the second document to get all the sections
        for (Object sectionObj : (Iterable) document2.getSections()) {
            Section sec=(Section)sectionObj;
            //Loop through the sections of the second document to get their child objects
            for (Object docObj :(Iterable ) sec.getBody().getChildObjects()) {
                DocumentObject obj=(DocumentObject)docObj;

                //Get the last section of the first document
                Section lastSection = document1.getLastSection();

                //Add the child objects to the last section of the first document
                Body body = lastSection.getBody();
                body.getChildObjects().add(obj.deepClone());
            }
        }

        //Save the result document
        document1.saveToFile("MergingResult.docx", FileFormat.Docx_2013);
    }
}

Keep the original format

When content is inserted or appended from another document, use Document.setKeepSameFormat(true) method to maintain the same formatting as the original document. Here comes to the steps.

Create two objects of Document and load the two Word documents from disk.
Keep the same format for the source document by setting document1.setKeepSameFormat(true).
Copy the sections of source document to destination document.
Save the result document using Document.saveToFile() method.

import com.spire.doc.*;

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

        //Initialize a new object of Document class and load the source document.
        Document document1 = new Document();
        document1.loadFromFile("Test.docx");

        //Initialize another object to load target document.
        Document document2 = new Document();
        document2.loadFromFile("Template_Docx_1.docx");

        //Keep same format of source document
        document1.setKeepSameFormat(true);

        //Copy the sections of source document to destination document
        for (Object sectionObj : document1.getSections()) {
            Section section=(Section)sectionObj;
            document2.getSections().add(section.deepClone());
        }

        //Save the result document
        document2.saveToFile("MergingResult2.docx", FileFormat.Docx_2013);
    }
}

Conclusion

In this blog, we have demonstrated how to combine two Word documents into one single Word document using Java and Spire.Doc for java library. By following the steps outlined here, you can easily merge multiple Word documents and customize your final output. This technique can be useful for creating reports, generating reconciliations, or any other task that requires combining multiple sources of information into a single document. In addition to this, you can also use Spire.Doc for Java to split word documents into separate word document. In case you would have any queries, you can get help from Spire.Doc forums.

Java - How to Add a Background Color, Picture or Texture to Word Documents

Alexis — Fri, 07 Apr 2023 02:47:03 +0000

The background of a Word document plays a significant role in determining the style and character of the document. We all know that Word’s default page background is white. In order to make the document more stylish and eye-catching, you can set up a colored background, an image background, or a textured background for it. In this article, I am going to introduce how to programmatically change the background of a Word document using Free Spire.Doc for Java.

Add a Solid Color to Document Background in Java
Add a Gradient Color to Document Background in Java
Add a Picture to Document Background in Java
Add Texture to Document Background in Java

Add Spire.Doc.jar as Dependency

If you are working on a maven project, you can include the dependency in pom.xml file using this:

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.doc.free</artifactId>
        <version>5.2.0</version>
    </dependency>
</dependencies>

Add a Solid Color to Document Background in Java

The steps to apply a solid color to the background of a Word document are as follows.

Create a Document object.
Load a Word file using Document.loadFromFile() method.
Set the background type to Color using Document.getBackground().setType() method.
Set the background color using Document.getBackground().setColor() method.
Save the document using Document.saveToFile() method.

import com.spire.doc.Document;
import com.spire.doc.FileFormat;
import com.spire.doc.documents.BackgroundType;

import java.awt.*;

public class AddColorToBackground {

    public static void main(String[] args) {

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

        //Load a Word document
        document.loadFromFile("C:\\Users\\Administrator\\Desktop\\Report.docx");

        //Set the background type to color
        document.getBackground().setType(BackgroundType.Color);

        //Set the background color to light blue
        document.getBackground().setColor(new Color(173,216,230));

        //Save the document
        document.saveToFile("output/BackgroundColor.docx", FileFormat.Docx);
    }
}

Add a Gradient Color to Document Background in Java

The steps to apply a gradient color to the background of a Word document are as follows.

Create a Document object.
Load a Word file using Document.loadFromFile() method.
Set the background type to Gradient using Document.getBackground().setType() method.
Set two colors for the gradient using BackgroundGradient.setColor1() and BackgroundGradient.setColor2() methods.
Set the gradient variant to Shading_Down using BackgroundGradient.setShadingVariant() method.
Set the shading style to Vertical using BackgroundGradient.setShadingStyle() method.
Save the document using Document.saveToFile() method.

import com.spire.doc.BackgroundGradient;
import com.spire.doc.Document;
import com.spire.doc.FileFormat;
import com.spire.doc.documents.BackgroundType;
import com.spire.doc.documents.GradientShadingStyle;
import com.spire.doc.documents.GradientShadingVariant;

import java.awt.*;

public class AddGradientColorToBackground {

    public static void main(String[] args) {

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

        //Load a Word document
        document.loadFromFile("C:\\Users\\Administrator\\Desktop\\Report.docx");

        //Set the background type to gradient
        document.getBackground().setType(BackgroundType.Gradient);

        //Set two colors for gradient
        BackgroundGradient gradient = document.getBackground().getGradient();
        gradient.setColor1(Color.white);
        gradient.setColor2(new Color(173,216,230));

        //Set gradient variant to shading down
        gradient.setShadingVariant(GradientShadingVariant.Shading_Down);

        //Set gradient style to vertical
        gradient.setShadingStyle(GradientShadingStyle.Vertical);

        //Save the document
        document.saveToFile("output/BackgroundGradient.docx", FileFormat.Docx);
    }
}

Add a Picture to Document Background in Java

The following are the steps to add a picture to the background of a Word document.

Create a Document object.
Load a Word file using Document.loadFromFile() method.
Set the background type to Picture using Document.getBackground().setType() method.
Set the background picture using Document.getBackground().setPicture() method.
Save the document using Document.saveToFile() method.

import com.spire.doc.Document;
import com.spire.doc.FileFormat;
import com.spire.doc.documents.BackgroundType;

public class AddPictureToBackground {

    public static void main(String[] args) {

        //Create an object of Document class
        Document document= new Document();

        //Load a Word document
        document.loadFromFile("C:\\Users\\Administrator\\Desktop\\Report.docx");

        //Set the background type to picture
        document.getBackground().setType(BackgroundType.Picture);

        //Set the background picture
        document.getBackground().setPicture("C:\\Users\\Administrator\\Desktop\\background.jpg");

        //Save the document
        document.saveToFile("output/BackgroundPicture.docx", FileFormat.Docx);
    }
}

Add Texture to Document Background in Java

Texture is the feel or shape of a surface or substance, and the texture background is essentially an image added to the background. The following are the steps to add texture to the background of a Word document.

Create a Document object.
Load a Word file using Document.loadFromFile() method.
Set the background type to Texture using Document.getBackground().setType() method.
Set the background picture using Document.getBackground().setPicture() method.
Save the document using Document.saveToFile() method.

import com.spire.doc.Document;
import com.spire.doc.FileFormat;
import com.spire.doc.documents.BackgroundType;

public class AddTextureToBackground {

    public static void main(String[] args) {

        //Create an object of Document class
        Document document= new Document();

        //Load a Word document
        document.loadFromFile("C:\\Users\\Administrator\\Desktop\\Report.docx");

        //Set the background type to texture
        document.getBackground().setType(BackgroundType.Texture);

        //Set the texture picture
        document.getBackground().setPicture("C:\\Users\\Administrator\\Desktop\\texture.jpg");

        //Save the document
        document.saveToFile("output/BackgroundTexture.docx", FileFormat.Docx);
    }
}

Conclusion

It’s quite easy to add a background color or image to a Word document using Free Spire.Doc for Java. In addition to that, this library offers many easy-to-use interfaces that can help handle complex tasks in Word documents with no effort.

Java convert Excel to HTML

Alexis — Tue, 28 Mar 2023 03:44:25 +0000

Excel spreadsheets serve as a useful tool for organizing, managing, and computing data, while HTML plays a similar role in presenting content through web browsers. In some situation, you may need to save Excel to HTML conversion to convert worksheets to HTML pages. For example, when embedding the content of the spreadsheets into web pages. As HTML pages can be easily shared and accessed through web browsers and HTML page can also be interactive, allowing users to input or manipulate data directly on the webpage, which can be useful for collaborative projects or online surveys. This article will show you how to convert Excel XLSX files to HTML programmatically using Java from the following three parts.

Convert Excel to HTML
Convert Excel to a standalone HTML file
Convert Excel to HTML stream

Install Spire.XLS for Java

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls</artifactId>
        <version>13.3.6</version>
    </dependency>
</dependencies>

Convert Excel to HTML

Spire.XLS for Java offers workbook.saveToFile() method to convert Excel workbook to HTML easily. Here comes to steps of convert XLSX to HTML.

Create a Workbook instance.
Load an Excel file using Workbook.loadFromFile() method.
Save the file to HTML using Workbook.saveToFile() method.

import com.spire.xls.*;

public class ExceltoHTML {
    public static void main(String[] args) throws Exception {
        //Load an Excel file
        Workbook wb = new Workbook();
        wb.loadFromFile("Sample.xlsx");

//Save the file to HTML
        wb.saveToFile("WorkbookToHtml.html",FileFormat.HTML);
    }
}

Convert Excel to a standalone HTML file

Spire.XLS for Java offers HTMLOptions instance to embed the image or convert Excel to a standalone HTML file. The following steps show how to save Excel worksheet as HTML file.

Create a Workbook instance and load an Excel file using Workbook.loadFromFile() method.
Get the first worksheet using Workbook.getWorksheets().get() method.
Create a HTMLOptions instance.
Enable image embedding using HTMLOptions.setImageEmbedded() method.
Set the HTML as a standalone HTML file using HTMLOptions.isStandAloneHtmlFile() method.
Save the worksheet to HTML with image embedded using Worksheet.saveToHtml(String, HTMLOptions) method.

import com.spire.xls.*;
import com.spire.xls.core.spreadsheet.HTMLOptions;

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

                //Load the sample document
                Workbook wb = new Workbook();
                wb.loadFromFile("Sample.xlsx");

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

                 //Initiate a HTMLOptions instance
                 HTMLOptions options = new HTMLOptions();

                 //Set embedded image as true
                 options.setImageEmbedded(true);

                 //Set is StandaloneHTML file as true
                 options.isStandAloneHtmlFile(true);

                 //Save the worksheet to HTML
                 sheet.saveToHtml("Result2.html", options);
            }
        }

Convert Excel to HTML stream

Spire.XLS for Java offers Workbook.saveToStream() method to save the Excel to HTML stream. The files can be saved directly to memory without having to save them to disk. When working with large numbers of files, it is very useful and these files can be easily sent to the network, to memory or to other devices.

Create a Workbook instance and load an Excel file using Workbook.loadFromFile() method.
Create a new FileOutputStream object named "fileStream" and specifies the file name "SaveStream.html" where the output will be saved.
Calls the Workbook.saveToStream() method to save the content in HTML format to the file stream.

import com.spire.xls.*;
import java.io.FileOutputStream;

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

                //Load the sample document
                Workbook wb = new Workbook();
                wb.loadFromFile("Sample.xlsx");

                FileOutputStream fileStream = new FileOutputStream("SaveStream.html");
                wb.saveToStream(fileStream, FileFormat.HTML);
                fileStream.close();
    }
}

In this article, you have learned how to convert an Excel file to HTML using Java. The code snippet provided demonstrates the use of Spire.XLS for Java to convert the Excel file to HTML format. Additionally, the article explores various options available to customize the conversion output, such as embedding images in the HTML file or saving them as standalone HTML files. By leveraging the flexibility of Spire.XLS, you can easily control the conversion process and tailor the output to your specific needs. Whether you require a simple conversion or a more complex one with advanced settings like page orientation, header and footer, or CSS styles, Spire.XLS makes it effortless. In conclusion, you have seen how Spire.XLS for Java provides an efficient solution to convert Excel files to HTML format. If you want to learn more about Excel file processing, you can explore further resources from Excel forums where you can find answers to common questions, share best practices, and connect with other developers.

Java: Rotate PDF Pages

Alexis — Sun, 29 Jan 2023 07:06:41 +0000

PDF is a widely used format for sharing and printing documents. It’s common that large PDF files contain pages that are rotated at an undesirable angle, especially those converted from formats like JPG, PNG, and scanned PDF. This article will introduce how to rotate PDF pages from the following three parts with the help of Spire.PDF for Java.

Rotating a specific PDF page
Rotating Image in a PDF document
Rotating text in a PDF document

Install Spire.PDF for Java

First of all, you need to add the Spire.PDF.jar file as a dependency in your Java program. The JAR file can be downloaded from this link. If you use Maven, you can easily import the JAR file by adding the following code to your project's pom.xml file.

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.pdf</artifactId>
        <version>9.1.4</version>
    </dependency>
</dependencies>

Rotating an existing PDF page in Java:

Rotation is based on 90-degree increments. You can rotate a PDF page by 0/90/180/270 degrees. You can rotate a particular PDF page in the PDF document using PdfPageRotateAngle Enum as shown below:

Create an instance of PdfDocument class.
Load a PDF document using PdfDocument.loadFromFile() method.
Get the desired page by its index (zero-based) using PdfDocument.getPages().get(pageIndex) method.
Get the original rotation angle of the page using PdfPageBase.getRotation().getValue() method.
Increase the original rotation angle by desired degrees.
Apply the new rotation angle to the page using PdfPageBase.setRotation() method.
Save the result document using PdfDocument.saveToFile() method.

import com.spire.pdf.*;

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

        //Create a PdfDocument instance
        PdfDocument pdf = new PdfDocument();
        //Load a PDF document
        pdf.loadFromFile("Sample.pdf");

        //Get the first page
        PdfPageBase page = pdf.getPages().get(0);

        //Get the original rotation angle of the page
        int rotation = page.getRotation().getValue();

        //Rotate the page 180 degrees clockwise based on the original rotation angle
        rotation += PdfPageRotateAngle.Rotate_Angle_180.getValue();
        page.setRotation(PdfPageRotateAngle.fromValue(rotation));

        //Save the result document
        pdf.saveToFile("RotatePage.pdf");
    }
}

Rotating an Image in a PDF document

You might also want to add image to a PDF document by rotating it to make the PDF vivid. Here you will learn how to rotate an Image in a PDF document using Java.

Create an instance of PdfDocument class.
Add a section and page to the PDF.
Load the image from disk using PdfImage.fromFile() method and get its width and height.
Set the rotation for the image by page.getCanvas().rotateTransform(45) method.
Draw the image to the PDF page by using page.getCanvas().drawImage() method.
Save the result document using PdfDocument.saveToFile() method.

import com.spire.pdf.*;
import com.spire.pdf.graphics.*;

public class rotateImage {
    public static void main(String[] args) {
        //Create a pdf document
        PdfDocument doc = new PdfDocument();

        //Create a PdfDocument instance
        PdfDocument pdf = new PdfDocument();
        //Add a section
        PdfSection section = pdf.getSections().add();
        //Add a new page 
        PdfPageBase page = section.getPages().add();

        //Load the image
        PdfImage image = PdfImage.fromFile("Icon.jpg");
        //Get the image's width and height
        double imageWidth = image.getPhysicalDimension().getWidth();
        double imageHeight = image.getPhysicalDimension().getHeight();

        //Set the rotation for the image
        page.getCanvas().rotateTransform(45);

        //Draw image to the page
        page.getCanvas().drawImage(image, 100, 10, imageWidth, imageHeight);
        page.getCanvas().save();

        //Save the result document
        pdf.saveToFile("RotateImage.pdf");
        pdf.close();
    }

Rotating Text on PDF Pages in Java

Adding text with a rotation angle can be an important requirement in particular scenarios of text generation in PDF. In order to add text with rotation in PDF document, you can use the section.getPageSettings().setRotate() method to specify the rotation angle of the text when you add text to the PDF.

Create an instance of PdfDocument class.
Add a section to the PDF.
Rotate the section by using section.getPageSettings().setRotate() method.
Add a new page to the PDF section using section.getPages().add() method.
Draw text to the PDF page using page.getCanvas().drawString() method and set the font and format for the text.
Save the result document using PdfDocument.saveToFile() method.

import com.spire.pdf.*;
import com.spire.pdf.graphics.*;
import java.awt.*;

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

        //Create a pdf document
        PdfDocument doc = new PdfDocument();

        //Create PdfSection
        PdfSection section = doc.getSections().add();

        //Set rotating angle        
        section.getPageSettings().setRotate(PdfPageRotateAngle.Rotate_Angle_90);

        //Add the page
        PdfPageBase page = section.getPages().add();

        //Define a PdfBrush
        PdfBrush brush = PdfBrushes.getBlack();

        //Define a font
        PdfTrueTypeFont font = new PdfTrueTypeFont(new Font("Arial", Font.PLAIN, 13), true);

        //Set the position for drawing
        float x = 0;
        float y = 50;

        //Text string
        String text = "Rotate page when creating a PDF document.";

        //Draw text string on page canvas
        page.getCanvas().drawString(text, font, brush, x, y);

        String result = "rotateNewPDF.pdf";

        //Save the document
        doc.saveToFile(result);
        doc.close();
    }
}

Conclusion:

You have learned how to rotate PDF pages, text, and images programmatically in Java when generating a new PDF file or updating the existing PDF document. You can check the PDF forum for more features to operate the PDF files.

Java Insert or Delete Rows and Columns in Excel Worksheet

Alexis — Wed, 18 Jan 2023 06:46:48 +0000

With the help of Spire.XLS for Java, we can easily insert or delete the rows or columns in the Excel worksheets programmatically. In this article, we will demonstrate how to insert or delete rows or columns in Excel in Java applications from the following parts.

Insert Rows in Excel worksheet in Java
Insert Columns in Excel worksheet in Java
Delete Rows and Columns in Excel worksheet
Delete Blank Rows and Columns in Excel worksheet

Insert Rows in Excel worksheet in Java

Spire.XLS offers Worksheet.insertRow() method to insert rows in an Excel worksheet. Here are the steps to insert rows in Excel worksheet.

Create a Workbook instance and load a sample Excel document using Workbook.loadFromFile() method.
Get a specified worksheet using Workbook.getWorksheets().get() method.
Insert a row using Worksheet.insertRow(int rowIndex)method.
Insert multiple rows using Worksheet.insertRow(int rowIndex, rowCount) method.
Save the document to file using Workbook.saveToFile() method.

import com.spire.xls.*;


public class insertRows {
    public static void main(String[] args) {
        //Create a workbook and load an Excel file from disk.
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Sample.xlsx");

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

        //Insert a row into the worksheet.
        worksheet.insertRow(2);

        //Insert multiple rows into the worksheet.
        worksheet.insertRow(5, 2);

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

Insert Columns in Excel Sheets in Java

Spire.XLS offers Worksheet.insertColumn() method to insert columns in an Excel worksheet. Here are the steps to insert columns in a worksheet in Java.

Create a Workbook instance and load a sample Excel document using Workbook.loadFromFile() method.
Get a specified worksheet using Workbook.getWorksheets().get() method.
Insert a column using Worksheet.insertColumn(int columnIndex) method.
Insert multiple columns using Worksheet.insertColumn (int columnIndex, columnCount)method.
Save the document to file using Workbook.saveToFile() method.

import com.spire.xls.*;


public class insertColumn {
    public static void main(String[] args) {
        //Create a workbook and load an Excel file from disk.
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Sample.xlsx");

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

        //Insert a column into the worksheet.
        worksheet.insertColumn(2);

        //Insert multiple columns into the worksheet.
        worksheet.insertColumn(5, 2);

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

Delete Rows and Columns in Excel worksheet

The steps of adding the columns to an Excel sheet is similar to addition of the rows. So does the steps of the deletion of rows and columns. Here are the steps to delete rows and columns from an Excel worksheet in Java.

Create a Workbook instance and load a sample Excel document using Workbook.loadFromFile() method.
Get a specified worksheet using Workbook.getWorksheets().get() method.
Delete a row using Worksheet.deleteRow(index) method.
Delete multiple columns using Worksheet.deleteColumn(index, count) method.
Save the document to file using Workbook.saveToFile() method.

import com.spire.xls.*;


public class deleteRowsColumns {
    public static void main(String[] args) {
        //Create a workbook and load an Excel file from disk.
        Workbook workbook = new Workbook();
        workbook.loadFromFile("InsertColumns.xlsx");

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

        //Delete the third row 
        worksheet.deleteRow(3);

        //Delete 2 columns from the fifth column.
        worksheet.deleteColumn(5, 2);

        //Save the document to file
        workbook.saveToFile("output/DeleteRowsColumns.xlsx", ExcelVersion.Version2013);
    }
}

Delete Blank Rows and Columns from worksheet:

As a programmer, you may come across scenarios when you have to remove all the blank rows and columns in Excel worksheet. Spire.XLS for Java also supports to delete all the blank rows and columns.

Create a Workbook instance and load a sample Excel document using Workbook.loadFromFile() method.
Get a specified worksheet using Workbook.getWorksheets().get() method.
Traverse all the rows and use worksheet.getRows().isBlank() to check if the row is Blank.
If yes, delete the blank row using Worksheet.deleteRow()method.
Use worksheet.getColumns().isBlank() to check if the column is blank.
If yes, delete the blank columns using Worksheet.deleteColumn() method.
Save the document to file using Workbook.saveToFile() method.

import com.spire.xls.*;


public class deleteBlankRowsColumns {
    public static void main(String[] args) {
        //Create a workbook and load an Excel file from disk.
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Result.xlsx");

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


        //Delete blank rows from the worksheet.
        for (int i = worksheet.getRows().length - 1; i >= 0; i--) {
            if (worksheet.getRows()[i].isBlank()) {
                worksheet.deleteRow(i + 1);
            }
        }

        //Delete blank columns from the worksheet.
        for (int j = worksheet.getColumns().length - 1; j >= 0; j--) {
            if (worksheet.getColumns()[j].isBlank()) {
                worksheet.deleteColumn(j + 1);
            }
        }

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

Conclusion

In this article, you have learned how to manipulate rows and columns in Excel programmatically. You have seen how to delete blank rows and columns in Excel worksheets using Java. Spire.XLS for Java is a popular Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets without using Microsoft Excel. You can get more features from the Excel forum.

Java – How to Convert PDF to Excel with Formatting

Alexis — Fri, 06 Jan 2023 09:08:17 +0000

There are many reasons for converting PDF to Excel. Probably the most important reason is that you can easily manipulate and analyze data in PDFs by using the data calculation, visualization and analysis tools provided by Microsoft Excel. For example, you can use formulas on the data, create charts based on the data, apply conditional formatting to the data, and many more. In this article, I will explain how to programmatically convert PDF to Excel with Formatting in Java.

Convert PDF to Excel with Formatting in Java
Convert a Multi-Page PDF to a Single Excel Worksheet in Java

Add Dependencies

In order to convert PDF to Excel, this article uses a third-party API named Spire.PDF for Java. Before coding, you need to add needed dependencies for including Spire.PDF for Java into your Java project. There are two ways to do that.

Method 1: If you are using maven, you can easily import the JAR file of Spire.PDF for Java into your application by adding the following code to your project’s pom.xml file.

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.pdf</artifactId>
        <version>8.12.6</version>
    </dependency>
</dependencies>

Method 2: If you are not using maven, you can download the latest version of Spire.PDF for Java from this link, extract the zip file and then import the Spire.Pdf.jar file under the lib folder into your project as a dependency.

Convert PDF to Excel with Formatting in Java

The PdfDocument.saveToFile(String, FileFormat) method in Spire.PDF for Java is used to convert a PDF document to other file formats. You can use this method to easily convert a PDF to Excel with formatting by specifying the FileFormat as XLSX.

The following are the detailed steps:

Initialize an instance of the PdfDocument class.
Load a PDF document using PdfDocument.loadFromFile() method.
Save the PDF document to Excel XLSX format using PdfDocument.saveToFile(String, FileFormat) method.

import com.spire.pdf.FileFormat;
import com.spire.pdf.PdfDocument;

public class ConvertPdfToExcel {
    public static void main(String[] args) {
        //Initialize an instance of the PdfDocument class
        PdfDocument pdf = new PdfDocument();
        //Load a PDF document
        pdf.loadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.pdf");

        //Save the PDF document to XLSX format
        pdf.saveToFile("PdfToExcel.xlsx", FileFormat.XLSX);

    }
}

Convert a Multi-Page PDF to a Single Excel Worksheet in Java

If your PDF document has multiple pages and you want to convert it to a single Excel worksheet, you can use the PdfDocument.getConvertOptions().setPdfToXlsxOptions() method to set the PDF to XLSX conversion options, and then call the PdfDocument.saveToFile(String, FileFormat) method to convert the PDF to XLSX format with the specified options you have set.

The following are the detailed steps:

Initialize an instance of the PdfDocument class.
Load a PDF document using PdfDocument.loadFromFile() method.
Set the PDF to XLSX conversion options using the PdfDocument.getConvertOptions().setPdfToXlsxOptions() method.
Save the PDF document to Excel XLSX format using the PdfDocument.saveToFile(String, FileFormat) method.

import com.spire.pdf.FileFormat;
import com.spire.pdf.PdfDocument;
import com.spire.pdf.conversion.XlsxLineLayoutOptions;

public class ConvertMultiPagePdfToSingleExcelWorksheet {
    public static void main(String[] args) throws Exception {
        // Initialize an instance of the PdfDocument class
        PdfDocument pdf = new PdfDocument();
        //Load a PDF document
        pdf.loadFromFile("C:\\Users\\Administrator\\Desktop\\Members.pdf");

        //Set the PDF to XLSX conversion options: rendering multiple pages on a single worksheet
        pdf.getConvertOptions().setPdfToXlsxOptions(new XlsxLineLayoutOptions(false,true,true));

        //Save the PDF document to XLSX format
        pdf.saveToFile("PdfToOneSheet.xlsx", FileFormat.XLSX);
    }
}

Conclusion

This article demonstrates how to convert a PDF to Excel as well as how to convert a multi-page PDF to a single-sheet Excel in Java using Spire.PDF for Java API. Apart from the PDF to Excel conversion, you can also use the API to convert PDFs to a variety of other file formats such as DOCX, HTML and PPTX by specifying the FileFormat as DOCX, HTML and PPTX.

Java – How to Read Barcode from Word, Excel, PowerPoint and PDF

Alexis — Wed, 04 Jan 2023 02:36:05 +0000

A barcode, consisting of bars and spaces (or dots), is a machine-readable representation of numerals and characters. Today, barcodes have been widely used in grocery stores, doctor offices, law firms, post offices, retail stores and countless others. Being able to read Code39, Code128, PDF417, DataMatrix, QR, and other barcodes from various kinds of documents (like Word, Excel, PowerPoint and PDF) can be a real benefit.

In this article, I am going to introduce how to read barcodes from MS Office documents and PDFs in Java using Spire.Office for Java. More than 40+ commonly seen 1D or 2D barcode types are supported by this library.

Read Barcode from Word in Java
Read Barcode from Excel in Java
Read Barcode from PowerPoint in Java
Read Barcode from PDF in Java

Add Spire.Offfice.jar as Dependency

If you are working on a maven project, you can include the dependency in pom.xml file using this:

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.office</artifactId>
        <version>7.12.4</version>
    </dependency>
</dependencies>

Read Barcode from Word in Java

The following are the steps to read barcodes from a specific page of a Word file using Spire.Office for Java.

Create a Document object.
Load a sample Word file containing barcodes using Document.loadFromFile() method.
Convert the first page into image using Document.saveToImages(int pageIndex, ImageType type) method.
Scan barcodes from the image using BarcodeScanner.scan() method and return results in a String array.

import com.spire.barcode.BarcodeScanner;
import com.spire.doc.Document;
import com.spire.doc.documents.ImageType;

import java.awt.image.BufferedImage;

public class ReadBarcodeFromWord {

    public static void main(String[] args) {

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

        //Load a sample Word document
        doc.loadFromFile("C:\\Users\\Administrator\\Desktop\\Invoice.docx");

        //Convert the first page to image
        BufferedImage image = doc.saveToImages(0, ImageType.Bitmap);

        //Scan barcode from the image
        String[] data = BarcodeScanner.scan(image);

        //Print out the result
        for (int i = 0; i < data.length; i++)
        {
            System.out.println(data[i]);
        }
    }
}

Read Barcode from Excel in Java

Below are the steps to read barcodes from a worksheet using Spire.Office for Java.

Create a Workbook object.
Load a sample Excel file containing barcodes using Workbook.loadFromFile() method.
Get the first worksheet using Workbook.getWorksheets().get() method.
Convert the selected range of the worksheet into image using XlsWorksheet.saveToImage(int firstRow, int firstColumn, int lastRow, int lastColumn) method.
Scan barcodes from the image using BarcodeScanner.scan() method and return results in a String array.

import com.spire.barcode.BarcodeScanner;
import com.spire.xls.CellRange;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;

import java.awt.image.BufferedImage;

public class ReadBarcodeFromExcel {

    public static void main(String[] args) {

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

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

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

        //Get all located range from the first worksheet
        CellRange cellRange = sheet.getAllocatedRange();

        //Convert the range to image
        BufferedImage image =  sheet.saveToImage(1,1,cellRange.getLastRow(),cellRange.getLastColumn());

        //Scan barcode from the image
        String[] data = BarcodeScanner.scan(image);

        //Print out the result
        for (int i = 0; i < data.length; i++)
        {
            System.out.println(data[i]);
        }
    }
}

Read Barcode from PowerPoint in Java

The steps to read barcodes from a PowerPoint slide are as follows.

Create a Presentation object.
Load a sample PowerPoint file using Presentation.loadFromFile() method.
Get the first slide using Presentation.getSlides().get() method.
Convert the slide into image using ISlide.savAsImage() method.
Scan barcodes from the image using BarcodeScanner.scan() method and return results in a String array.

import com.spire.barcode.BarcodeScanner;
import com.spire.presentation.ISlide;
import com.spire.presentation.Presentation;

import javax.imageio.ImageIO;
import java.awt.image.BufferedImage;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;

public class ReadBarcodeFromPowerPoint {

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

        //Create a Presentation object
        Presentation presentation = new Presentation();

        //Load a sample PowerPoint file
        presentation.loadFromFile("C:\\Users\\Administrator\\Desktop\\Invoice.pptx");

        //Get the first slide
        ISlide slide = presentation.getSlides().get(0);

        //Save the first slide as image
        BufferedImage image = slide.saveAsImage();

        //Convert image to stream
        InputStream imageStream = bufferedImageToInputStream(image);

        //Scan barcode from the image stream
        String[] data = BarcodeScanner.scan(imageStream);

        //Print out the result
        for (int i = 0; i < data.length; i++) {
            System.out.println(data[i]);
        }
    }
    public static InputStream bufferedImageToInputStream(BufferedImage image) throws IOException {
        ByteArrayOutputStream os = new ByteArrayOutputStream();
        ImageIO.write(image, "png", os);
        InputStream input = new ByteArrayInputStream(os.toByteArray());
        return input;
    }
}

Read Barcode from PDF in Java

The following are the steps to read barcodes from a PDF page using Spire.Office for Java.

Create a PdfDocument object.
Load a sample PDF file using PdfDocument.loadFromFile() method.
Convert the first page into image using PdfDocument.saveAsImage(int pageIndex, PdfImageType type) method.
Scan barcodes from the image using BarcodeScanner.scan() method and return results in a String array.

import com.spire.barcode.BarcodeScanner;
import com.spire.license.LicenseProvider;
import com.spire.pdf.PdfDocument;
import com.spire.pdf.graphics.PdfImageType;

import java.awt.image.BufferedImage;

public class ReadBarcodeFromPdf {

    public static void main(String[] args) {

        //Create a PdfDocument object
        PdfDocument doc = new PdfDocument();

        //Load a sample PDF file
        doc.loadFromFile("C:\\Users\\Administrator\\Desktop\\Invoice.pdf");

        //Convert the first page to image
        BufferedImage image = doc.saveAsImage(0, PdfImageType.Bitmap);

        //Scan barcode from the image
        String[] data = BarcodeScanner.scan(image);

        //Print out the result
        for (int i = 0; i < data.length; i++)
        {
            System.out.println(data[i]);
        }
    }
}

Note:

If you get a message which reads “Not supported in Spire.Barcode Evaluation version”, it means that a specific barcode type cannot be recognized without a license. You can apply for a one-month temporary from E-iceblue to get rid of the limitation.