d-band / Better Xlsx
A better xlsx library.
Stars: ✭ 395
Programming Languages
javascript
184084 projects - #8 most used programming language
Projects that are alternatives of or similar to Better Xlsx
Sheetjs
📗 SheetJS Community Edition -- Spreadsheet Data Toolkit
Stars: ✭ 28,479 (+7109.87%)
Mutual labels: excel, xml, xlsx
Filecontextcore
FileContextCore is a "Database"-Provider for Entity Framework Core and adds the ability to store information in files instead of being limited to databases.
Stars: ✭ 91 (-76.96%)
Mutual labels: excel, xml, xlsx
Dbwebapi
(Migrated from CodePlex) DbWebApi is a .Net library that implement an entirely generic Web API (RESTful) for HTTP clients to call database (Oracle & SQL Server) stored procedures or functions in a managed way out-of-the-box without any configuration or coding.
Stars: ✭ 84 (-78.73%)
Mutual labels: excel, xml, xlsx
Meza
A Python toolkit for processing tabular data
Stars: ✭ 374 (-5.32%)
Mutual labels: excel, xml, xlsx
Xresloader
跨平台Excel导表工具(Excel=>protobuf/msgpack/lua/javascript/json/xml)
Stars: ✭ 161 (-59.24%)
Mutual labels: excel, xml, xlsx
XToolset
Typed import, and export XLSX spreadsheet to JS / TS. Template-based create, render, and export data into excel files.
Stars: ✭ 110 (-72.15%)
Mutual labels: excel, xlsx
goxlsxwriter
Golang bindings for libxlsxwriter for writing XLSX files
Stars: ✭ 18 (-95.44%)
Mutual labels: excel, xlsx
ExcelFormulaBeautifier
Excel Formula Beautifer,make Excel formulas more easy to read,Excel公式格式化/美化,将Excel公式转为易读的排版
Stars: ✭ 27 (-93.16%)
Mutual labels: excel, xlsx
Unioffice
Pure go library for creating and processing Office Word (.docx), Excel (.xlsx) and Powerpoint (.pptx) documents
Stars: ✭ 3,111 (+687.59%)
Mutual labels: excel, xlsx
hfexcel
JSON to Excel in Python. 🐍 Human Friendly excel creation in python. 📄 easy, advanced and smart api. json to excel conversion support.. ❤️
Stars: ✭ 16 (-95.95%)
Mutual labels: excel, xlsx
Server-Help
💻 This VSTO Add-In allows the user to ping a list of servers and creates a file for Microsoft Remote Desktop Manager an Excel table. This is used for quickly determining which servers are offline in a list. It is written in 3 different versions as a VSTO Add-In in C# and VB.NET as well as a VBA Add-In.
Stars: ✭ 21 (-94.68%)
Mutual labels: xml, excel
Pyexcelerate
Accelerated Excel XLSX Writing Library for Python 2/3
Stars: ✭ 384 (-2.78%)
Mutual labels: excel, xlsx
svelte-sheets
Blazing fast excel sheets in the browser, hugely inspired by JExcel, built with Svelte and XLSX.
Stars: ✭ 45 (-88.61%)
Mutual labels: excel, xlsx
exoffice
Library to parse common excel formats (xls, xlsx, csv)
Stars: ✭ 31 (-92.15%)
Mutual labels: excel, xlsx
excel validator
Python script to validate data in Excel files
Stars: ✭ 14 (-96.46%)
Mutual labels: excel, xlsx
lisp-xl
Common Lisp Microsoft XLSX (Microsoft Excel) loader for arbitrarily-sized / big-size files
Stars: ✭ 27 (-93.16%)
Mutual labels: excel, xlsx
dbd
dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases.
Stars: ✭ 30 (-92.41%)
Mutual labels: excel, xlsx
Qxlsx
Excel file(*.xlsx) reader/writer library using Qt 5 or 6. Descendant of QtXlsx.
Stars: ✭ 340 (-13.92%)
Mutual labels: excel, xlsx
J
❌ Multi-format spreadsheet CLI (now merged in http://github.com/sheetjs/js-xlsx )
Stars: ✭ 343 (-13.16%)
Mutual labels: excel, xlsx
better-xlsx
A better xlsx lib for read / write / toTable / from Table
Install
$ npm install better-xlsx
Usage
const fs = require('fs');
const xlsx = require('better-xlsx');
const file = new xlsx.File();
const sheet = file.addSheet('Sheet1');
const row = sheet.addRow();
const cell = row.addCell();
cell.value = 'I am a cell!';
cell.hMerge = 2;
cell.vMerge = 1;
const style = new xlsx.Style();
style.fill.patternType = 'solid';
style.fill.fgColor = '00FF0000';
style.fill.bgColor = 'FF000000';
style.align.h = 'center';
style.align.v = 'center';
cell.style = style;
file
.saveAs()
.pipe(fs.createWriteStream('test.xlsx'))
.on('finish', () => console.log('Done.'));
Todo
- [ ] xlsx parser
- [ ] read excel file
- [x] write excel file
- [x] transform html table to excel file html2xlsx
Report a issue
Reference
- http://www.ecma-international.org/publications/standards/Ecma-376.htm
- https://github.com/tealeg/xlsx
Contributors
This project exists thanks to all the people who contribute. [Contribute].
Backers
Thank you to all our backers! 🙏 [Become a backer]
Sponsors
Support this project by becoming a sponsor. Your logo will show up here with a link to your website. [Become a sponsor]
License
better-xlsx is available under the terms of the MIT License.
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].