excel

Collection of parsers and import filters for spreadsheet documents.

English: Python script to collect data from datasets and insert them into a Postgres database via ORM. It can be expanded to extract other data sources (such as PDFs, Word, CSV, etc.) and apply custom functions. It comes with an Excel spreadsheet of the State of Minas Gerais' expenses from 2005-2016 as an example of a dataset for collection.

pt-BR: Script Python para coletar dados de datasets e inserir em um banco de dados Postgres via ORM. Pode ser expandido para extrair outras fontes de dados (como pdf's, word, csv, etc) e aplicar funções customizadas. Acompanha um excel dos gastos do Estado de Minas Gerais do ano de 2005-2016 como exemplo de dataset para a coleta.

English: Python project to extract PDF data from the current directory.

One script transforms the PDF data into a pandas dataframe for eventual conversion to Excel. The other script stores this data in JSON for indexing in a non-relational Elasticsearch database.

pt-BR:Projeto em Python para extração de dados de pdf do diretório atual.

Um script transforma os dados do pdf em pandas dataframe para eventual conversão para excel. O outro script armazena esses dados em JSON para indexar em um banco de dados não relacional Elasticsearch.

Python program to read CSTimer exported file (JSON format) and convert it to Excel

Usage: cstimer2excel.py [filename.txt [sessionname]]

Default filename.txt = cstimer.txt

Default session = loop over all sessions

The output will be an excel sheet containing the raw data and 2 graphs:

one where the X-axis contains the solve number another one where it contains the dates of the solves

DNF are taken into account and the average will be a DNF if not ignored.

Script para coletar dados json de paises, realizar tratamento e salvar dados em um arquivo Excel.

I designed the following utility to facilitate and automate the process of creating evidence and generating an Excel report from a list of emails (in .msg format - Outlook) exchanged with the client as part of project management. The goal is to create a single report containing all the evidence supporting the progress/reporting activities required by the PMO and to provide it to the final client to close the active cycle phase.

Python program to automate the graphing in excel of data generated from a Keysight DAQ (Data Acquisition System)

pyxl-sql is a small implementation of SQL, for excel workbooks, based on openpyxl

2048 Game AI solver made with Python, and GUI with PyGame. Uses NumPy, openpyxl, pandas.

Grist is the evolution of spreadsheets. https://getgrist.com

Mirroring from https://github.com/gristlabs/grist-core

IndyPy: Automate Spreadsheets talk on 2021-10-12. https://meetingplace.io/indypy/events/4798

https://github.com/dimastbk/python-calamine

A tool made with Python and openpyxl to insert raw data in xlsx format inside a custom Excel template using a txt file as guideline.

Python scripts to convert Excel files to CSV or JSON.

Asteria is an open source software that compare two columns inside a sheet in an excel file. The result of this compare is written in an other excel with three diferents sheet (Common Cell, No Common Cells AvsB and No Common Cell BvsA)

Libreria básica para transformar el contenido de un archivo XLSX (o XLS) en QRs que almacenan en formato JSON la información

This project contains the code for the talk at the tekom 2019 in Stuttgart for "Introduction to Python for Technical Communicators"