Evo i ove dve klase koje kompajliram..
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;
}
}
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]