点个赞好吗
依赖
<!-- POI(operate excel) start -->
<!-- the version of the following POI packages must be consistent -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml-schemas -->
<!-- the dependent jar package to create .xlsx file -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>3.17</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.xmlbeans/xmlbeans -->
<dependency>
<groupId>org.apache.xmlbeans</groupId>
<artifactId>xmlbeans</artifactId>
<version>2.6.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-collections/commons-collections -->
<dependency>
<groupId>commons-collections</groupId>
<artifactId>commons-collections</artifactId>
<version>3.2.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/dom4j/dom4j -->
<dependency>
<groupId>dom4j</groupId>
<artifactId>dom4j</artifactId>
<version>1.6.1</version>
</dependency>
<!-- POI end -->
代码
private static HSSFWorkbook hssfWorkbook = null;// 创建xls格式的excel
private static XSSFWorkbook xssfWorkbook = null;// 创建xlsx格式的excel
@Test
public void creatXLS() {
List<List<String>> list = new ArrayList<>();// 这是写入excel的数据
List<String> list2 = new ArrayList<>();// 这是第一行
List<String> list3 = new ArrayList<>();// 这是第二行
list2.add("姓名");
list2.add("密码");
list3.add("1");
list3.add("1");
list.add(0, list2);
list.add(1, list3);
xssfWorkbook = new XSSFWorkbook();// 创建excel
XSSFSheet sheet = xssfWorkbook.createSheet("sheet1");// 创建一个工作簿
for (int i = 0; i < list.size(); i++) {// 集合长度为excel的行数
XSSFRow row = sheet.createRow(i);// 创建第i行
for (int j = 0; j < list.get(i).size(); j++) {// 集合长度为excel的列数
XSSFCell cell = row.createCell(j);// 创建第j列
cell.setCellValue(list.get(i).get(j));// 写入数值
}
}
try {
// 输出工作簿
FileOutputStream outputStream = new FileOutputStream("D:\\test\\zzz.xlsx");
xssfWorkbook.write(outputStream);
outputStream.close();// 别忘记关闭
} catch (Exception e) {
e.printStackTrace();
}
}