（java基础）读取Excel文件

首先需要导入jxl.jar包

package jdbc.读取Excel文件;

import java.io.*;
import java.util.*;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;

public class Test {
		
	public static void main(String[] args) throws Exception {
		Map<String,List<String>> map = read("d:/work/FilmTemplate.xls");
		System.out.println(map);
			
	}
	
	public static Map<String,List<String>>read(String path)throws Exception{
		Map<String,List<String>> m = new HashMap<>();
		File file = new File(path);
		FileInputStream fis = new FileInputStream(file);
		Workbook rwb = Workbook.getWorkbook(fis);
		Sheet rs = rwb.getSheet(0);
		for(int j=0;j<rs.getRows();j++) {
			Cell[]cells =rs.getRow(j);
			List<String>list = new ArrayList<String>();
			for(int k=0;k<cells.length;k++) {
				list.add(cells[k].getContents());
			}
			m.put(j+"", list);
		}	
		
		return m;
	}
	
}