一道java读取excel文件的问题

来源：百度知道 编辑：UC知道 时间：2024/06/15 19:45:36
我想设计一个打开文件程序，然后让程序读取excel文件。不过下面这个程序编译不通过，而且运行以后也会抛出Java/lang/array index out of bounds exception 异常，请高手帮忙修改一下，谢谢
import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.event.*;
import javax.swing.border.*;
import java.io.*;
import java.lang.*;
import jxl.*;
public class Test {
JFrame frame=new JFrame("");
public Test() {
JButton b1=new JButton("open");
b1.addActionListener(new al());
Container cp=frame.getContentPane();
cp.setLayout(new FlowLayout());
cp.add(b1);
frame.setSize(300,200);
frame.setVisible(true);
}
class al implements ActionListener{
public void actionPerformed(ActionEvent e){
final JFileChooser fc=new JFileChooser();
fc.addChoosableFileFilter(new ExcelFileFilter());
int value=fc.showOpenDialog(null);
try{
if(v

package com.sidi.oa.util;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

/**
* @author (版权归原作者)
* 用于读取excel
*/
public class ExcelReader {
private HSSFWorkbook wb = null;// book [includes sheet]

private HSSFSheet sheet = null;

private HSSFRow row = null;

private int sheetNum = 0; // 第sheetnum个工作表

private int rowNum = 0;

private FileInputStream fis = null;

private File file = null;

public ExcelReader() {
}

public ExcelReader(File file) {
this.file = file;
}

public void setRowNum(int rowNum) {