JExcel 刪除一行…………

最近在玩JExcel的功能，可是，玩著玩著就讓人蛋疼！！！！！！！！！

總是出現錯誤，還沒辦法解決，總是看文件，尋求解決問題的辦法，今天找到了一個挺有用的方法，在網上找到的哦時候也沒有見到誰用過這個方法，也可能是沒有遇到相關的問題，下面就講講我的小東西的要求和一些解決問題的辦法：

 

下載api等等那些事情我就不說了，主要是關於遇到的一些問題，要是有人有需求的話，可以提，注意只是可以提，我不知道我有沒有解決您的問題的能力，呵呵

 

我這個小東西的目地：

我們學校的網站上有個選修可名單，是Excel型別的，目地就是提取出選了同樣選修課的學生：

（1）JFrame等相關swing的使用：視窗，事件，檔案對話方塊；

（2）JExcel 讀取檔案，修改檔案{得到一個Cell的資料，判斷資料，刪除一行，再讀，反覆}

看看程式碼：（注意，程式碼有點亂）

                           package com.gl.excel; import javax.swing.JFrame; import javax.swing.UIManager; public class MainProgram { public static void main(String[] args) throws Exception { UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName()); ExcelFrame frame = ExcelFrame.getExcelFrame(); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } }  

 

 

package com.gl.excel; import java.awt.FlowLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.io.File; import java.io.IOException; import javax.swing.JButton; import javax.swing.JFileChooser; import javax.swing.JFrame; import javax.swing.JLabel; public class ExcelFrame extends JFrame { private static final long serialVersionUID = 1L; public static final int WIDTH = 400; public static final int HEIGHT = 300; public static final int X = 500; public static final int Y = 10; private File file; private JButton submit, open, select; private JLabel demo; private JFileChooser chooser; private static ExcelFrame frame; private ExcelFrame() { launchFrame(); } public static ExcelFrame getExcelFrame() { if (frame == null) { frame = new ExcelFrame(); } return frame; } public void launchFrame() { this.setSize(WIDTH, HEIGHT); this.setLocation(X, Y); this.setTitle("檔案處理"); select = new JButton("選擇檔案"); open = new JButton("開啟檔案"); submit = new JButton("提取專業"); demo = new JLabel("提示資訊：點選開啟按鈕，選中要開啟的檔案………"); ActionListener listener = new ActionListener() { @Override public void actionPerformed(ActionEvent e) { if (e.getSource() == select) { chooser = new JFileChooser("C:/Users/SERVER/Desktop"); int result = chooser.showOpenDialog(frame); if (result == JFileChooser.APPROVE_OPTION) { file = chooser.getSelectedFile(); System.out.println(file); frame.setTitle(file.getName()); } else if (e.getSource() == open) System.out.println(file.getName()); open(file.getName()); } } }; select.addActionListener(listener); open.addActionListener(listener); submit.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { try { Excel excel = new Excel(); excel.change(file, "2007"); } catch (Exception e1) { e1.printStackTrace(); } } }); getContentPane().setLayout(new FlowLayout()); getContentPane().add(demo); getContentPane().add(select); getContentPane().add(open); getContentPane().add(submit); this.pack(); this.setVisible(true); } private void open(String filename) { Runtime rt = Runtime.getRuntime(); String[] command = new String[2]; if (filename.endsWith(".xls") || filename.endsWith(".xlsx")) { command[0] = "C:/Program Files/Microsoft Office/Office14/EXCEL.EXE"; command[1] = file.toString(); } else if (filename.endsWith(".txt")) { command[0] = "notepad"; command[1] = file.toString(); } else if (filename.endsWith(".doc") || filename.endsWith(".docx")) { command[0] = "C:/Program Files/Microsoft Office/Office14/WINWORD.EXE"; command[1] = file.toString(); } else if (filename.endsWith(".pdf")) { command[0] = "C:/Program Files (x86)/Adobe/Reader 9.0/Reader/AcroRd32.exe"; command[1] = file.toString(); } else if (filename.endsWith(".ppt") || filename.endsWith(".pptx")) { command[0] = "C:/Program Files/Microsoft Office/Office14/POWERPNT.EXE"; command[1] = file.toString(); } else if (filename.endsWith(".zip")) { command[0] = "C:/Program Files/WinRAR/WinRAR.exe"; command[1] = file.toString(); } try { rt.exec(command); } catch (IOException e) { e.printStackTrace(); } } }

package com.gl.excel; import java.io.File; import jxl.Cell; import jxl.Workbook; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; public class Excel { public void modifier(File file, String stuNo) { try { Workbook wb = Workbook.getWorkbook(file); WritableWorkbook book = Workbook.createWorkbook((file), wb); WritableSheet sheet = book.getSheet(0); for (int row = 0; row < sheet.getRows(); row++) { Cell[] cell = sheet.getRow(row); for(int i = 0; i < cell.length; i ++){ if( !cell[i].getContents().matches(stuNo) ||cell[i].getContents().contains("黑龍江中醫藥大學") || cell[i].getContents().contains("開課學期")){ System.out.println(cell[i].getContents());; sheet.removeRow(row); } }//for_cell[i] }//for_row book.write(); book.close(); } catch (Exception e) { e.printStackTrace(); } } public void change(File file, String studentNo) { this.modifier(file,studentNo); } }