copydatatoexcel.java~11~

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

package edu.xscj.action;

import javax.swing.JTable;
import java.awt.datatransfer.*;
import java.awt.*;

public class CopyDataToExcel {

    public CopyDataToExcel() {
    }

    public void copy(JTable jtable){
        int row=jtable.getRowCount();
        int col=jtable.getColumnCount();

        StringBuffer sbf=new StringBuffer();
        Clipboard  clipboard;
        StringSelection strselection;

        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);
    }
}