使用java进行excel读取和写入

2024-05-04 14:56:02| 来源: 网络整理

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中写入内容的类

WriteExcel.java

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 list=new ArrayList(); list.add(dataMap); writeExcel(list, 3, "D:/writeExcel.xlsx"); } public static void writeExcel(List dataList, int cloumnCount,String finalXlsxPath){ OutputStream out = null; try { // 获取总列数 int columnNumCount = cloumnCount; // 读取Excel文档 File finalXlsxFile = new File(finalXlsxPath); Workbook workBook = getWorkbok(finalXlsxFile); // sheet 对应一个工作页 Sheet sheet = workBook.getSheetAt(0); /** * 删除原有数据，除了属性列 */ int rowNumber = sheet.getLastRowNum(); // 第一行从0开始算 System.out.println("原始数据总行数，除属性列：" + rowNumber); for (int i = 1; i

【本文地址】转载请注明　