ezcelldemo.java

用Java写的报表.功能如下: 0.内建网络打印,网络预览功能！ 1.文件操作。包括url 指定的文件。 2.全功能打印支持。包括打印预览。 3.Undo 和 redo。 4.合并单元格。 5.Cel

        group.add(ahs[FORMAT_ALIGN_X_CENTER].getButton());
        formatTB.add((JComponent) ahs[FORMAT_ALIGN_TOP].getValue("BUTTON"));
        formatTB.add((JComponent) ahs[FORMAT_ALIGN_BOTTOM].getValue("BUTTON"));
        formatTB.add((JComponent) ahs[FORMAT_ALIGN_Y_CENTER].getValue("BUTTON"));
        group = new ButtonGroup();
        group.add(ahs[FORMAT_ALIGN_TOP].getButton());
        group.add(ahs[FORMAT_ALIGN_BOTTOM].getButton());
        group.add(ahs[FORMAT_ALIGN_Y_CENTER].getButton());
        formatTB.add((JComponent) ahs[FORMAT_WORD_WRAP].getValue("BUTTON"));
        formatTB.addSeparator();
        formatTB.add((JComponent) ahs[FORMAT_BORDER].getValue("BUTTON"));
        formatTB.add((JComponent) ahs[FORMAT_MERGE].getValue("BUTTON"));
        formatTB.addSeparator();
        formatTB.add((JComponent) ahs[FORMAT_NUMBER_FORMAT].getValue("BUTTON"));

        JPanel toolpane = new JPanel();
        toolpane.setLayout(new FlowLayout(FlowLayout.LEFT, 0, 0));
        toolpane.setPreferredSize(new Dimension(600, 60));
        toolpane.add(fileTB);
        toolpane.add(editTB);
        toolpane.add(searchTB);
        toolpane.add(viewTB);
        toolpane.add(formatTB);

        return toolpane;
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditBookProperty() {
        String title = cellBean.getTitle();
        title = JOptionPane.showInputDialog("Title:");

        if (title != null) {
            cellBean.setTitle(title);
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditCheckSpell() {
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditClear() {
        try {
            cellBean.clearSelectionText(null, null);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditClearWithFormat() {
        try {
            cellBean.clearSelection(null, null);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditCopy() {
        try {
            cellBean.copySelection(null, null);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditCut() {
        try {
            cellBean.cutSelection(null, null);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditDeleteCol() {
        try {
            cellBean.removeSelectionCol(null);
        } catch (Exception e) {
            alert(e.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditDeleteRow() {
        try {
            cellBean.removeSelectionRow(null);
        } catch (Exception e) {
            alert(e.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditDeleteSheet() {
        try {
            // delete active sheet
            cellBean.removeSheet(-1);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditInsertCol() {
        try {
            cellBean.insertSelectionCol(null);
        } catch (Exception e) {
            alert(e.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditInsertRow() {
        try {
            cellBean.insertSelectionRow(null);
        } catch (Exception e) {
            alert(e.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditInsertSheet() {
        try {
            cellBean.addSheet(new ZDefaultSheet());
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditPaste() {
        try {
            cellBean.pasteTextIntoSelection(null, null);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditPasteWithFormat() {
        try {
            cellBean.pasteIntoSelection(null, null);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditRedo() {
        try {
            cellBean.redo();
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditSheetProperty() {
        String title = cellBean.getSheet().getTitle();
        title = JOptionPane.showInputDialog("Title:");

        if (title != null) {
            cellBean.getSheet().setTitle(title);
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onEditUndo() {
        cellBean.undo();
    }

    /**
     * DOCUMENT ME!
     */
    private void onFileExit() {
        System.exit(0);
    }

    /**
     * DOCUMENT ME!
     */
    private void onFileExportAsPostscript() {
        try {
            cellBean.exportAsPostscript();
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFileNew() {
        try {
            if (cellBean.isModified()) {
                switch (JOptionPane.showConfirmDialog(null,
                                                      "current book has been modified, would you like to save it?",
                                                      "save it...",
                                                      JOptionPane.YES_NO_CANCEL_OPTION)) {
                case JOptionPane.YES_OPTION:

                    if (!onFileSaveAs()) {
                        return;
                    }

                    break;

                case JOptionPane.CANCEL_OPTION:
                    return;

                default:
                    break;
                }
            }

            cellBean.clear();
            setTitle("ZCell v1.00 [" + cellBean.getFileName() + "]");
        } catch (Exception e) {
            alert(e.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFileOpen() {
        if (getFileChooser().showOpenDialog(EZCellDemo.this) != JFileChooser.APPROVE_OPTION) {
            return;
        }

        try {
            cellBean.open(getFileChooser().getSelectedFile().getName());
            setTitle("ZCell v1.00 [" + cellBean.getFileName() + "]");
        } catch (Exception e) {
            alert(e.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFilePrint() {
        cellBean.print(true);
    }

    /**
     * DOCUMENT ME!
     */
    private void onFilePrintPreview() {
        try {
            cellBean.printPreview();
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFilePrintSetup() {
        cellBean.printSetup();
    }

    /**
     * DOCUMENT ME!
     */
    private void onFileSave() {
        try {
            cellBean.save();
        } catch (Exception e) {
            alert(e.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @return DOCUMENT ME!
     */
    private boolean onFileSaveAs() {
        if (getFileChooser().showSaveDialog(EZCellDemo.this) != JFileChooser.APPROVE_OPTION) {
            return false;
        }

        try {
            cellBean.saveAs(getFileChooser().getSelectedFile().getName());
            setTitle("ZCell v1.00 [" + cellBean.getFileName() + "]");

            return true;
        } catch (Exception e) {
            alert(e.getMessage());

            return false;
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatAlignBottom() {
        try {
            cellBean.setSelectionVertAlign(null, null, ZBase.BOTTOM);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatAlignLeft() {
        try {
            cellBean.setSelectionHorzAlign(null, null, ZBase.LEFT);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatAlignRight() {
        try {
            cellBean.setSelectionHorzAlign(null, null, ZBase.RIGHT);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatAlignTop() {
        try {
            cellBean.setSelectionVertAlign(null, null, ZBase.TOP);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatAlignXCenter() {
        try {
            cellBean.setSelectionHorzAlign(null, null, ZBase.XCENTER);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatAlignYCenter() {
        try {
            cellBean.setSelectionVertAlign(null, null, ZBase.YCENTER);
        } catch (Exception ex) {