excel

Collection of parsers and import filters for spreadsheet documents.

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets https://github.com/xuri/excelize

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.

Tool to create an overview of students' grades, attendance, and course access using Excel Online. Currently relies on manual data collection.

Package xlsx implements a simple xlsx library.

Docs reference for the excelize library. https://xuri.me/excelize

Plática "Olvidate de Excel, bienvenido pandas" en Nerdearla México 2024 del 2024-11-07. https://nerdear.la/en/agenda/olvidate-de-excel-bienvenido-pandas/

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.

forked from https://github.com/crcx/Forth-Applications to fix 2 bugs at first and to play/understand the code

Integrations or scripts should not be installed directly on the IP Fabric VM unless directly communicated from the IP Fabric Support or Solution Architect teams. Any action on the Command-Line Interface (CLI) using the root, osadmin, or autoboss account may cause irreversible, detrimental changes to the product and can render the system unusable.

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.

https://mikkcz.gitlab.io/export-emailu-do-excelu/

https://fatihmehmetozcan.gitlab.io/practice-files-pages

Book: Head First Excel by Michael Milton