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

Read ODS files into a pandas DataFrame while preserving direct formatting (bold, italic, underline) as markup (AsciiDoc, Markdown, HTML).

CombineXL: A Python GUI application for merging multiple Excel files into a single master workbook, meticulously preserving all original cell formatting, styles, and merged regions.

SplitXL: A robust utility designed to slice large Excel spreadsheets into smaller, row-based files. It ensures data integrity by perfectly cloning headers, cell styles, and formats into each new chunk.

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

Collect European Banking Authority's (EBA) reporting module data—including Templates—directly from EBA's "Reporting modules by name" page .

MacDirScope: a powerful Python tool for macOS that performs deep scans of any directory to catalog files and folders, extracting extended attributes like Finder tags and exporting the data into a clean, filterable Excel report.

BM2Excel: a Python tool designed to convert browser bookmarks (HTML files) into well-structured and organized Excel spreadsheets.

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

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

Proyecto VBA para comparar listas de productos de diferentes mercados mediante técnicas de procesamiento de texto y algoritmos de similitud (distancia de Levenshtein). Permite identificar coincidencias aproximadas entre nombres de productos, incluso con diferencias en el orden de las palabras o errores tipográficos, y copiar automáticamente los precios correspondientes. Ideal para análisis y conciliación de catálogos de productos en Excel, optimizando procesos manuales y mejorando la precisión en la comparación de datos.

Book: Head First Excel by Michael Milton

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