how to work with .xlsx files?

This page summarizes the projects mentioned and recommended in the original post on /r/node

Our great sponsors
  • SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SheetJS js-xlsx

    📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs

  • ExcelJS and XLSX (SheetJS) are great libraries to work with XLSX files. The former I've found a bit easier to work with but less efficient in general.

  • excelize

    Go language library for reading and writing Microsoft Excelâ„¢ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets

  • But if you absolutely need xlsx files, I would seek the best library for the job and write this in golang.

  • SurveyJS

    Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

    SurveyJS logo
  • ExcelJS

    Excel Workbook Manager

  • ExcelJS and XLSX (SheetJS) are great libraries to work with XLSX files. The former I've found a bit easier to work with but less efficient in general.

  • ecma-376-5th

    Discontinued ECMA 376 (Office Open XML File Formats), 5th edition

  • You could also parse them yourself. If you read the open documentation on the XLSX format, you'll find it's actually just a collection of ZIP files containing XML formatted files. You can stream the files into Nodejs with an archive parsing library such as yauzl and parse the data using an XML parse such as rgrove/parse-xml

  • yauzl

    yet another unzip library for node

  • You could also parse them yourself. If you read the open documentation on the XLSX format, you'll find it's actually just a collection of ZIP files containing XML formatted files. You can stream the files into Nodejs with an archive parsing library such as yauzl and parse the data using an XML parse such as rgrove/parse-xml

  • parse-xml

    A fast, safe, compliant XML parser for Node.js and browsers.

  • You could also parse them yourself. If you read the open documentation on the XLSX format, you'll find it's actually just a collection of ZIP files containing XML formatted files. You can stream the files into Nodejs with an archive parsing library such as yauzl and parse the data using an XML parse such as rgrove/parse-xml

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts