Read Excel and PDF in Java

02912

Read Excel in Java

To read Excel file in java you need to create Maven project:

To create:file—>New–>Maven project

If You Want to Download JARs Manually

Go to Maven Repository and search for:

1.poi
2.poi-ooxml
3.log4j-core
4.log4j-api

Download the .jar files for latest version

POM.xlm 

<dependencies>
        <!-- Apache POI for reading .xls files -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>5.2.3</version>
        </dependency>
        <!-- Apache POI for handling .xls formats -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>5.2.3</version>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-core</artifactId>
            <version>2.17.1</version>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-api</artifactId>
            <version>2.17.1</version>
        </dependency>
    </dependencies>
<dependencies>
        <!-- Apache POI for reading .xls files -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>5.2.3</version>
        </dependency>

        <!-- Apache POI for handling .xls formats -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>5.2.3</version>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-core</artifactId>
            <version>2.17.1</version>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-api</artifactId>
            <version>2.17.1</version>
        </dependency>

    </dependencies>
<dependencies>
        <!-- Apache POI for reading .xls files -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>5.2.3</version>
        </dependency>

        <!-- Apache POI for handling .xls formats -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>5.2.3</version>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-core</artifactId>
            <version>2.17.1</version>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-api</artifactId>
            <version>2.17.1</version>
        </dependency>

    </dependencies>

Enter fullscreen mode Exit fullscreen mode

Place them in your project’s libs folder.Open the pom.xml file and add your inside the tag. 

package pdf_reader;
import java.io.File;//Represents the Excel file.
import java.io.FileInputStream;//Reads bytes from the file.
import java.io.IOException;//
import org.apache.poi.hssf.usermodel.HSSFWorkbook;//Used to read .xls files (Excel 97-2003 format).
import org.apache.poi.ss.usermodel.*;//Handles Workbook, Sheet, Row, and Cell.
public class ExcelReader {
    public static void main(String[] args) {
        String filePath = "/home/neelakandan/Downloads/Movie 1.xls"; // Path to your file
        try (FileInputStream fis = new FileInputStream(new File(filePath));//Opening and Reading the Excel File
             Workbook workbook = new HSSFWorkbook(fis)) {
            Sheet sheet = workbook.getSheetAt(0); // Get the first sheet
            for (Row row : sheet) {
                for (Cell cell : row) {
                    switch (cell.getCellType()) //Reading Cell Values
                    {
                        case STRING://Reads and prints values based on their data type
                            System.out.print(cell.getStringCellValue() + "\t");
                            break;
                        case NUMERIC:
                            System.out.print(cell.getNumericCellValue() + "\t");
                            break;
                        case BOOLEAN:
                            System.out.print(cell.getBooleanCellValue() + "\t");
                            break;
                        default:
                            System.out.print("UNKNOWN\t");
                    }
                }
                System.out.println();
            }
        } catch (IOException e)//Catches IOException (e.g., file not found, read error) and prints the error stack trace.
        {
            e.printStackTrace();
        }
    }
}
package pdf_reader;

import java.io.File;//Represents the Excel file.
import java.io.FileInputStream;//Reads bytes from the file.
import java.io.IOException;//
import org.apache.poi.hssf.usermodel.HSSFWorkbook;//Used to read .xls files (Excel 97-2003 format).
import org.apache.poi.ss.usermodel.*;//Handles Workbook, Sheet, Row, and Cell.

public class ExcelReader {
    public static void main(String[] args) {
        String filePath = "/home/neelakandan/Downloads/Movie 1.xls"; // Path to your file

        try (FileInputStream fis = new FileInputStream(new File(filePath));//Opening and Reading the Excel File
             Workbook workbook = new HSSFWorkbook(fis)) {

            Sheet sheet = workbook.getSheetAt(0); // Get the first sheet

            for (Row row : sheet) {
                for (Cell cell : row) {
                    switch (cell.getCellType()) //Reading Cell Values
                    {
                        case STRING://Reads and prints values based on their data type
                            System.out.print(cell.getStringCellValue() + "\t");
                            break;
                        case NUMERIC:
                            System.out.print(cell.getNumericCellValue() + "\t");
                            break;
                        case BOOLEAN:
                            System.out.print(cell.getBooleanCellValue() + "\t");
                            break;
                        default:
                            System.out.print("UNKNOWN\t");
                    }
                }
                System.out.println();
            }
        } catch (IOException e)//Catches IOException (e.g., file not found, read error) and prints the error stack trace.
        {
            e.printStackTrace();
        }
    }
}
package pdf_reader;

import java.io.File;//Represents the Excel file.
import java.io.FileInputStream;//Reads bytes from the file.
import java.io.IOException;//
import org.apache.poi.hssf.usermodel.HSSFWorkbook;//Used to read .xls files (Excel 97-2003 format).
import org.apache.poi.ss.usermodel.*;//Handles Workbook, Sheet, Row, and Cell.

