swing导出html到excel

1 ShowCopDetal

package com.product;

import java.awt.BorderLayout;

import java.awt.Color;

import java.awt.Component;

import java.awt.Container;

import java.awt.Desktop;

import java.awt.Dimension;

import java.awt.EventQueue;

import java.awt.Font;

import java.awt.Graphics;

import java.awt.Graphics2D;

import java.awt.GridLayout;

import java.awt.color.ColorSpace;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.image.BufferedImage;

import java.awt.image.ColorConvertOp;

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.net.URISyntaxException;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

import javax.swing.AbstractAction;

import javax.swing.AbstractButton;

import javax.swing.BorderFactory;

import javax.swing.Box;

import javax.swing.BoxLayout;

import javax.swing.JButton;

import javax.swing.JCheckBox;

import javax.swing.JComponent;

import javax.swing.JEditorPane;

import javax.swing.JFileChooser;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTextField;

import javax.swing.ScrollPaneLayout;

import javax.swing.SwingConstants;

import javax.swing.UIManager;

import javax.swing.WindowConstants;

import javax.swing.event.HyperlinkEvent;

import javax.swing.event.HyperlinkListener;

import javax.swing.filechooser.FileFilter;

import jxl.Workbook;

import jxl.write.Label;

import jxl.write.WritableCellFormat;

import jxl.write.WritableFont;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

public class ShowCopDetal extends JPanel{

     // 内置了本地系统桌面操作支持

    private Desktop desktop;

    private static final long serialVersionUID = 1L;

    // html内容

   // private static final String HTML_TEXT = "<html><font color='red'><a href=\"http://www.helpsoff.com.cn\" target=\"_blank\">支持SOFF，插件无罪</a></font>";

    private static List contentheader;

    private static List contentbody;

    public static List getContentheader() {

        return contentheader;

    }

    public static void setContentheader(List contentheader) {

        ShowCopDetal.contentheader = contentheader;

    }

    public static List getContentbody() {

        return contentbody;

    }

    public static void setContentbody(List contentbody) {

        ShowCopDetal.contentbody = contentbody;

    }

    public ShowCopDetal() {}

    public static void main(String[] args) {

        EventQueue.invokeLater(new Runnable() {

            public void run() {

                //createGUI();

                scrollpanelinframe();

            }

        });

    }

    public static void createGUI() {

        JFrame frame = new JFrame("在Swing中使用Html标签");

        frame.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);

        frame.setSize(new Dimension(450, 200));

        frame.getContentPane().add(new ShowCopDetal());

        frame.setResizable(false);

        frame.setLocationRelativeTo(null);

        frame.setAlwaysOnTop(true);

