# cloud-coder-report

**Repository Path**: cloud-coder/cloud-coder-report

## Basic Information

- **Project Name**: cloud-coder-report
- **Description**: 操作报表工具类：excel, word, pdf 等
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 4
- **Created**: 2023-12-29
- **Last Updated**: 2025-09-08

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# cloud-coder-report

#### 介绍
操作报表工具类：excel, word, pdf 等
    参考DemoExcelController，
        excel导入支持检验字段 @NotBlank @NotNull等，字典属性不建议加检验
        excel导出支持单元格设置下拉
    
#### 使用说明
1.  cloud-report-easyexcel
封装Excel导入导出操作类 EasyExcelManager
导入支持单元格检验（@ExcelValid(notNull=true, notBlank=true, regexEnum=RegexEnum.birthday, length=50)）
导入检验失败，支持下载加批注的Excel
导出支持生成字典下拉框：下拉框支持单选，多选，级联选择

集成方式：
@EasyExcelScan(value = {"com.geline.statistics", "com.geline.finance"})
@SpringBootApplication(scanBasePackages = {"com.geline","com.ruoyi"})
public class RuoYiApplication {
    //.....
}

@ExcelExport(value = "purchaseDbSum", templateFile = "purchaseDbSum.xlsx", fileName = "采购明细统计-大板.xlsx")
@Getter
@Setter
public class PurchaseDbSumRow implements Serializable {
    //.....
}

-- Excel导入导出配置
easy-excel:
    save-path: '{user.dir}/profile/excel/'
    template-path: '{user.dir}/profile/template/'
    # 查询字典数据，支持树形字典；表参考：sp_data_dict
    dict-select-sql: select id, parent_id, code, name, value, level from sp_data_dict where deleted=0 and code=#{code}

3.  demo-with-mybatis-plus
mybatis-plus集成示例，可以复制代码到自己项目中二次开发

# 使用方式：在 maven/settings.xml中添加如下配置
<!-- 阿里云Maven仓库 -->
<mirror>
  <id>alimaven</id>
  <mirrorOf>central</mirrorOf>
  <name>aliyun maven</name>
  <url>http://maven.aliyun.com/nexus/content/repositories/central/</url>
</mirror>
<!-- 阿里云私有Maven仓库 -->
<mirror>
  <id>2061427-release-0CAuV7</id>
  <name>packages aliyun</name>
  <url>https://packages.aliyun.com/5fe9d2295d32b3c1e44e7c41/maven/2061427-release-0cauv7</url>
  <mirrorOf>*</mirrorOf>
</mirror>

#  引入依赖
<dependency>
  <groupId>com.geline</groupId>
  <artifactId>cloud-report-easyexcel</artifactId>
  <version>1.3.5</version>
</dependency>

2. cloud-report-word
* 上传word文件并转为html localhost:8080/demoWord/upload/{id}
* 下载word文件从html转为  localhost:8080/demoWord/export/{id}
* 查询预览html  GET: localhost:8080/demoWord/getPreviewUrl/{id}
* 删除word相关文件  delete: localhost:8080/demoWord/delete/{id}