public class ExcelReader {
    public static void main(String[] args) {
        String filePath = "/home/neelakandan/Downloads/Movie 1.xls"; // Path to your file

        try (FileInputStream fis = new FileInputStream(new File(filePath));//Opening and Reading the Excel File
             Workbook workbook = new HSSFWorkbook(fis)) {

            Sheet sheet = workbook.getSheetAt(0); // Get the first sheet

            for (Row row : sheet) {
                for (Cell cell : row) {
                    switch (cell.getCellType()) //Reading Cell Values
                    {
                        case STRING://Reads and prints values based on their data type
                            System.out.print(cell.getStringCellValue() + "\t");
                            break;
                        case NUMERIC:
                            System.out.print(cell.getNumericCellValue() + "\t");
                            break;
                        case BOOLEAN:
                            System.out.print(cell.getBooleanCellValue() + "\t");
                            break;
                        default:
                            System.out.print("UNKNOWN\t");
                    }
                }
                System.out.println();
            }
        } catch (IOException e)//Catches IOException (e.g., file not found, read error) and prints the error stack trace.
        {
            e.printStackTrace();
        }
    }
}

Enter fullscreen mode Exit fullscreen mode

OutPut:
Leo Vijay Trisha 623 Crore 7.2
Vidaamuyarchi Ajith Kumar Trisha 139.73 Crore 6.5
Valimai Ajith Kumar Huma Qureshi 234 Crore 6.7
End game Tony Natasha 2.8 Billion 8.4
Annabelle John Mia 257 Million 5.5

PDF Reader

You can get the Apache PDFBox dependency from the Maven Repository (Maven Central).

Steps to Download

Visit the Maven Repository:–> Apache PDFBox in Maven Repository

Download the JAR File:

Click on “Download jar” under Files.

If Using Maven:
Add the following dependency to your pom.xml:

POM.xlm 

<!-- Apache PDFBox for reading PDF files -->
    <dependency>
        <groupId>org.apache.pdfbox</groupId>
        <artifactId>pdfbox</artifactId>
        <version>2.0.27</version>
    </dependency>
<!-- Apache PDFBox for reading PDF files -->
    <dependency>
        <groupId>org.apache.pdfbox</groupId>
        <artifactId>pdfbox</artifactId>
        <version>2.0.27</version>
    </dependency>
<!-- Apache PDFBox for reading PDF files -->
    <dependency>
        <groupId>org.apache.pdfbox</groupId>
        <artifactId>pdfbox</artifactId>
        <version>2.0.27</version>
    </dependency>

Enter fullscreen mode Exit fullscreen mode

Place them in your project’s libs folder.Open the pom.xml file and add your inside the tag

package pdf_reader;
import java.io.File;
import java.io.IOException;
import org.apache.pdfbox.pdmodel.PDDocument;
import org.apache.pdfbox.text.PDFTextStripper;
public class PDFReader {
    public static void main(String[] args) {
        String filePath = "/home/neelakandan/Downloads/The Story of Gandhi.pdf"; // Update the path if needed
        File file = new File(filePath);
        if (!file.exists()) {
            System.out.println("File not found!");
            return;
        }
        try (PDDocument document = PDDocument.load(file)) { // Auto-closing resource
            System.out.println("PDF Content:\n" + new PDFTextStripper().getText(document));
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}
``
package pdf_reader;

import java.io.File;
import java.io.IOException;
import org.apache.pdfbox.pdmodel.PDDocument;
import org.apache.pdfbox.text.PDFTextStripper;

public class PDFReader {
    public static void main(String[] args) {
        String filePath = "/home/neelakandan/Downloads/The Story of Gandhi.pdf"; // Update the path if needed
        File file = new File(filePath);

        if (!file.exists()) {
            System.out.println("File not found!");
            return;
        }

        try (PDDocument document = PDDocument.load(file)) { // Auto-closing resource
            System.out.println("PDF Content:\n" + new PDFTextStripper().getText(document));
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}
``
package pdf_reader;

import java.io.File;
import java.io.IOException;
import org.apache.pdfbox.pdmodel.PDDocument;
import org.apache.pdfbox.text.PDFTextStripper;

public class PDFReader {
    public static void main(String[] args) {
        String filePath = "/home/neelakandan/Downloads/The Story of Gandhi.pdf"; // Update the path if needed
        File file = new File(filePath);

        if (!file.exists()) {
            System.out.println("File not found!");
            return;
        }

        try (PDDocument document = PDDocument.load(file)) { // Auto-closing resource
            System.out.println("PDF Content:\n" + new PDFTextStripper().getText(document));
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}
``

Enter fullscreen mode Exit fullscreen mode

原文链接：Read Excel and PDF in Java

展开阅读全文
© 版权声明
文章版权声明 1、本网站名称：拾光赋
2、本站永久网址：https://www.blogs.ink
3、本网站的文章部分内容可能来源于网络，仅供大家学习与参考，如有侵权，请联系站长QQ：805375623进行删除处理。
4、本站一切资源不代表本站立场，并不代表本站赞同其观点和对其真实性负责。
5、本站一律禁止以任何方式发布或转载任何违法的相关信息，访客发现请向站长举报
6、本站资源大多存储在云盘，如发现链接失效，请联系我们我们会第一时间更新。

THE END
Java（EN）
# java# beginners# payilagam# fullstack
喜欢就支持一下吧
点赞12 分享
评论 抢沙发

请登录后发表评论

    暂无评论内容

kity的头像-拾光赋
今日剩余 62.4%
本周剩余 37.5%
本月剩余 42.1%
本年剩余 70.6%
最近评论
杀人蜂的头像-拾光赋

杀人蜂4天前0

我很好奇这个网站能提供什么
Vito的头像-拾光赋

Vito6个月前2

你就是我心中的那首忐忑，总是让我惊心动魄
Jason.Meng的头像-拾光赋钻石会员

Jason.Meng徽章-人气大使-拾光赋6个月前2

总是会在人生的不同阶段反复爱上大佬的文章~
每日一言