[ biske86 @ 30.08.2009. 18:56 ] @
Pokušavam na iskompajliram i pokrenem program koji kreira i vrši upis odnosno čitanje iz excell fajla. Skinuo sam sa interneta klase poi-3.2, ubacio ih u eclipse i probao da kompajliram ali mi javlja dve greške. Ukoliko neko zna rešenje molim za pomoć. Evo i ove dve klase koje kompajliram.. Code: import java.util.*; import java.io.*; import java.sql.*; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.util.StringUtil; /* * Parser.java * Parsiranje ulaznog excel fajla, i smestanja rezultata u Kolekciju objekata * Kolekcija se prosledjuje u bazu */ public class Parser { protected HSSFWorkbook hssfWorkbook; // Ulazni excel fajl private String filename; // Naziv ulaznog fajla private Vector kasaArtikli; private StringBuffer logFile; public Parser(String p_filename){ setLogFile(new StringBuffer()); this.filename = p_filename; try { InputStream input = new FileInputStream(p_filename); hssfWorkbook = new HSSFWorkbook( input ); } catch (FileNotFoundException e) { e.printStackTrace();} catch (IOException e) { e.printStackTrace();} } // Parsiranje pojedinicanog artikla public void parseWorkbook() { kasaArtikli = new Vector(); HSSFSheet sheet1 = hssfWorkbook.getSheetAt(0); try { int i = 0; while(true) { HSSFRow r_temp = sheet1.getRow(i); if(r_temp == null) { i++; continue; } if(getCellValue(r_temp, r_temp.getCell(0)).equals("1.") ) break; i++; } System.out.println(i); while (true) { HSSFRow row = sheet1.getRow(i); if(getCellValue(row, row.getCell(0)).equals("UKUPN")) { System.out.println("Ushao u Break"); break; } else { KasaArtikalRow tempRow = new KasaArtikalRow( getCellValue(row, row.getCell(1)) , getCellValue(row, row.getCell(2)) , getCellValue(row, row.getCell(3)) , getCellValue(row, row.getCell(4)) , getCellValue(row, row.getCell(5)) , getCellValue(row, row.getCell(6)) , getCellValue(row, row.getCell(7)) , getCellValue(row, row.getCell(7)) ); kasaArtikli.add(tempRow); i++; } } } catch (Exception exe) { exe.printStackTrace(); } System.out.println(kasaArtikli.toString()); } public String getCellValue(HSSFRow p_row, HSSFCell p_cell) { String result = " "; if(p_cell == null) return " "; switch (p_cell.getCellType()) { case HSSFCell.CELL_TYPE_FORMULA : result = "" + p_cell.getCellFormula(); break; case HSSFCell.CELL_TYPE_NUMERIC : result = "" + p_cell.getNumericCellValue(); break; case HSSFCell.CELL_TYPE_STRING : result = p_cell.getRichStringCellValue().getString().trim(); break; default : result = ""; break; } getLogFile().append(result+"\n"); if (result.equals("")) System.out.println("\nPrazan String"); return result; } public void setHSSFWorkbook(HSSFWorkbook p_hssfWorkbook) { this.hssfWorkbook = p_hssfWorkbook; } public HSSFWorkbook getHSSFWorkbook() { return this.hssfWorkbook; } public void setKasaArtikli(Vector kasaArtikli) { this.kasaArtikli = kasaArtikli; } public Vector getKasaArtikli() { return kasaArtikli; } public static void main(String[] args) { } public void setLogFile(StringBuffer logFile) { this.logFile = logFile; } public StringBuffer getLogFile() { return logFile; } } Code: import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStream; import org.apache.poi.hssf.usermodel.HSSFWorkbook; public class Test { public static void main(String[] args) { HSSFWorkbook hssfWorkbook; try { InputStream input = new FileInputStream("c:\\test.xls"); hssfWorkbook = new HSSFWorkbook(input); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } } A evo i greške koju izbacuje: ![]() [Ovu poruku je menjao biske86 dana 30.08.2009. u 20:11 GMT+1] |