copydatatoexcel.java

java(Swing) access做的成绩管理系统

package edu.xscj.action;

import javax.swing.JTable;
import java.awt.datatransfer.*;
import java.awt.*;
import javax.swing.JOptionPane;
import java.util.Vector;

public class CopyDataToExcel {
    StringBuffer sbf = new StringBuffer();
    Clipboard clipboard;
    StringSelection strselection;

    public CopyDataToExcel() {
    }

    public void copy(JTable jtable) {
        if (jtable == null) {
            return;
        }

        int row = jtable.getRowCount();
        int col = jtable.getColumnCount();

        for (int i = 0; i < row; i++) {
            for (int j = 0; j < col; j++) {
                sbf.append(jtable.getModel().getValueAt(i, j));
                if (j < col - 1) {
                    sbf.append("\t");
                }
            }
            sbf.append("\n");
        }
        strselection = new StringSelection(sbf.toString());
        clipboard = Toolkit.getDefaultToolkit().getSystemClipboard();
        clipboard.setContents(strselection, strselection);
    }

    public void copyRow(Vector vect) {

        int col = vect.size();
        for (int i = 0; i < col; i++) {
            sbf.append(vect.elementAt(i));
            sbf.append("\t");
        }
        strselection = new StringSelection(sbf.toString());
        clipboard = Toolkit.getDefaultToolkit().getSystemClipboard();
        clipboard.setContents(strselection, strselection);
    }

}