java 写入或读取Excel文件

废话少说，直接上代码

第一步：pom.xml 导入 org.apache.poi包

<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->

<!--.xls-->

<dependency>

<groupId>org.apache.poi</groupId>

<artifactId>poi</artifactId>

<version>5.2.2</version>

</dependency>

<!--.xlsx-->

<dependency>

<groupId>org.apache.poi</groupId>

<artifactId>poi-ooxml</artifactId>

<version>5.2.2</version>

</dependency>

第二步：Java代码

package com.cy.store.util;

import com.cy.store.entity.User;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

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.ss.usermodel.WorkbookFactory;

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.util.ArrayList;

import java.util.List;

public class GetExcel {

// 数据库保存到excel中

public static void saveAsExcel(List<User> list)throws IOException {

Workbook wb = new HSSFWorkbook(); //.xls文件

// Workbook wb = new XSSFWorkbook(); .xlsx文件

Sheet sheet = wb.createSheet();

for(int i=0;i<list.size();i++){

User user = list.get(i);

Row row = sheet.createRow(i);

row.createCell(0).setCellValue(user.getUid());

row.createCell(1).setCellValue(user.getUsername());

row.createCell(2).setCellValue(user.getPassword());

row.createCell(3).setCellValue(user.getPhone());

row.createCell(4).setCellValue(user.getEmail());

}

FileOutputStream outputStream = new FileOutputStream("D://user.xls");

wb.write(outputStream);

outputStream.close();

wb.close();

}

// 读取excel数据

public static List<User> readAsExcel() throws Exception{

Workbook wb = WorkbookFactory.create(new File("d://user.xls"));

List<User> list = new ArrayList<>();

for (Sheet sheet: wb){

for(Row row: sheet){

User user = new User();

Integer uid = (int) row.getCell(0).getNumericCellValue();

String username = row.getCell(1).getStringCellValue();

String password = row.getCell(2).getStringCellValue();

String phone = row.getCell(3).getStringCellValue();

String email = row.getCell(4).getStringCellValue();

user.setUid(uid);

user.setUsername(username);

user.setPassword(password);

user.setPhone(phone);

user.setEmail(email);

list.add(user);

}

}

System.out.println(list);

wb.close();;

return list;

}

}