Java简单excel表格，超级简单的方法

点个赞好吗

依赖

<!-- 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();
		}
	}