如何将二维数组写入Excel?-灵析社区
我爱上班你可以使用java Excel 相关的第三方组件实现 引入Maven依赖： org.apache.poi poi 3.17 org.apache.poi poi-ooxml 3.17 Java将数据写入Excel，把这个方法封装了WriteToExcel import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import java.io.File; import java.io.FileOutputStream; import java.io.IOException; import java.util.ArrayList; import java.util.List; public class WriteToExcel { private static XSSFWorkbook workbook; private static XSSFSheet sheet; private static XSSFRow row; private static XSSFCell cell; private static File file; //创建sheet页 public static void setSheet(String sheetName) { workbook = new XSSFWorkbook(); sheet = workbook.createSheet(sheetName); } //创建表头 public static void createHead(List headList) { //创建表头，也就是第一行 row = sheet.createRow(0); for (int i = 0; i > contentList) { //创建表内容，从第二行开始 for (int i = 0; i > getContent() { List> contentList = new ArrayList(); List content1 = new ArrayList(); content1.add("张三"); content1.add("18"); List content2 = new ArrayList(); content2.add("李四"); content2.add("20"); contentList.add(content1); contentList.add(content2); return contentList; } public static void main(String[] args) { //表头测试数据 List headList = new ArrayList(); headList.add("昵称"); headList.add("年龄"); List> contentList = getContent();//内容测试数据 setSheet("WorkSheet"); //创建sheet页 createHead(headList); //设置表头 createContent(contentList); //设置内容 writeToFile("D://work.xls"); //写入文件 } }