# liaochong/myexcel

MyExcel, a new way to operate excel!

Repository: https://github.com/liaochong/myexcel
Canonical: https://ross.abutalabs.com/products/myexcel
Homepage: https://github.com/liaochong/myexcel/wiki
Language: Java
License: Apache-2.0
License Family: permissive
Topics: excel, poi, xlsx, xls, csv
Last push: 2024-11-14T09:23:20+00:00

## Health v2 (maintenance only)
Score: 23/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 8, longevity 100
- inputs: {"age_days": 3193, "days_push": 657, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1649, forks 326 (observed 2026-08-28T04:05:16.785486+00:00)

## What it is
MyExcel is a Java toolkit for importing, exporting, and encrypting Excel files (.xls, .xlsx, .csv) built on top of Apache POI. It uses HTML templates and iterative cell drawing to generate arbitrarily complex spreadsheets with very low memory usage, including an SXSSF mode and producer-consumer export for massive datasets.

## Use cases
- export large datasets to excel in java
- read excel files into java beans with low memory
- generate complex excel reports with merged cells and styling
- convert html templates to xlsx spreadsheets
- export csv files from a list of pojos
- split huge excel exports into zip packages
- encrypt excel workbooks from java

## When to choose
- you need to generate complex excel layouts (merged cells, styles, formulas) without learning POI's API
- you must export or import very large excel files with minimal memory footprint
- you want template-driven excel generation using engines like Freemarker, Beetl, or Thymeleaf
- you need multi-sheet or auto-split zip exports of massive data

## When to avoid
- you are not on the JVM / Java ecosystem
- you need to manipulate existing excel files cell-by-cell rather than generate or read them
- you need rich client-side spreadsheet rendering or editing in a browser
- you prefer a more mainstream, widely-adopted library like Alibaba EasyExcel or Apache POI directly

## Facets
- artifact type: library
- maturity: active
- function: serialization, file-system, csv, developer-tools
- domain: files, spreadsheets, developer-tools, backend
- platform: jvm, cross-platform
- tags: excel, xlsx, xls, poi, spreadsheet, html-templates, low-memory, data-export, data-import

## Member repositories
- liaochong/myexcel (main) score 23

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:16.785486+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:45:09.938404+00:00, confidence not recorded.
  - readme: https://github.com/liaochong/myexcel (fetched 2026-08-28T04:05:16.785486+00:00, sha 145a1facad6a)
  - homepage: https://github.com/liaochong/myexcel/wiki (fetched 2026-08-29T11:18:15.527955+00:00, sha ed2885993b7f)
- Data as of 2026-08-30T08:39:29.467469+00:00.