new一个xssfworkbook时出错_使用XSSFWorkbook连接xlsx文件报class not found

packagetabel_using_state;importjava.io.FileInputStream;importjava.io.FileNotFoundException;importjava.io.IOException;importjava.io.InputStream;importjava.util.ArrayList;i...

package tabel_using_state;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.io.InputStream;

import java.util.ArrayList;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class main {

public static void main(String[] args) {

// TODO Auto-generated method stub

String filepath="C:/Users/daqi.jia/Desktop/test.xlsx";

XSSFWorkbook wb;

XSSFCell cell;

XSSFRow row;

XSSFSheet sheet;

ArrayList l1 = null;

ArrayList l2 = null;

try {

wb=new XSSFWorkbook("C:/1.xlsx");

/*

sheet=wb.getSheetAt(0);

for(int i=0;i

{

row=sheet.getRow(i);

System.out.println(""+row.getCell(0)+row.getCell(1));

// l1.add(row.getCell(0).toString());

// l2.add(row.getCell(1).toString());

}

*/

} catch (FileNotFoundException e) {

// TODO Auto-generated catch block

System.out.println("file no exit!");

} catch (IOException e) {

// TODO Auto-generated catch block

System.out.println("连接受阻!");

}

/*

for(int i=0;i

{

System.out.println(""+l1.get(i)+l2.get(i));

}

*/

connection c=new connection();

c.setSQL("20150930", "20151031");

c.run();

System.exit(0);

}

}

展开