Problem mit Java Excel API

[Gabel]

Hallo,

ich benutze Java Excel API, um Excel Dateien in mein Programm importieren zu können. Das funktioniert auch wunderbar. Nur lassen sich die importierten Dateien in meinem Programm nicht bearbeiten.

Das Tutorial unter Java Excel API Tutorial hilft mir leider nicht weiter.

Kann mir jemand helfen?

benutze NetBeans 5 - mein Code:

private void jOeffnenActionPerformed(java.awt.event.ActionEvent evt) {                                         

        File file = chooseExcelFile();

        if (file == null) {

            return;

        }


        setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));

        if(jRegister.getSelectedIndex() == 1)

            {

            Sheet sheet = readExcelSheet(file);

        if (sheet != null) {

            displaySheet(sheet, jTable1);

        }

            }

        else if(jRegister.getSelectedIndex() == 2){

        Sheet sheet = readExcelSheet(file);

        if (sheet != null) {

            displaySheet(sheet, jTable2);

        }    

        }

        else{


        }

        setCursor(Cursor.getDefaultCursor());

    }    

    private Sheet readExcelSheet (File file) {

         Workbook wbk;

         WritableWorkbook copy;

        try {

            wbk = Workbook.getWorkbook(file);

            copy = Workbook.createWorkbook(new File("temp.xls"), wbk);

        } catch (Exception ex) {

            JOptionPane message = new JOptionPane(

                    "Die Datei kann nicht gelesen werden! Verzeichniss: " + file.getPath(),

                    JOptionPane.ERROR_MESSAGE);

            return null;

        }

        if (wbk.getNumberOfSheets() <= 0) {

            JOptionPane message = new JOptionPane(

                    "Datei enthält keine Inhalte!",

                    JOptionPane.ERROR_MESSAGE);

            return null;

        }

        if(jRegister.getSelectedIndex() == 1){

            jTable1.setEnabled(true);

            jSpeichern.setEnabled(true);

            jDrucken.setEnabled(true);

        }

        else if(jRegister.getSelectedIndex() == 2){

            jTable2.setEnabled(true);

            jSpeichern.setEnabled(true);

            jDrucken.setEnabled(true);

        }

        else{

        }

        // gibt erste Seite aus

        return copy.getSheet(0);

    }


    private void displaySheet(Sheet sheet, JTable table) {

        table.setModel(new SheetTableModel(sheet));

    }


    private static class SheetTableModel implements TableModel {


        private Sheet sheet;


        public SheetTableModel (Sheet sheet) {

            this.sheet = sheet;

        }


        public int getRowCount() {

            return sheet.getRows();

        }


        public int getColumnCount() {

            return sheet.getColumns();

        }

        public String getColumnName(int column) {

            String result = "";

            for (; column >= 0; column = column / 26 - 1) {

                result = (char)((char)(column%26)+'A') + result;

            }

            return result;

        }


        public Class<?> getColumnClass(int columnIndex) {

            return String.class;

        }


        public boolean isCellEditable(int rowIndex, int columnIndex) {

            return true;

        }


        public Object getValueAt(int rowIndex, int columnIndex) {

            Cell cell = sheet.getCell(columnIndex, rowIndex);

            return cell.getContents();

        }


        public void setValueAt(Object aValue, int rowIndex, int columnIndex) {

        }


        public void addTableModelListener(TableModelListener l) {

        }


        public void removeTableModelListener(TableModelListener l) {

        }


    }  // end of SheetTableModel

    private File chooseExcelFile () {

        JFileChooser chooser = new JFileChooser();


        int returnVal = chooser.showOpenDialog(this);

        if (returnVal == JFileChooser.APPROVE_OPTION) {

            return chooser.getSelectedFile();

        }

        return null;

    }