Document Awesome

• WOPI - Web Application Open Platform Interface Protocol
  • docs.microsoft.com/en-us/microsoft-365/cloud-storage-partner-program/rest
• Office Open XML
• LibreOffice running natively in the browser via WebAssembly
  • HN

Project	License
nextcloud/server	AGPL
nextcloud/documentserver_community	AGPL
ONLYOFFICE/CommunityServer	GPL
ONLYOFFICE/onlyoffice-owncloud	AGPL
ONLYOFFICE/DocumentServer	AGPL
LibreOffice/core	GPL

mime

• Doc -> Word, Document, Doc, Writer, Pages
• Sheet -> Excel, Table, Spreadsheet, Sheet, Calc, Numbers
• Slide -> PPT, PowerPoint, Slide, Presentation, Impress, Keynote

• wikipedia OpenDocument
• www.iana.org/assignments/media-types/media-types.xhtml

Library

• Java
  • apache/poi
    • Apache-2.0, Java
    • reading and writing Microsoft Office binary and OOXML file formats
• Javascript/NodeJS
  • xmldom/xmldom
    • 用于解析 各种文档
  • handsontable/hyperformula
    • GPLv3
  • mwilliamson/mammoth.js
    • .docx to HTML
  • alalic/docx2html
  • lalalic/docx4js
    • 解析 docx, pptx, xlsx
  • dolanmiu/docx
    • 生成 docx
  • dbashford/textract
    • 文本提取
  • SheetJS/sheetjs
    • Apache-2.0, JS
    • ⚠️ CE 版本 不支持 style/formula/images/graphs/PivotTables
    • 不在 npm SheetJS/sheetjs#2667
    • 开发也不在 Github 上了
  • foliojs
    • foliojs/pdfkit
      • MIT, JavaScript
      • npm
      • PDF 生成
    • fontkit
    • png.js
    • brotli.js
  • alafr/SVG-to-PDFKit
  • mgcrea/node-xlsx
    • based on sheetjs
  • harshankur/officeParser
    • MIT, JS
    • parse text out of any office file
    • docx, pptx, xlsx and odt, odp, ods
  • cantoo-scribe/pdf-lib
    • npm @cantoo/pdf-lib
    • fork of Hopding/pdf-lib
• Golang
  • unidoc/unioffice
    • .docx, .xlsx, .pptx
• PHP
  • PHPOffice/PhpSpreadsheet
• Convert/Parse
  • pandoc
  • VikParuchuri/marker
    • GPLv3, Python
    • PDF to markdown quickly with high accuracy
  • opengovsg/pdf2md
    • by Open Government Products for open.gov.sg
    • fork jzillmann/pdf-to-markdown
  • benbalter/word-to-markdown
    • MIT, Ruby
    • based on LibreOffice
  • opendatalab/magic-doc
    • Apache-2.0, Python
    • based on libreoffice
• FancyGrid/awesome-grid
• 应用
  • kevinschaich/mintable
    • personal finances
• 商业
  • docxtemplater.com
    • CE 版本 open-xml-templating/docxtemplater
      • MIT, GPLv3, JS
      • 只支持 docx/pptx
    • docxtemplater.com/pricing
  • 葡萄城
  • JSpreadsheet
    • JSpreadsheet CE
  • SheetJS Pro
    • SheetJS CE 没有 style/formula 等
  • [ag-grid]

PDF

• Stirling-Tools/Stirling-PDF
  • GPLv3, Java
  • Locally hosted web application that allows you to perform various operations on PDF files
• Reader
  • sumatrapdfreader/sumatrapdf
    • GPLv3, C++, Windows
    • PDF, EPUB, MOBI, CBZ, CBR, FB2, CHM, XPS, DjVu
• Javascript/TyepScript
  • mozilla/pdf.js
    • Apache-2.0, Javascript
    • PDF Reader
    • NPM pdfjs-dist @types/pdfjs-dist
    • ZEISS/react-view-pdf
  • modesty/pdf2json
    • Apache-2.0, JS
    • 使用 @xmldom/xmldom
  • bpampuch/pdfmake
    • MIT, JS
    • structure JSON to PDF
    • pdfmake.org/playground.html
  • pdfkit
• React
  • wojtekmaj/react-pdf
    • MIT, Javascript
    • Viewer
  • diegomura/react-pdf
    • MIT, Javascript
    • Builder
    • for React PDF
      • react-pdf-repl.vercel.app
      • aanckar/react-pdf-tailwind
• Golang
  • go-pdf/fpdf
  • pdfcpu/pdfcpu
    • Apache-2.0, Go
• OFD
  • ofdrw/ofdrw
    • Apache-2.0, Java
  • 商业产品
    • www.suwell.cn/product

Sheet/Excel

• Java
  • alibaba/easyexcel
• Golang
  • qax-os/excelize
• Formula
  • formulajs/formulajs
    • MIT, JS
    • forked from handsontable/formula.js
  • LesterLyu/fast-formula-parser
    • MIT, JS
    • ⚠️ 开发不活跃
    • npm
    • 300kB,83kB
    • Parse and evaluate MS Excel formula in javascript.
  • handsontable/hyperformula
    • GPLv3, TS
  • handsontable/formula-parser
  • Excel Formula Beautifier www.excelformulabeautifier.com
