Criei uma método utilizando a biblioteca POI, pra ler um arquivo de formato .xls excel e gravar os dados num banco de dados, porém gostaria de que durante a leitura das linhas ele pulasse a primeira linha do arquivo xls, que contem apenas duas colunas (data, do tipo date e meta do tipo double). Como faço isso???
private void tg_upload1_action(JdbcUtil j, ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
HttpSession session = request.getSession(true);
try {
CadastroDePMTActionForm f = (CadastroDePMTActionForm) form;
if (f.getUpload() != null && f.getUpload().toString() != null && f.getUpload().toString().length() > 0) {
String path = this.getServlet().getServletContext().getRealPath("index.html");
path = path.substring(0, path.lastIndexOf("/"));
String realPath0bl_form_Tb_meta_diaria_1 = path + "/temp";
realPath0bl_form_Tb_meta_diaria_1 = realPath0bl_form_Tb_meta_diaria_1 + java.io.File.separator;
java.io.File fl = new java.io.File(realPath0bl_form_Tb_meta_diaria_1 + f.getUpload().toString());
java.io.FileReader fr = new java.io.FileReader(fl);
java.io.BufferedReader reader = new java.io.BufferedReader(fr);
java.io.BufferedReader in = new java.io.BufferedReader(new java.io.FileReader(realPath0bl_form_Tb_meta_diaria_1 + f.getUpload().toString()));
String auxiliar = (realPath0bl_form_Tb_meta_diaria_1 + f.getUpload().toString());
List sheetData = new ArrayList();
java.io.FileInputStream fis = null;
try {
fis = new java.io.FileInputStream(auxiliar);
org.apache.poi.hssf.usermodel.HSSFWorkbook workbook = new org.apache.poi.hssf.usermodel.HSSFWorkbook(fis);
org.apache.poi.hssf.usermodel.HSSFSheet sheet = workbook.getSheetAt(0);
Iterator rows = sheet.rowIterator();
rows.next();
while (rows.hasNext()) {
org.apache.poi.hssf.usermodel.HSSFRow row = (org.apache.poi.hssf.usermodel.HSSFRow) rows.next();
Iterator cells = row.cellIterator();
ArrayList data = new ArrayList();
while (cells.hasNext()) {
org.apache.poi.hssf.usermodel.HSSFCell cell = (org.apache.poi.hssf.usermodel.HSSFCell) cells.next();
data.add(cell);
}
org.apache.poi.hssf.usermodel.HSSFCell cellData = (org.apache.poi.hssf.usermodel.HSSFCell) data.get(0);
org.apache.poi.hssf.usermodel.HSSFCell cellValor = (org.apache.poi.hssf.usermodel.HSSFCell) data.get(1);
Date dt_meta = cellData.getDateCellValue();
double vl_meta = cellValor.getNumericCellValue();
Tb_meta_diaria table = new Tb_meta_diaria();
table.setDt_meta(new java.sql.Date(dt_meta.getTime()));
table.setVl_meta(new Double(vl_meta));
j.insert(table);
}
} catch (java.io.IOException e) {
e.printStackTrace();
} finally {
if (fis != null) {
fis.close();
}
}
ActionForward actionForward = mapping.findForward("same");
}
session.setAttribute(mapping.getName(), form);
} catch (Exception e) {
throw e;
} finally {
}
}