        frame.setVisible(true);

    }

   static  JFrame frame = new JFrame("model detail");

    /////////////////////////////////test/////////////////////////////////////

    public static void scrollpanelinframe() {

        //init data

        testENT a=new testENT("zhangsan","23","china");

        testENT b=new testENT("lisi","26","usa");

        testENT c=new testENT("mhmd","28","my");

        testENT aa=new testENT("azhangsan","a23","china");

        testENT bb=new testENT("blisi","b26","usa");

        testENT cc=new testENT("cmhmd","c28","my");

        List ds=new ArrayList();

        ds.add(a);

        ds.add(b);

        ds.add(c);

        List ds2=new ArrayList();

        ds2.add(aa);

        ds2.add(bb);

        ds2.add(cc);

        List totalsds=new ArrayList();

        totalsds.add(ds);

        totalsds.add(ds2);

        ShowCopDetal.setContentbody(totalsds);

        String[] headerstr={"Colum 1","Colum 2","Colum 3","Colum 4"};

        ShowCopDetal.setContentheader(java.util.Arrays.asList(headerstr));

        frame.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);

        frame.setSize(new Dimension(1100, 760));

        StringBuffer initialText=new StringBuffer();

        initialText.append("<html>\n");

        //initialText.append("<div style=\"border:2px solid ;\">");

        for(int v=0;v<totalsds.size();v++)

        {   

            initialText.append("<div style=\"border:10px solid orange;\">");

            initialText.append("<fieldset>");

            initialText.append("<legend>{infomation of "+v+" }</legend>");

            initialText.append("<table >");

            initialText.append("<tr style=\"font-size:2px color:red\"><td  colSpan=\"9\">****************************************************************************************</td></tr>");

             for(int n=0;n<((List)totalsds.get(v)).size();n++)

             {

                 testENT te=(testENT) ((List)totalsds.get(v)).get(n);

                 initialText.append("<tr><td  colSpan=\"9\">_______________"+te.getName()+"_________</td></tr>");

                 initialText.append("<tr>");

                 initialText.append("<td>");

                 initialText.append("<font size=+2 color=green>");

                 initialText.append(te.getName());

                 initialText.append("</font>");

                 initialText.append("</td>");

                 initialText.append("<td>");

                 initialText.append("<font size=+2 color=red>");

                 initialText.append(te.getAge());

                 initialText.append("</font>");

                 initialText.append("</td>");

                 initialText.append("<td>");

                 initialText.append("<font size=+2 color=yellow>");

                 initialText.append(te.getCountry());

                 initialText.append("</font>");

                 initialText.append("</td>");

                 initialText.append("</tr>");

                // initialText.append("<tr><td  colSpan=\"9\" style=\"border-bottom:#FF0000 solid 1px; width:50%; background-color:#00CC33; text-align:center; line-height:24px;\"></td></tr>");

             }

             initialText.append("</table>");

             initialText.append("</fieldset>");

             initialText.append("</div>");

        }

        System.out.println(initialText);

             JButton btsave=new JButton("Save");

             Dimension preferredSize = new Dimension(10,20);//设置尺寸

             btsave.setPreferredSize(preferredSize);

             btsave.setLocation(10, 10);

             //btsave.addActionListener(this);

             btsave.addActionListener(new ActionListener() {

                @Override

                public void actionPerformed(ActionEvent e) {

                    // TODO Auto-generated method stub

                      JOptionPane.showMessageDialog(null,"start");

                      //selectSavePath();

                    //List<String[]> list

                    //  getcontentbody();

                     // getcontentheader();

                      List list=new ArrayList();

                      list.add(0,ShowCopDetal.getContentheader());

                      list.add(1,ShowCopDetal.getContentbody());

                      try {

                        writeExcel(list);

                    } catch (Exception e1) {

                        // TODO Auto-generated catch block

                        e1.printStackTrace();

                    }

                }

                 });

             //JPanel rightPanel=new JPanel();

             JScrollPane rightPanel = new JScrollPane();

             rightPanel.setLayout(new ScrollPaneLayout());

             JLabel   theLabel = new JLabel(initialText.toString());

               theLabel.setVerticalAlignment(SwingConstants.TOP);

               theLabel.setHorizontalAlignment(SwingConstants.NORTH_EAST);

               theLabel.setLocation(100, 10);

             //JScrollPane.UPPER_LEFT_CORNER

             rightPanel.setBorder(BorderFactory.createCompoundBorder(

                             BorderFactory.createTitledBorder("preview detail"),

                             BorderFactory.createEmptyBorder(40,10,20,20)));

            // rightPanel.setColumnHeaderView(btsave);

             rightPanel.setRowHeaderView(btsave);

             //rightPanel.setViewportView(btsave);

              rightPanel.setViewportView(theLabel);

              //rightPanel.setLayout(new ScrollPaneLayout());

           //  frame.add(jscPanel);

              frame.add(rightPanel); 

        frame.setResizable(true);

        frame.setLocationRelativeTo(null);

        frame.setAlwaysOnTop(false);

        frame.setVisible(true);

    }

    public static void writeExcel(List list)

               throws Exception {

              //弹出保存框

              JFileChooser file = ShowCopDetal.getFile();

              //判断是否关闭或取消保存框

              if (file != null) {

               //的到保存路径

               String fpath=file.getSelectedFile().getAbsolutePath()+".xls";

               //创建文件

               File f = new File(fpath);

               WritableWorkbook wwb = Workbook.createWorkbook(new FileOutputStream(f));

               WritableSheet ws = wwb.createSheet("TestSheet1", 0);

               // 设置字体样式

               WritableFont wfc = new WritableFont(WritableFont.ARIAL, 16, WritableFont.BOLD, false);

               WritableCellFormat wcfFC = new WritableCellFormat(wfc);

               // 遍历列头字段名

               for (int i = 0; i < ((List)list.get(0)).size(); i++) {

                Label labelC = new jxl.write.Label(i, 0, ((List)list.get(0)).get(i).toString(), wcfFC);

                ws.addCell(labelC);

               }

               // 遍历内容

               for (int i = 1; i < list.size(); i++) {

                for (int j = 0; j < ((List)list.get(i)).size(); j++) {

                 Label labelC = new jxl.write.Label(j, i, ((List)list.get(i)).get(j).toString());

                 ws.addCell(labelC);

                }

               }

               // 写入Exel工作表

               wwb.write();

               // 关闭Excel工作薄对象

               wwb.close();

               //消息框

               JOptionPane.showMessageDialog(null, "File is saved to:"+fpath,"Save success!",JOptionPane.INFORMATION_MESSAGE);

              }

             }

    public static JFileChooser getFile() {

          //默认打开D盘

          JFileChooser file = new MyChooser("");

          // 下面这句是去掉显示所有文件这个过滤器。

          file.setAcceptAllFileFilterUsed(false);

          // 添加excel文件的过滤器

          file.addChoosableFileFilter(new ExcelFileFilter("xls"));

          int result = file.showSaveDialog(null);

          // JFileChooser.APPROVE_OPTION是个整型常量，代表0。就是说当返回0的值我们才执行相关操作，否则什么也不做。

          if (result == JFileChooser.APPROVE_OPTION) {

           // 获得你选择的文件绝对路径。并输出。当然，我们获得这个路径后还可以做很多的事。

           String path = file.getSelectedFile().getAbsolutePath();

           System.out.println(path);

          } else {

           file = null;

           System.out.println("You have canceled and colosed the window!");

          }

          return file;

         }

         //文件过滤器 只保存xls文件

         private static class ExcelFileFilter extends FileFilter {

          String ext;

          ExcelFileFilter(String ext) {

           this.ext = ext;

          }

          @Override

          public boolean accept(File f) {

           if (f.isDirectory()) {

            return true;

           }

           String fileName = f.getName();

           int index = fileName.lastIndexOf('.');

           if (index > 0 && index < fileName.length() - 1) {

            String extension = fileName.substring(index + 1).toLowerCase();

            if (extension.equals(ext))

             return true;

           }

           return false;

          }

          @Override

          public String getDescription() {

           if (ext.equals("xls")) {

            return "Microsoft Excel file(*.xls)";

           }

           return "";

          }

         }

    private static class MyChooser extends JFileChooser {

          private static final long serialVersionUID = 1L;

          MyChooser(String path) {

           super(path);

          }

          public void approveSelection() {

           File file = this.getSelectedFile();

           if (file.exists()) {

            int copy = JOptionPane.showConfirmDialog(null, "Do you want to overwrite the current file?",

              "Save", JOptionPane.YES_NO_OPTION,

              JOptionPane.QUESTION_MESSAGE);

            if (copy == JOptionPane.YES_OPTION)

             super.approveSelection();

           } else

            super.approveSelection();

          }

         }

}

2 bean 类

package com.product;

public class testENT {

    public testENT (String name,String age,String country)

    {

        this.name=name;

        this.age=age;

        this.country=country;

    }

    private String name;

    private String age;

    private String country;

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

    public String getAge() {

        return age;

    }

    public void setAge(String age) {

        this.age = age;

    }

    public String getCountry() {

        return country;

    }

    public void setCountry(String country) {

        this.country = country;

    }

}

3 依赖jar :

jxl-2.4.2.jar

4 截图：

巴特西

swing导出html到excel

最新文章

热门文章