E

excel

Collection of parsers and import filters for spreadsheet documents.

This repository contains some of the projects and lab assignments I completed during my studies as an aerospace engineering student in ELISA Aerospace. I chose the IMSS program (Missile and Space Systems Engineering), which focused on the field of space (aerodynamics, flight mechanics, launch vehicle architecture, etc.) and numerical simulation (signal processing, materials physics, engineering mathematics, etc.).

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

Desktop app that supports a real-time qPCR lab workflow from sampling until analysis of results. It creates for sample batches ready-to-print Excel sheets for RNA extraction and pipetting to PCR plate, and can analyze real-time qPCR output.

This project is a product sales tracking application designed to monitor and analyze commercial performance. It provides a centralized platform for managing inventory, recording transactions, and generating insights into sales trends to help optimize business growth and revenue management.

This project is an e-commerce payment dashboard designed to monitor and manage financial transactions. It provides a specialized interface for tracking payment statuses, analyzing revenue streams, and overseeing transaction history to ensure secure and efficient payment processing for online businesses.

This project is an e-commerce retail dashboard designed to analyze and manage retail operations. It provides a comprehensive overview of retail performance, focusing on key metrics such as inventory turnover, customer purchasing patterns, and regional sales distribution to help streamline supply chain and storefront management.

This project is a drinks sales dashboard designed to visualize and track beverage industry data. It provides a centralized interface for monitoring sales volume, revenue trends, and inventory levels, enabling businesses to gain actionable insights into consumer preferences and regional performance.

Sistema fullstack de gestión académica para el SENA que permite gestionar estudiantes, programas de formación e inscripciones. Desarrollado con FastAPI (backend) y JavaScript vanilla (frontend), implementa autenticación JWT, encriptación bcrypt, control de acceso por roles (RBAC), validaciones automáticas con Pydantic, y exportación de reportes en PDF/Excel. Base de datos PostgreSQL con SQLAlchemy ORM.

This project is a dedicated e-commerce dashboard designed to visualize and manage business data. It provides a centralized interface for tracking key metrics, streamlining sales monitoring, and improving data-driven decision-making for online retail operations.

Automated batch pipeline for extracting tables from PDF files and converting them to Excel, CSV, or Google Sheets https://pdf2sheets.app

A pandas DataFrame with DataFrame index and columns!

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

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

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/

NetscapeGen: A cross-platform Python GUI utility that converts structured Excel spreadsheets into standard Netscape HTML bookmark files. It automatically detects nested folder hierarchies from spreadsheet columns and generates a universal file compatible for import into Chrome, Firefox, Safari, and Edge.

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.