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
Post a Comment