All Projects → liaochong → Myexcel

liaochong / Myexcel

Licence: apache-2.0
MyExcel, a new way to operate excel!

Programming Languages

java
68154 projects - #9 most used programming language

Projects that are alternatives of or similar to Myexcel

Sheetjs
📗 SheetJS Community Edition -- Spreadsheet Data Toolkit
Stars: ✭ 28,479 (+2277.21%)
Mutual labels:  excel, csv, xlsx, xls
dbd
dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases.
Stars: ✭ 30 (-97.5%)
Mutual labels:  csv, excel, xlsx, xls
Tableexport
The simple, easy-to-implement library to export HTML tables to xlsx, xls, csv, and txt files.
Stars: ✭ 781 (-34.81%)
Mutual labels:  excel, csv, xlsx, xls
Rows
A common, beautiful interface to tabular data, no matter the format
Stars: ✭ 739 (-38.31%)
Mutual labels:  excel, csv, xlsx, xls
Easyexcel
快速、简单避免OOM的java处理Excel工具
Stars: ✭ 22,133 (+1747.5%)
Mutual labels:  excel, poi, xlsx, xls
Pyexcel
Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files
Stars: ✭ 902 (-24.71%)
Mutual labels:  excel, csv, xlsx, xls
eec
A fast and lower memory excel write/read tool.一个非POI底层,支持流式处理的高效且超低内存的Excel读写工具
Stars: ✭ 93 (-92.24%)
Mutual labels:  csv, excel, xlsx, xls
exoffice
Library to parse common excel formats (xls, xlsx, csv)
Stars: ✭ 31 (-97.41%)
Mutual labels:  csv, excel, xlsx, xls
J
❌ Multi-format spreadsheet CLI (now merged in http://github.com/sheetjs/js-xlsx )
Stars: ✭ 343 (-71.37%)
Mutual labels:  excel, csv, xlsx, xls
workbook
simple framework for containing spreadsheet like data
Stars: ✭ 13 (-98.91%)
Mutual labels:  csv, xlsx, xls
Fast Excel
🦉 Fast Excel import/export for Laravel
Stars: ✭ 1,183 (-1.25%)
Mutual labels:  excel, csv, xlsx
Sq
swiss-army knife for data
Stars: ✭ 275 (-77.05%)
Mutual labels:  excel, csv, xlsx
Excel4j
✨ Excel operation component based on poi & CSV ✨
Stars: ✭ 305 (-74.54%)
Mutual labels:  excel, poi, csv
Desktopeditors
An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
Stars: ✭ 1,008 (-15.86%)
Mutual labels:  excel, xlsx, xls
Npoi.mapper
Use this tool to import or export data with Excel file. The tool is a convention based mapper between strong typed object and Excel data via NPOI.
Stars: ✭ 348 (-70.95%)
Mutual labels:  excel, xlsx, xls
Meza
A Python toolkit for processing tabular data
Stars: ✭ 374 (-68.78%)
Mutual labels:  excel, csv, xlsx
csv2xls
Put together some CSV files into a single Excel file, in different sheets.
Stars: ✭ 14 (-98.83%)
Mutual labels:  csv, excel, xls
MiniExcel
Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet
Stars: ✭ 996 (-16.86%)
Mutual labels:  csv, excel, xlsx
sheet2dict
Simple XLSX and CSV to dictionary converter
Stars: ✭ 206 (-82.8%)
Mutual labels:  csv, excel, xlsx
Readxl
Read excel files (.xls and .xlsx) into R 🖇
Stars: ✭ 585 (-51.17%)
Mutual labels:  excel, xlsx, xls

MyExcel--Excel操作新方式

Build Status Maven Central License Average time to resolve an issue Percentage of issues still open

使用示例参考请移步:示例

简介 | Brief introduction

MyExcel,是一个集导入、导出、加密Excel等多项功能的工具包。

优点 | Advantages

  • 可生成任意复杂表格:本工具使用迭代单元格方式进行excel绘制,可生成任意复杂度excel,自适应宽度、高度;
  • 零学习成本:使用html作为模板,学习成本几乎为零;
  • 支持常用背景色、边框、字体等样式设置:具体参见文档-样式支持部分;
  • 支持.xls、.xlsx、.csv:支持生成.xls、.xlsx后缀的Excel以及.csv文件;
  • 支持公式导出:支持Excel模板中设置公式,降低服务端的计算量;
  • 支持低内存SXSSF模式:支持低内存的SXSSF模式,可利用极低的内存生成.xlsx;
  • 支持生产者消费者模式导出:支持生产者消费者模式导出,无需一次性获取所有数据,分批获取数据配合SXSSF模式实现真正意义上海量数据导出;
  • 支持多种模板引擎:已内置Freemarker、Groovy、Beetl、Thymeleaf等常用模板引擎Excel构建器(详情参见文档Getting started),推荐使用Beetl模板引擎(Beetl文档);
  • 提供默认Excel构建器,直接输出简单Excel:无需编写任何html,已内置默认模板,可直接根据POJO数据列表输出;
  • 支持一次生成多sheet:以table作为sheet单元,支持一份excel文档中多sheet导出;
  • 支持Excel容量设定:支持设定Excel容量,到达容量后自动新建Excel,可构建成zip压缩包导出;

文档 | Document

https://github.com/liaochong/myexcel/wiki

联系以及问题反馈 | Contact me

如本项目对您有所帮助,烦请点击上方star或者在下方扫码支付任意金额以鼓励作者更好地开发,十分感谢您的关注!

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].