package test;
import java.io.File;
import java.sql.Connection;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import org.junit.Test;
import com.teachingaward.util.DB;
/**
*
* @author feng@lu
* 2015-2-23 下午9:18:04
*/
public class JavaExcelTest {
@Test
public void testJXL(){
try{
//new 一个文件数据源对象
File importExcel = new File("C:\\Users\\Administrator\\Desktop\\test.xls");
// Connection conn = DB.getConnection();
//根据文件源获得excel工作薄
Workbook workBook = Workbook.getWorkbook(importExcel);
//获得工作薄的所有工作表
Sheet[] sheet = workBook.getSheets();
int sheet_i_num = 0;
String id="";
String name = "";
//判断工作薄不能为空
if(sheet != null && sheet.length>0){
//循环遍历工作薄的所有工作表
for(int sheetNum = 0; sheetNum < sheet.length; sheetNum++ ){
//获得每个工作表的数据行数
sheet_i_num = sheet[sheetNum].getRows();
//遍历工作表的每行
for(int rowNum=1;rowNum < sheet_i_num; rowNum++){
//获取每一行的列数组
Cell[] cells = sheet[sheetNum].getRow(rowNum);
//根据行索引获得对应的数据
id = cells[0].getContents();
name = cells[1].getContents();
System.out.println("****excel数据****");
System.out.println("id = " + id + " name = "+ name);
}
}
}
}catch (Exception e) {
// TODO: handle exception
System.out.println("*******连接数据库出现异常******"+e);
}
}
}
import java.io.File;
import java.sql.Connection;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import org.junit.Test;
import com.teachingaward.util.DB;
/**
*
* @author feng@lu
* 2015-2-23 下午9:18:04
*/
public class JavaExcelTest {
@Test
public void testJXL(){
try{
//new 一个文件数据源对象
File importExcel = new File("C:\\Users\\Administrator\\Desktop\\test.xls");
// Connection conn = DB.getConnection();
//根据文件源获得excel工作薄
Workbook workBook = Workbook.getWorkbook(importExcel);
//获得工作薄的所有工作表
Sheet[] sheet = workBook.getSheets();
int sheet_i_num = 0;
String id="";
String name = "";
//判断工作薄不能为空
if(sheet != null && sheet.length>0){
//循环遍历工作薄的所有工作表
for(int sheetNum = 0; sheetNum < sheet.length; sheetNum++ ){
//获得每个工作表的数据行数
sheet_i_num = sheet[sheetNum].getRows();
//遍历工作表的每行
for(int rowNum=1;rowNum < sheet_i_num; rowNum++){
//获取每一行的列数组
Cell[] cells = sheet[sheetNum].getRow(rowNum);
//根据行索引获得对应的数据
id = cells[0].getContents();
name = cells[1].getContents();
System.out.println("****excel数据****");
System.out.println("id = " + id + " name = "+ name);
}
}
}
}catch (Exception e) {
// TODO: handle exception
System.out.println("*******连接数据库出现异常******"+e);
}
}
}