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() {@Overridepublic 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() {@Overridepublic 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_rowbook.write();book.close();} catch (Exception e) {e.printStackTrace();}}public void change(File file, String studentNo) {this.modifier(file,studentNo);}}