Aspose Cells for Java 向Excel中写入数据并生成文件

==>Aspose Cells for Java 读取Excel中的数据

利用Aspose向Excel中写入数据

    public static void main(String[] args) {
        // 构造用户列表数据
        List<Usr> usrList = new ArrayList<>();
        usrList.add(new Usr("admin", "123456", "铁蛋", "张三", "男"));
        usrList.add(new Usr("user", "123123", "狗剩", "李四", "女"));
        // 调用Aspose工具类，去除生成的Excel水印
        AsposeUtil.getLicense();
        // 新建一个Excel
        Workbook workbook = new Workbook();
        // 获取所有工作簿
        WorksheetCollection worksheets = workbook.getWorksheets();
        // 获取第一个工作簿
        Worksheet worksheet = worksheets.get(0);
        // 给工作簿设置名称
        worksheet.setName("用户表");
        // 获取工作簿所有的单元格
        Cells cells = worksheet.getCells();
        // 设置表头
        cells.get(0, 0).setValue("用户");
        cells.get(0, 1).setValue("密码");
        cells.get(0, 2).setValue("昵称");
        cells.get(0, 3).setValue("姓名");
        cells.get(0, 4).setValue("性别");
        // 设置写入数据的初始行, 从第二行开始
        int row = 1;
        // 遍历用户列表
        for (Usr usr : usrList) {
            // 设置表数据
            cells.get(row, 0).setValue(usr.getUsername());
            cells.get(row, 1).setValue(usr.getPassword());
            cells.get(row, 2).setValue(usr.getNickname());
            cells.get(row, 3).setValue(usr.getRealname());
            cells.get(row, 4).setValue(usr.getSex());
            row++;
        }
        // 写入完成，设置保存路径
        File file = new File("F:\\Users\\Josh\\Desktop\\", "用户表.xlsx");
        // 输出流，io流自动关闭
        try (OutputStream os = new FileOutputStream(file)) {
            // 写到文件中
            workbook.save(os, workbook.getFileFormat());
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

生成结果：

Usr.java 实体类

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Usr{
    private String username;// 用户
    private String password;// 密码
    private String nickname;// 昵称
    private String realname;// 姓名
    private String sex;     // 性别
}

AsposeUtil.java 工具类

public class AsposeUtil {
    /**
     * 获取license，去水印
     */
    public static boolean getLicense() {
        boolean result = false;
        try {
            String str = "<License> <Data> <Products> <Product>Aspose.Total for Java</Product> <Product>Aspose.Words for Java</Product> </Products> <EditionType>Enterprise</EditionType> <SubscriptionExpiry>20991231</SubscriptionExpiry> <LicenseExpiry>20991231</LicenseExpiry> <SerialNumber>8bfe198c-7f0c-4ef8-8ff0-acc3237bf0d7</SerialNumber> </Data> <Signature>sNLLKGMUdF0r8O1kKilWAGdgfs2BvJb/2Xp8p5iuDVfZXmhppo+d0Ran1P9TKdjV4ABwAgKXxJ3jcQTqE/2IRfqwnPf8itN8aFZlV3TJPYeD3yWE7IT55Gz6EijUpC7aKeoohTb4w2fpox58wWoF3SNp6sK6jDfiAUGEHYJ9pjU=</Signature> </License>";
            InputStream license = new ByteArrayInputStream(str.getBytes());
            License aposeLic = new License();
            aposeLic.setLicense(license);
            result = true;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }
}