• JS/TyepScript
  • exceljs/exceljs
    • MIT, JS
    • Excel Workbook Manager
    • ⚠️ 项目开发不活跃
      • exceljs/exceljs#2764
    • vs sheetjs
      • 完整样式支持
      • 支持的格式更少
  • sheetjs
    • CE 版本功能限制
      • 不支持 style, image, table, chart
      • 不支持 i18n
      • 不支持 Data Validations, Conditional Formatting
      • 不会对 formula 求值
  • ag-grid
    • MIT, TS, React, Angular, Vue
    • 社区版+企业版
  • jmaister/excellentexport
    • MIT, TS
    • 导出 Excel
  • dream-num/Luckysheet
  • future-architect/cheetah-grid
    • MIT, JS, TS, Vue, React
  • VisActor/VTable
    • MIT, TS, React, Vue
    • by 字节跳动
    • 1.6MB, 400kB
    • npm:@visactor/vtable
  • antvis/S2
    • MIT, TS, React, Vue
    • by AntV
    • npm:@antv/s2
    • 926kB, 256kB
    • deps: gl-matrix, @antv/g
  • handsontable/handsontable
    • license 不允许 商业产品使用
  • myliang/x-spreadsheet
    • MIT, JS
    • ⚠️ 开发不活跃
    • canvas
    • -> wolf-table/table
  • jspreadsheet/ce
    • MIT
  • nhn/tui.grid
  • handsontable/hyperformula
    • GPLv3, TS
  • revolist/revogrid
    • MIT, TS, React, Vue, Svelte, Angular
    • object[] 数据结构
  • 501351981/vue-office
• React Table/Grid/Speadsheet
  • react-data-grid
    • MIT, TS
    • 42kB, 14kB
    • 适用于 object[]
    • 自身功能非常简洁轻量
    • 🌟 首选
    • formula 功能可选
  • react-spreadsheet
    • MIT, TS
    • npm
    • 40kB/12kB
    • 支持 formula
    • 适用于二维数组 - AoA
    • fast-formula-parser, jstat, es-abstract, @linaria/core
    • fast-formula-parser -> chevrotain, jstat - 体积比较大
    • hot-formula-parser -> @handsontable/formulajs - 弃用 迁移为 hyperformula
    • 非常简单易用
    • ⚠️ 注意 - 不推荐使用
      • 功能很少
      • 没有 virtual
    • 依赖的 fast-formula-parser 相对比较大
      • +292kB/83kB
    • 渲染表格内容部分
    • 不支持: Pin, Frozen, Merge, Resize, Span
    • 数据为 matrix - 二维数组
  • glideapps/glide-data-grid
    • MIT, TS
  • nadbm/react-datasheet
    • MIT, JS
  • nick-keller/react-datasheet-grid
    • MIT, TS
    • npm
    • 84kB/22kB
    • 数据为 对象数组
    • 只支持 sticky right 列
    • 不支持 sticky left
    • 使用 @tanstack/react-virtual 作为虚拟滚动
    • deps: react-resize-detector
  • blueprintjs/table
  • ruilisi/fortune-sheet
    • fork Luckysheet
    • rewrite in ts
    • 移除 jQuery，依赖 React/Vue + immer
    • formula fork handsontable/formula-parser
      • @formulajs/formula-parser
    • @fortune-sheet/core
      • 1.6MB/375kB - @formulajs/formulajs, lodash, jstat
    • @fortune-sheet/react
  • silevis/reactgrid
    • MIT, TS
    • npm:@silevis/reactgrid
    • 260kB/70kB
    • 支持: 多人、填充、多选、Column Resize、Column Reorder、Sticky columns and rows、Group
• Wikipedia:Topological sorting

Word/Doc

• NodeJS/Browser
  • docxjs
• 商业

LowCode DataTable

• apitable/apitable
  • AGPLv3, JS, Java
• supabase
• baserow
• nocodb
• rowyio/rowy
  • for Firestore
• gristlabs/grist-core
  • Apache-2.0, TS
  • SQLite

商业

• www.grapecity.com
  • 葡萄城软件（GrapeCity）是一家起源于日本的公司，总部位于日本仙台市。
  • www.grapecity.com.cn/developer/spreadjs
    • adopted by yunnzhangfanng.com
    • @grapecity/spread-excelio
      • SpreadJS JSON <-> XLSX
    • www.grapecity.com.cn/developer/spreadjs/price
      • 个人 - ￥9800 - 1人开发
      • 团队 - ￥29400 - 4人开发
• Ag-Grid
  • www.ag-grid.com/license-pricing
    • AG Grid Enterprise $999/开发者
• Handsontable
  • handsontable.com/pricing
• onlyoffice
  • www.onlyoffice.com/workspace-prices.aspx
• SheetJS Pro
• www.syncfusion.com
  • 价格 www.syncfusion.com/sales/teamlicense
• www.componentsource.com
  • 有一些产品的价格

协议

• 打印
  • TCP/IP, IPX/SPX(支持 NDS), SMB(NetBEUI), LPD, IPP1.1, SNMP, Apple Talk
• 扫描
  • TCP/IP (FTP, SMB, SMTP, WebDAV) (IPv4/IPv6)
  • 邮件、FTP、BOX/硬盘、SMB、TWAIN、WebDAV、USB、Scan Server、Web Service/WSD-Scan、Device Profile for Web Service(DPWS)
• 互联网传真
  • SMTP, POP
• 传真
  • Super G3
  • PTSN
• 参考
  • bizhub C458 A3 彩色多功能复合机
  • percx/Praeda/jobs/MP0020.pl
  • www.konicaminolta.eu/eu-en/software
  • Bye CUPS: Printing with Netcat
    • HN