SShortSingh.
Back to feed

Automating Monthly Excel Sales Reports with Python and openpyxl

0
·3 views

The openpyxl library lets Python create and edit .xlsx files without requiring Excel to be installed. The tutorial notes that many workplaces still rely on Excel for sales reports, which are often rebuilt manually each month at considerable time cost. It walks through generating a monthly sales workbook with live formulas, a summary sheet, and a chart, using a small dataset whose totals can be verified by hand. A key point is that openpyxl writes formulas but does not calculate them, so values only appear after the file is opened in Excel or LibreOffice. The author also suggests pandas for arithmetic and openpyxl for layout and formatting, and was tested on Python 3.12 with openpyxl 3.1.5.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

Remi and AlmaLinux ship PHP fixes for critical flaws; RHEL and Rocky await patches

Two vulnerabilities, CVE-2026-115560 and CVE-2026-129289, both scored 9.2 on CVSS, were disclosed on November 19, 2026. One affects PHP's session upload progress feature under specific handler configurations, while the other is a request smuggling flaw in PHP-FPM tied to reused FastCGI connections. Remi and AlmaLinux have released fixed or mitigated builds, though AlmaLinux published them without errata, so standard security-only updates may miss them. As of November 20, Red Hat Enterprise Linux and Rocky Linux had no corrected packages available, and no active exploitation had been reported.

0
ProgrammingDEV Community ·

Free interview prep coach plans study around a software engineering interview date

A developer has built a free study tool for software engineers preparing for interviews with limited weekly time. Users enter their interview date, experience level, and available hours, and the app generates a plan leading up to the interview. Coding practice is scheduled by problem pattern using spaced repetition, with timed sessions that combine the problem statement, an editor, and a whiteboard. System design is practised by sketching on a board rather than only reading about it. The project is written in plain ES modules with no framework or build step, carries no pricing or paid tier, and offers a demo that works without an account; it is a working prototype the author uses daily, and feedback on the plan and setup is being requested.

0
ProgrammingDEV Community ·

Raspberry Pi 5, Orange Pi 5 and NVIDIA Jetson Orin Nano Compared for 2026 Developers

Single-board computers have grown from simple Arduino-style projects into hardware capable of real development work, from home labs to edge AI. This guide compares the Raspberry Pi 5, Orange Pi 5 and NVIDIA Jetson Orin Nano across specifications, pricing and performance. The Orange Pi 5 leads in multicore CPU performance and storage speed through native NVMe support, while the Jetson offers far greater GPU and AI compute. The Raspberry Pi 5 is positioned as the most beginner-friendly option thanks to its large software ecosystem and polished operating system. The article concludes that the best choice depends on whether a project prioritizes CPU throughput, GPU acceleration or ease of use.

0
ProgrammingDEV Community ·

Indian Software Engineers Can Move to Japan for IT Jobs and Faster Permanent Residency

Japan's points-based system for skilled professionals can shorten the path to permanent residency from ten years to as little as one, depending on a total score. That score draws on degree, experience, age, Japanese ability and salary, so the job offer an engineer accepts largely determines the timeline. Japan faces a structural IT shortage, with estimates of up to roughly 790,000 workers missing by 2030. India and Japan also agreed in August 2025 to an action plan aiming for over 500,000 people to move in each direction over five years. To qualify for the common Engineer visa, a job must use technical knowledge, and applicants need a relevant degree, a decade of practical experience, or a recognized IT exam, though Indian exams are not on the approved list.