What's the best practice in modifying/inserting values in specific cells of an existing excel file?

This page summarizes the projects mentioned and recommended in the original post on /r/PHPhelp
Office PHP Spreadsheet XLSX ODS

InfluxDB
Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
Our great sponsors

  • PhpSpreadsheet

    A pure PHP library for reading and writing spreadsheet files

    • The docs directory on their github repository contains a lot of examples on how to read, modify and save spreadsheet files. They also have some documentation on their website.

  • Spout

    Discontinued Read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way

    • If you don't have a lot of formatting requirements beyond just the placement of the data in the correct fields, I really enjoy Box/Spout (https://opensource.box.com/spout/), and they have a way to install it without composer.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
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