How to Read .xlsx excel file using java?

We can read the excel file using POI .jar file


Before writing this java class. Whatever variables you want just create a POJO class.  And declare all the variables into it.
--------------------
ExcelRead.java
--------------------

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.apache.poi.xssf.usermodel.XSSFCell;import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class MetaDataServices {
    public void meta_uploadServices(String metafilepath) throws FileNotFoundException, ClassNotFoundException, SQLException, IOException{
        MetaClass meta = new MetaClass();
        Query metaquery = new Query();
        Query metaupdate=new Query();
        DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
        Date date = new Date();
        String uploaddate[] = dateFormat.format(date).split("/");
        meta.workbook = new XSSFWorkbook(new FileInputStream(new File(metafilepath)));
        meta.Sheet = meta.workbook.getSheetAt(1 - 1);
        for (int i = 0; i < meta.Sheet.getPhysicalNumberOfRows() - 1; i++) {
            meta.row = meta.Sheet.getRow(i + 1);
            if (meta.row == null) {
                break;
            }
            meta.column = meta.row.getLastCellNum();
            for (int m = 0; m < meta.column; m++) {
                XSSFCell rowobj = meta.row.getCell((int) m);
                if (rowobj == null) {
                    meta.Row = "";
                    break;
                } else {
                    meta.Row = rowobj.toString();
                }
                if (m == 1) {
                    if (!meta.Row.trim().equals("")) {
                        meta.ebook_isbn = meta.Row.trim().replaceAll("'","");
                        System.out.println("The Ebook_isbn is:"+meta.ebook_isbn);
                    }


                } else if (m == 2) {
                    if (!meta.Row.trim().equals("")) {
                        meta.related_isbn = meta.Row.trim().replaceAll("'","");
                        System.out.println("The Related Isbn is:"+meta.related_isbn);
                    }

  } else if (m == 3) {
                    if (!meta.Row.trim().equals("")) {
                        meta.type = meta.Row.trim().replaceAll("'","");
                    }


                } else if (m == 4) {
                    if (!meta.Row.trim().equals("")) {
                        meta.color = meta.Row.trim().replaceAll("'","");                    }


                } else if (m == 5) {
                  if (!meta.Row.trim().equals("")) {
                        meta.page= Integer.parseInt(meta.Row.trim().replace(".0", ""));
                    }


                } else if (m == 6) {
                    if (!meta.Row.trim().equals("")) {
                        meta.size= meta.Row.trim().replaceAll("'","");
                    }


                } else if (m == 7) {
                    if (!meta.Row.trim().equals("")) {
                        meta.srp = meta.Row.trim().replaceAll("'","");
                    }
                    System.out.println("...." + meta.srp);
                } else if (m == 8) {                    if (!meta.Row.trim().equals("")) {
                        meta.weight = meta.Row.trim().replaceAll("'","");
                   }
                }
         }
    }
}

This may be useful to some one.

Comments

Popular posts from this blog

How do i Increase the capacity of the Eclipse Output console?

An internal error occurred during: "Building workspace". Java heap space

How to convert the Math Number to Words in Java?