[html] view plain copy package com.baizhi.test; import java.io.FileInputStream; import java.util.Date; import java.util.List; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; /** * @author Ain * @time 2017年2月12日下午4:39:28 * @TODO */ @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration("classpath:/spring.xml") public class AdminTest { //定义成员变量 @Autowired private MenuDao menuDao; @Autowired private MenuService menuService; @Test public void AdminTest1(){ ApplicationContext ac = new ClassPathXmlApplicationContext("/spring.xml"); AdminDao adminDao = ac.getBean(AdminDao.class); Admin admin = adminDao.checkLogin("admin"); System.out.println(admin); } @Test public void importExcel() throws Exception{ //获取excel文件输入流 FileInputStream inputStream = new FileInputStream("C:\\Users\\Ain\\Desktop\\用户信息.xls"); //通过输入流获取excel Workbook workbook = Workbook.getWorkbook(inputStream); //获取sheet页 Sheet sheet = workbook.getSheet("用户信息"); //获取sheet行数 int rows = sheet.getRows(); //获取sheet列数 int columns = sheet.getColumns(); //遍历获取数据 for (int i = 0; i < rows; i++) { for (int j = 0; j < columns; j++) { Cell cell = sheet.getCell(j,i); //第一个参数: 列索引 第二个参数: 行索引 //获取单元格的内容 String contents = cell.getContents(); System.out.print(contents+ " "); } //打印完一行内容换行 System.out.println(); } workbook.close(); } }
