E

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

Book: Head First Excel by Michael Milton

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

Validate your XLSX spreadsheet file before importing it. Export your data to a formatted XLSX spreadsheet with data validation set up.

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