Python XLSX

Open-source Python projects categorized as XLSX
Edit details

A file with the XLSX file extension is a Microsoft Excel Open XML Format Spreadsheet file. It's a ZIP-compressed, XML-based spreadsheet file.

Topics: Python Excel CSV JSON Spreadsheet
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.
www.influxdata.com
featured

Top 14 Python XLSX Projects

  • XlsxWriter

    A Python module for creating Excel XLSX files.

  • pyexcel

    Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files

    • Project mention: Advice on ETL and Data Sharing work process | /r/ETL | 2023-11-07

    You could try and write some simple python using the pyexcel and pandas libraries. I created a tool as a consultant with these packages that parsed spreadsheets with data from factories from all around the world. They did not lock down the Excel files used to submit data and it made it so much harder. If you go this route, I would recommend starting by putting your data into a SQLite database. Once you have your data in a database, you unlock the power of SQL for pulling reports. Also, you can port the data into a proper database if you ever need to. ChatGPT can probably get you a good chunk of the way there.

  • 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

  • canmatrix

    Converting Can (Controller Area Network) Database Formats .arxml .dbc .dbf .kcd ...

    • Project mention: cantools vs canmatrix | /r/CarHacking | 2023-05-24

    Reading the documentations from Mathworks and from canmatrix which both copy the CANDB++ functionality I understood the following key point:

  • rows

    A common, beautiful interface to tabular data, no matter the format

  • ExportTools.bundle

    Export tools for Plex

  • sheet2dict

    Simple XLSX and CSV to dictionary converter

  • openvasreporting

    OpenVAS Reporting: Convert OpenVAS XML report files to reports

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo

  • dbd

    dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases.

  • pentest2xlsx

    Excel parser for various pentesting tools.

  • convey

    CSV processing and web related data types mutual conversion (by CZ-NIC)

  • QACoverageTool

    Utility to perform tests coverage analysis

  • xlsx_copycull

    A tool for streamlined copying of Microsoft Excel spreadsheets and conditionally deleting certain rows

  • Copy-Word-tables-to-Excel

    Copy Word tables to Excel

  • mobile-strings-converter

    A Python package that converts Android & iOS string files to any supported file type.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Python XLSX related posts

  • Files in plex don't match files in directory

    1 project | /r/PleX | 18 Mar 2023

  • Media file report

    1 project | /r/unRAID | 18 Oct 2022

  • how to export full list of plex collection?

    1 project | /r/radarr | 11 Oct 2022

  • Do you backup EVERYTHING? (media)

    1 project | /r/DataHoarder | 16 Aug 2022

  • Find Your Libraries Average Rotten Tomatoes Score?

    1 project | /r/PleX | 3 May 2022

  • Can you run Plex Media Server on one system, and store media on network drives?

    1 project | /r/PleX | 28 Oct 2021

  • Sort by video bitrate?

    1 project | /r/PleX | 12 Sep 2021
  • A note from our sponsor - SaaSHub
    www.saashub.com | 10 May 2024
    SaaSHub helps you find the best software and product alternatives Learn more →

Index

What are some of the best open-source XLSX projects in Python? This list will help you:

Project Stars
1 XlsxWriter 3,499
2 pyexcel 1,173
3 canmatrix 874
4 rows 861
5 ExportTools.bundle 328
6 sheet2dict 218
7 openvasreporting 115
8 dbd 55
9 pentest2xlsx 27
10 convey 17
11 QACoverageTool 7
12 xlsx_copycull 5
13 Copy-Word-tables-to-Excel 5
14 mobile-strings-converter 3

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com