如何在excel讀取java,讓我們一起來了解一下?
1、首先添加處理excel的依賴jar包。
????????
????????????org.apache.poi
????????????poi
????????????3.16
????????
????????
????????????org.apache.poi
????????????poi-ooxml
????????????3.14
????????
????????
????????
????????????net.sourceforge.jexcelapi
????????????jxl
????????????2.6.10
????????
2、向excel中寫入內容的類。
package?com.li.controller;
import?java.io.File;
import?java.io.FileInputStream;
import?java.io.FileOutputStream;
import?java.io.IOException;
import?java.io.OutputStream;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.ss.usermodel.Cell;
import?org.apache.poi.ss.usermodel.Row;
import?org.apache.poi.ss.usermodel.Sheet;
import?org.apache.poi.ss.usermodel.Workbook;
import?org.apache.poi.xssf.usermodel.XSSFWorkbook;
public?class?WriteExcel?{
????private?static?final?String?EXCEL_XLS?=?"xls";
????private?static?final?String?EXCEL_XLSX?=?"xlsx";
????
????public?static?void?main(String[]?args)?{
????????
????????Map?dataMap=new?HashMap();
????????dataMap.put("BankName",?"BankName");
????????dataMap.put("Addr",?"Addr");
????????dataMap.put("Phone",?"Phone");
????????List