E

excel

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

Collection of parsers and import filters for spreadsheet documents.

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

Import excel workbooks within a folder to an Access database as tables

Generate a Solidworks part from it's template via Excel

Create a json file with Excel file names and sheet names within a folder

Projects and blog https://fatihmehmetozcan.gitlab.io

Export excel workbooks within a folder as CSV files

Old school snake game in Microsoft Office Excel

An Excel add-in (macro) to search excel files' content within a specified folder

Computer Aided Design programs (Autocad, Catia, SolidWorks) and Excel macros written with Visual Basic for Applications (VBA)

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.