如何将jtable中的数据导入到EXECL中？

使用POI包

 

public class ExportExcel
{

       JTable table;
       FileOutputStream fos;
       JFileChooser jfc=new JFileChooser();

       public ExportExcel(JTable table)
       {
              this.table=table;
              jfc.addChoosableFileFilter(new FileFilter()
              {
                    public boolean accept(File file)
                    {
                          return (file.getName().indexOf("xls")!=-1);
                    }
                    public String getDescription()
                    {
                          return "Excel";
                    }
                });

               jfc.showSaveDialog(null);
               File file=jfc.getSelectedFile();
               try
               {
                    this.fos=new FileOutputStream(file+".xls");
               } catch (FileNotFoundException ex)
               {
                    ex.printStackTrace();
               }
       }

       public void export()
       {
               HSSFWorkbook wb=new HSSFWorkbook();
               HSSFSheet hs=wb.createSheet();
               TableModel tm=table.getModel();
               int row=tm.getRowCount();
               int cloumn=tm.getColumnCount();
               HSSFCellStyle style=wb.createCellStyle();
               style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
               style.setBorderLeft(HSSFCellStyle.BORDER_THIN);                
               style.setBorderRight(HSSFCellStyle.BORDER_THIN);
               style.setBorderTop(HSSFCellStyle.BORDER_THIN);
               style.setFillForegroundColor(HSSFColor.LIGHT_GREEN.index);
               style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
               HSSFFont font = wb.createFont();
               font.setFontHeightInPoints((short)11);
               style.setFont(font);
               HSSFCellStyle style1=wb.createCellStyle();
               style1.setBorderBottom(HSSFCellStyle.BORDER_THIN);
               style1.setBorderLeft(HSSFCellStyle.BORDER_THIN);
               style1.setBorderRight(HSSFCellStyle.BORDER_THIN);
               style1.setBorderTop(HSSFCellStyle.BORDER_THIN);
               style1.setFillForegroundColor(HSSFColor.ORANGE.index);
               style1.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
               HSSFFont font1 = wb.createFont();
               font1.setFontHeightInPoints((short)15);
               font1.setBoldweight((short)700);
               style1.setFont(font);

               for(int i=0;i<row+1;i++)
               {
                    HSSFRow hr=hs.createRow(i);
                    for(int j=0;j<cloumn;j++)
                    {
                         if(i==0)
                         {
                              String value=tm.getColumnName(j);
                              int len=value.length();
                              hs.setColumnWidth((short)j,(short)(len*400));
                              HSSFRichTextString srts=new HSSFRichTextString(value);
                              HSSFCell hc=hr.createCell((short)j);
                              hc.setEncoding((short)1);
                              hc.setCellStyle(style1);
                              hc.setCellValue(srts);
                         }
                         else
                         {
                              String value=tm.getValueAt(i-1,j).toString();
                              HSSFRichTextString srts=new HSSFRichTextString(value);
                              HSSFCell hc=hr.createCell((short)j);
                              hc.setEncoding((short)1);
                              hc.setCellStyle(style);

                              if(value.equals("")||value==null)
                              {
                                    hc.setCellValue(new HSSFRichTextString(""));
                              }
                              else
                              {
                                    hc.setCellValue(srts);
                              }
                          }
                       }
                   }

                   try
                   {
                          wb.write(fos);
                          fos.close();
                   }
                   catch (IOException ex)
                   {
                          ex.printStackTrace();
                   }
           }
  }

//方法的調用
ExportExcel exportExcel = new ExportExcel(this.jTable1);
exportExcel.export();

 

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/crl_lxy/archive/2008/06/16/2552140.aspx