Tagged articles

264 articles

Page 1 of 3

Apr 27, 2026 · Artificial Intelligence

30 AI Prompts to Double Office Efficiency and End Overtime

The article presents 30 practical AI prompts covering Excel data handling, document drafting, and general productivity tasks, showing how office staff can copy‑paste these commands to automate formula creation, data cleaning, report writing, meeting summarization, and more, dramatically boosting efficiency and reducing overtime.

AIExcelOffice Automation

0 likes · 7 min read

30 AI Prompts to Double Office Efficiency and End Overtime

Java Companion

Apr 25, 2026 · Artificial Intelligence

How OpenAI’s ChatGPT for Excel Lets You Use Plain Language Instead of Complex Formulas

OpenAI’s official ChatGPT for Excel plugin embeds AI directly into Excel, offering natural‑language commands and a suite of AI‑prefixed functions that can generate tables, clean data, extract information, auto‑fill, translate, and even pull financial data, dramatically reducing manual spreadsheet work.

AIAutomationChatGPT

0 likes · 10 min read

How OpenAI’s ChatGPT for Excel Lets You Use Plain Language Instead of Complex Formulas

Top Architect

Mar 27, 2026 · Backend Development

Why FastExcel Is the Next‑Gen High‑Performance Java Excel Library

FastExcel, created after Alibaba stopped updating EasyExcel, offers seamless EasyExcel compatibility, dramatically lower memory usage, and high‑speed read/write for massive Excel files, while being free under the MIT license and backed by a thriving open‑source community that also fuels the AI‑driven database tool Chat2DB.

Chat2DBExcelFastExcel

0 likes · 19 min read

Why FastExcel Is the Next‑Gen High‑Performance Java Excel Library

Top Architect

Dec 28, 2025 · Backend Development

Why FastExcel Is the Next‑Gen High‑Performance Excel Library for Java Developers

FastExcel, a Java library born from the discontinuation of EasyExcel, offers seamless migration, MIT‑licensed open‑source code, and dramatic performance gains for processing massive Excel files, while also introducing innovative features like selective row reading and Excel‑to‑PDF conversion, and it paves the way for the AI‑driven database tool Chat2DB.

Chat2DBExcelFastExcel

0 likes · 18 min read

Why FastExcel Is the Next‑Gen High‑Performance Excel Library for Java Developers

Java Architecture Diary

Dec 8, 2025 · Backend Development

EasyExcel Archived? How FastExcel and Apache Fesod Provide a Modern Java Excel Solution

When Alibaba archived the popular EasyExcel library, developers faced uncertainty about future maintenance, memory usage, and JDK compatibility, prompting the emergence of FastExcel as a drop‑in replacement and the Apache‑incubated Fesod project, which together offer a high‑performance, low‑memory Java Excel processing ecosystem.

Apache FesodExcelFastExcel

0 likes · 10 min read

EasyExcel Archived? How FastExcel and Apache Fesod Provide a Modern Java Excel Solution

Cognitive Technology Team

Dec 6, 2025 · Backend Development

How to Detect and Replace Excel Watermarks with Apache POI in Java

This guide explains how to reliably identify and remove existing watermarks from .xlsx files and then add new, precisely positioned semi‑transparent watermarks using Java's Apache POI library, complete with Maven setup, code examples, and performance tips.

Apache POIExcelFile Processing

0 likes · 10 min read

How to Detect and Replace Excel Watermarks with Apache POI in Java

Senior Tony

Dec 1, 2025 · Databases

How to Efficiently Import 100 Million Excel Rows into MySQL

This article explains how to import a hundred‑million‑row Excel dataset into MySQL by using CSV format, streaming parsers like EasyExcel, batch inserts, asynchronous processing, and partial‑transaction strategies to ensure feasibility, data integrity, and high performance.

Batch InsertExcelStreaming

0 likes · 5 min read

How to Efficiently Import 100 Million Excel Rows into MySQL

Python Programming Learning Circle

Nov 19, 2025 · Fundamentals

How to Merge XLS and XLSX Files by Name Using Python Pandas

This guide explains how to combine a master XLS file with a detailed XLSX file by matching the "Name" column, handling non‑standard headers, skipping index columns, inserting new fields at a specific position, and exporting the merged result using Python, pandas, xlrd, and openpyxl.

Exceldata-mergeopenpyxl

0 likes · 8 min read

How to Merge XLS and XLSX Files by Name Using Python Pandas

Xiao Liu Lab

Oct 23, 2025 · Operations

Automate Nginx Config Audits: Python Script to Export Structured Excel Reports

Learn how a lightweight Python script can automatically parse complex Nginx configuration files, extract upstream, server, and location details, and generate a structured Excel report for easy auditing, analysis, and collaboration, streamlining operations and configuration management.

AutomationConfigurationExcel

0 likes · 9 min read

Automate Nginx Config Audits: Python Script to Export Structured Excel Reports

Code Ape Tech Column

Sep 29, 2025 · Backend Development

How to Speed Up Massive Excel Imports: From POI to EasyExcel and Parallel Inserts

This article details a step‑by‑step optimization of a large‑scale Excel import workflow, covering the transition from raw POI to EasyExcel, caching database lookups, batch INSERT statements, and parallel stream processing to reduce a 100k‑row import from minutes to under two minutes.

ExcelJavaParallelProcessing

0 likes · 13 min read

How to Speed Up Massive Excel Imports: From POI to EasyExcel and Parallel Inserts

Python Crawling & Data Mining

Sep 2, 2025 · Fundamentals

How to Fix Chinese Garbled Text in CSV Files When Opening in Excel with Python

This article explains why Chinese characters become garbled when a CSV file is opened in Excel and provides a simple Python solution—using the UTF‑8‑SIG encoding—to ensure the text displays correctly, along with additional tips for handling CSV data.

CSVExceldata-processing

0 likes · 4 min read

How to Fix Chinese Garbled Text in CSV Files When Opening in Excel with Python

Spring Full-Stack Practical Cases

Aug 20, 2025 · Backend Development

Master Excel Operations in Spring Boot 3 with Fillo: Full Code Guide

Learn how to perform comprehensive Excel CRUD operations in Spring Boot 3 using the Fillo library, covering environment setup, Maven dependency, SELECT, INSERT, UPDATE, DELETE, fuzzy search, distinct queries, and row/column configuration, complete with code snippets and result screenshots.

ExcelFilloJava

0 likes · 9 min read

Master Excel Operations in Spring Boot 3 with Fillo: Full Code Guide

Spring Full-Stack Practical Cases

Jul 18, 2025 · Backend Development

How to Process Excel Files with Spring Batch in Spring Boot 3

This tutorial demonstrates how to use Spring Batch in Spring Boot 3 to read Excel files with PoiItemReader, map rows to Java objects, process and write data, and optimize memory usage by switching to StreamingXlsxItemReader for large datasets, complete with full code examples and configuration details.

ExcelJavaPOI

0 likes · 10 min read

How to Process Excel Files with Spring Batch in Spring Boot 3

Java Captain

Jun 8, 2025 · Backend Development

How to Read Excel Files in Java with Free Spire.XLS – Step-by-Step Guide

This tutorial explains how to automate Excel data extraction in Java using the free Free Spire.XLS library, covering installation, core classes and methods, and detailed code examples for reading a single cell, a cell range, and an entire worksheet, enabling efficient batch processing and integration with other systems.

ExcelJavaSpire.XLS

0 likes · 7 min read

How to Read Excel Files in Java with Free Spire.XLS – Step-by-Step Guide

Java Captain

Jun 8, 2025 · Backend Development

Create Excel Dropdown Lists in Java with Free Spire.XLS

This guide shows how to generate Excel dropdown lists programmatically in Java using the free Spire.XLS library, covering two approaches—direct string arrays and cell‑range data sources—complete with sample code and screenshots.

Dropdown ListExcelJava

0 likes · 6 min read

Create Excel Dropdown Lists in Java with Free Spire.XLS

Test Development Learning Exchange

May 26, 2025 · Fundamentals

16 Practical Python Pandas Scripts for Excel File Processing

This article presents sixteen ready‑to‑use Python pandas examples that cover common Excel tasks such as reading, writing, sheet selection, cleaning, filtering, aggregation, styling, and exporting, providing a concise toolbox for data‑analysis automation.

AutomationDataProcessingExcel

0 likes · 8 min read

16 Practical Python Pandas Scripts for Excel File Processing

Python Programming Learning Circle

May 20, 2025 · Fundamentals

Basic Operations with openpyxl: Workbooks, Sheets, Cells and Advanced Features

This tutorial explains the core concepts of openpyxl—including workbooks, sheets, and cells—demonstrates how to create, open, read, write, style, merge, and manipulate Excel files with Python, and provides complete code examples for generating 2D and 3D charts.

DataProcessingExcelSpreadsheet

0 likes · 11 min read

Basic Operations with openpyxl: Workbooks, Sheets, Cells and Advanced Features

Code Ape Tech Column

May 16, 2025 · Backend Development

Mastering JXLS: Generate Complex Excel Reports with Java

This guide explains how to use the JXLS Java library to create complex, template‑driven Excel reports, covering setup, core concepts like XlsArea, looping, conditional rendering, dynamic grids, merging cells, image insertion, and formula handling with practical code examples.

Backend DevelopmentExcelJava

0 likes · 9 min read

Mastering JXLS: Generate Complex Excel Reports with Java

Java Captain

May 15, 2025 · Backend Development

Generating Temperature Line Charts in Excel with Apache POI (Java)

This tutorial demonstrates how to add Apache POI dependencies via Maven and use Java code to create an Excel workbook containing a multi‑series temperature line chart, including custom font sizes for titles and axes, and finally export the file to disk.

Apache POIData visualizationExcel

0 likes · 8 min read

Generating Temperature Line Charts in Excel with Apache POI (Java)

Code Mala Tang

May 1, 2025 · Artificial Intelligence

Boost Excel Mastery with 6 Powerful ChatGPT Prompts

This guide reveals six expertly crafted ChatGPT prompts that help you understand Excel functions, create step‑by‑step usage guides, generate commands, write VBA macros, tackle complex tasks, and turn ChatGPT into a versatile Excel assistant, empowering both beginners and advanced users.

AI promptsChatGPTExcel

0 likes · 5 min read

Boost Excel Mastery with 6 Powerful ChatGPT Prompts

Python Crawling & Data Mining

Apr 20, 2025 · Fundamentals

Add a Real‑Time Progress Bar to Your Python Excel Merge Script

This article shows how to integrate a tqdm progress bar into a Python script that reads multiple Excel files with pandas, concatenates them, and writes the combined result, providing clear code examples and screenshots of the before‑and‑after output.

ExcelPythondata-processing

0 likes · 4 min read

Add a Real‑Time Progress Bar to Your Python Excel Merge Script

Python Programming Learning Circle

Apr 7, 2025 · Fundamentals

Python Excel Automation: Using xlrd, xlwt, and xlutils for Reading, Writing, and Modifying Excel Files

This article provides a comprehensive guide to Python Excel automation, comparing nine Excel libraries, and offering step‑by‑step tutorials with code examples for reading with xlrd, writing with xlwt, and copying/modifying workbooks with xlutils, including installation commands and formatting techniques.

AutomationDataProcessingExcel

0 likes · 14 min read

Python Excel Automation: Using xlrd, xlwt, and xlutils for Reading, Writing, and Modifying Excel Files

Lobster Programming

Apr 3, 2025 · Databases

How to Quickly Generate Batch SQL Statements Using Excel

This tutorial explains how to import data into Excel, craft formulas that concatenate cell values into UPDATE or INSERT SQL statements, and drag the formulas down to produce batch SQL commands for efficient database operations.

Batch ProcessingExcelSQL

0 likes · 2 min read

How to Quickly Generate Batch SQL Statements Using Excel

Test Development Learning Exchange

Mar 17, 2025 · Fundamentals

Python Script for Batch Generating Screenshots of All Sheets in Excel Files

This guide explains how to install required libraries and use a Python script that leverages pandas and excel2img to automatically capture high‑resolution screenshots of every worksheet in multiple Excel files, streamlining batch processing and boosting productivity.

AutomationBatchProcessingExcel

0 likes · 4 min read

Python Script for Batch Generating Screenshots of All Sheets in Excel Files

Open Source Tech Hub

Mar 12, 2025 · Backend Development

Master Excel File Manipulation in PHP with PhpSpreadsheet: Quick Start Guide

This guide introduces PhpSpreadsheet, a pure‑PHP library for reading and writing various spreadsheet formats, explains how to install it via Composer, and provides step‑by‑step code examples for creating, styling, and reading Excel files, including supported formats and configuration tips.

ComposerExcelPHP

0 likes · 5 min read

Master Excel File Manipulation in PHP with PhpSpreadsheet: Quick Start Guide

Test Development Learning Exchange

Mar 10, 2025 · Backend Development

Types of API Documentation and Their Appropriate Use Cases

This article explains the main types of API documentation—Swagger, Word, Excel, and PDF—describing their features, suitable scenarios, and how to convert between formats to improve API development and testing efficiency.

APIDocumentationExcel

0 likes · 4 min read

Types of API Documentation and Their Appropriate Use Cases

21CTO

Mar 5, 2025 · Fundamentals

Boost Your Productivity: 5 Powerful Python Automation Techniques

Learn how to use Python to automate file management, web scraping, email sending, spreadsheet processing, and scheduled tasks, saving time and reducing repetitive work with concise code examples.

EmailExcelPython

0 likes · 7 min read

Boost Your Productivity: 5 Powerful Python Automation Techniques

Python Crawling & Data Mining

Mar 3, 2025 · Fundamentals

5 Practical Pandas Techniques to De‑duplicate Time‑Stamped Excel Data

This article demonstrates five pandas‑based methods for extracting unique hourly records from an Excel file, showing how to manipulate datetime columns, drop duplicates, and save the cleaned data, while comparing the strengths and pitfalls of each approach.

ExcelPythondata cleaning

0 likes · 9 min read

5 Practical Pandas Techniques to De‑duplicate Time‑Stamped Excel Data

Test Development Learning Exchange

Feb 11, 2025 · Fundamentals

Master Data Cleaning in Pandas: 20 Essential Scripts for E‑Commerce Sales Analysis

This guide walks you through creating a sample e‑commerce sales Excel file with Pandas and then demonstrates twenty practical data‑cleaning and transformation scripts—including handling missing values, renaming columns, filtering, grouping, and exporting—so you can efficiently prepare sales data for analysis.

Exceldata analysisdata cleaning

0 likes · 9 min read

Master Data Cleaning in Pandas: 20 Essential Scripts for E‑Commerce Sales Analysis

Selected Java Interview Questions

Feb 7, 2025 · Backend Development

FastExcel: High‑Performance Java Excel Read/Write Library – Features, Usage, and Comparison with EasyExcel

FastExcel is a high‑performance Java library that extends EasyExcel, offering streamlined APIs, streaming read/write, event listeners, and PDF conversion, enabling developers to efficiently handle large Excel files with low memory usage in enterprise applications.

BackendDataProcessingExcel

0 likes · 8 min read

FastExcel: High‑Performance Java Excel Read/Write Library – Features, Usage, and Comparison with EasyExcel

Test Development Learning Exchange

Feb 6, 2025 · Fundamentals

Master Bulk Excel Automation with Python: Merge, Filter, Format & More

Learn a collection of Python scripts that automate common Excel operations—including merging multiple files, find‑and‑replace, filtering rows, adding formulas, adjusting formats, extracting images, and encrypting workbooks—providing step‑by‑step code examples for efficient data processing.

AutomationDataProcessingExcel

0 likes · 20 min read

Master Bulk Excel Automation with Python: Merge, Filter, Format & More

macrozheng

Jan 24, 2025 · Backend Development

Boost Java Excel Performance with FastExcel: Features, Usage, and Comparison

This article introduces FastExcel, an upgraded Java library for high‑performance Excel read/write, outlines its key features, provides step‑by‑step code examples for entity creation, event listeners, writing, reading, PDF conversion, compares it with EasyExcel, and concludes with its suitability for large‑scale data processing.

ExcelFastExcelPDF

0 likes · 8 min read

Boost Java Excel Performance with FastExcel: Features, Usage, and Comparison

Code Ape Tech Column

Jan 24, 2025 · Backend Development

FastExcel: High‑Performance Java Library for Excel Read/Write – Features, Usage, and Comparison with EasyExcel

FastExcel is a Java library that builds on EasyExcel to provide higher performance, low‑memory streaming, and additional features such as PDF conversion, offering simple APIs, full compatibility, and detailed code examples for creating entity classes, listeners, and read/write operations.

ExcelFastExcelJava

0 likes · 9 min read

FastExcel: High‑Performance Java Library for Excel Read/Write – Features, Usage, and Comparison with EasyExcel

Python Crawling & Data Mining

Jan 22, 2025 · Fundamentals

5 Practical Pandas Techniques to Remove Duplicate Hours from Excel Data

This article demonstrates five pandas-based methods for extracting unique date‑hour records from an Excel file, explaining how to drop duplicates, reset minutes and seconds, floor timestamps, reformat dates, and use openpyxl for custom extraction.

ExcelPythondata cleaning

0 likes · 8 min read

5 Practical Pandas Techniques to Remove Duplicate Hours from Excel Data

Python Programming Learning Circle

Jan 20, 2025 · Fundamentals

Using Python pandas to Replicate Excel Functions: VLOOKUP, Pivot Tables, and Plotting

This article demonstrates how to replace common Excel operations such as VLOOKUP, data pivot tables, and charting with Python's pandas and plotly libraries, providing code examples, explanations of data import/export settings, and performance considerations for large‑scale data analysis.

ExcelPythonVLOOKUP

0 likes · 14 min read

Using Python pandas to Replicate Excel Functions: VLOOKUP, Pivot Tables, and Plotting

Architecture Digest

Jan 19, 2025 · Backend Development

FastExcel: High‑Performance Java Excel Read/Write Library – Features, Usage, and Comparison with EasyExcel

FastExcel is a Java library that builds on EasyExcel to provide high‑performance, low‑memory Excel read/write, stream processing, PDF conversion and a simple API, with detailed usage examples, code snippets, and a comparison of its advantages over EasyExcel.

DataProcessingExcelFastExcel

0 likes · 8 min read

Python Programming Learning Circle

Jan 10, 2025 · Fundamentals

Automating HR Data Processing with Python: Reading Excel, Extracting Birthdates, and Calculating Date Differences

This article demonstrates how to use Python to read and write Excel files, extract birth dates from Chinese ID numbers, and compute the time interval between dates, providing a practical example for automating HR data handling.

AutomationExcelHR

0 likes · 3 min read

Automating HR Data Processing with Python: Reading Excel, Extracting Birthdates, and Calculating Date Differences

Architect's Guide

Jan 3, 2025 · Big Data

Efficient Import and Export of Millions of Records Using POI and EasyExcel in Java

This article explains how to handle massive Excel‑DB import/export tasks in Java by comparing POI workbook types, selecting the right implementation, and leveraging EasyExcel with batch queries, sheet splitting, and JDBC batch inserts to process over three million rows efficiently.

Big DataExcelJava

0 likes · 24 min read

Efficient Import and Export of Millions of Records Using POI and EasyExcel in Java

Python Crawling & Data Mining

Dec 27, 2024 · Fundamentals

How to Dynamically Update Excel Cells with Pandas: A Flexible Python Solution

This article walks through a Python community member's Excel automation issue, explains how to build a pandas mask to target specific rows, and provides a reusable function that writes a custom value into the desired cell based on flexible keyword arguments.

AutomationExcelPython

0 likes · 6 min read

How to Dynamically Update Excel Cells with Pandas: A Flexible Python Solution

macrozheng

Dec 25, 2024 · Backend Development

FastExcel: The New Java Library Replacing EasyExcel for High‑Performance Excel Processing

FastExcel, a Java‑based open‑source library announced after EasyExcel's discontinuation, offers fast, memory‑efficient Excel read/write, full compatibility with EasyExcel, simple APIs, MIT licensing for commercial use, easy Maven/Gradle integration, and clear code examples that have already attracted over 2,000 GitHub stars.

ExcelFastExcelGradle

0 likes · 8 min read

FastExcel: The New Java Library Replacing EasyExcel for High‑Performance Excel Processing

Architecture Digest

Dec 24, 2024 · Backend Development

FastExcel: The Successor to EasyExcel – Features, Migration Guide, and Code Samples

FastExcel, the newly renamed successor to EasyExcel, offers high‑performance Excel read/write, full compatibility, new features like row‑specific reading and PDF conversion, and provides detailed migration instructions with Maven/Gradle dependencies and code examples for Java developers.

ExcelFastExcelGradle

0 likes · 9 min read

FastExcel: The Successor to EasyExcel – Features, Migration Guide, and Code Samples

Top Architect

Dec 23, 2024 · Backend Development

FastExcel: High‑Performance Java Excel Library – Features, Migration Guide and Usage Examples

The article announces the rebranding of EasyExcel‑Plus to FastExcel, outlines its high‑performance features, provides migration instructions and code samples for Maven and Gradle, and additionally promotes a ChatGPT community and related services.

ExcelFastExcelGradle

0 likes · 10 min read

FastExcel: High‑Performance Java Excel Library – Features, Migration Guide and Usage Examples

Su San Talks Tech

Dec 21, 2024 · Backend Development

Why FastExcel Is the Next‑Gen Java Excel Library After EasyExcel’s Sunset

The article announces EasyExcel's shift to maintenance mode, introduces its successor FastExcel with high‑performance features, and provides detailed migration steps, dependency configurations, and code examples for reading and writing Excel files in Java.

ExcelFastExcelGradle

0 likes · 8 min read

Why FastExcel Is the Next‑Gen Java Excel Library After EasyExcel’s Sunset

Python Programming Learning Circle

Dec 16, 2024 · Fundamentals

Python Tutorial: Working with Excel, Word, and CSV Files Using xlrd/xlwt/xlutils, python-docx, and csv Modules

This comprehensive guide demonstrates how to read, write, modify, and format Excel, Word, and CSV files in Python using libraries such as xlrd/xlwt/xlutils for Excel, python-docx for Word, and the built‑in csv module, complete with code examples and feature comparison tables.

CSVExcelFile Processing

0 likes · 22 min read

Python Tutorial: Working with Excel, Word, and CSV Files Using xlrd/xlwt/xlutils, python-docx, and csv Modules

Test Development Learning Exchange

Dec 16, 2024 · Big Data

Overview of Popular Python Libraries for Data Processing and Excel Manipulation

This article introduces five widely used Python libraries—Pandas, OpenPyXL, XlsxWriter, Tablib, and Dask—detailing their installation commands, core features for handling structured and large‑scale data, and practical code examples for reading, writing, and processing Excel and CSV files.

ExcelPythondask

0 likes · 8 min read

Overview of Popular Python Libraries for Data Processing and Excel Manipulation

Python Programming Learning Circle

Dec 5, 2024 · Fundamentals

Python Task Automation: File Renaming, Email Sending, Excel Processing, and Scheduling

This article introduces Python task automation, demonstrating how to batch rename files, send emails, process Excel spreadsheets, and schedule recurring jobs using standard libraries and third‑party modules, while providing best‑practice tips and hands‑on exercises for efficient scripting.

AutomationEmailExcel

0 likes · 9 min read

Python Task Automation: File Renaming, Email Sending, Excel Processing, and Scheduling

Python Programming Learning Circle

Nov 19, 2024 · Fundamentals

Python Script for Analyzing Lottery Historical Data and Generating Excel Reports

This article demonstrates how to fetch historical lottery data for two games, apply a custom matching rule to identify purchase opportunities, analyze consecutive win patterns over 100 days, and export the aggregated results to an Excel file using Python's requests, xlwt, and basic data‑processing techniques.

AutomationExcelLottery

0 likes · 14 min read

Python Script for Analyzing Lottery Historical Data and Generating Excel Reports

IT Services Circle

Nov 11, 2024 · Backend Development

EasyExcel Enters Maintenance Mode and Launches New EasyExcel-Plus Project

The EasyExcel Java Excel library, known for its low memory usage and fast processing, has entered maintenance mode while its author announced a new project, EasyExcel-Plus, promising enhanced performance, expanded data format support, and continued open‑source development.

ExcelJavadata-processing

0 likes · 3 min read

EasyExcel Enters Maintenance Mode and Launches New EasyExcel-Plus Project

Architecture Digest

Nov 8, 2024 · Backend Development

The Evolution of EasyExcel: From Alibaba’s Internal Tool to the Upcoming EasyExcel‑Plus

This article chronicles the birth, technical innovations, open‑source journey, and community impact of Alibaba’s EasyExcel library, explains its memory‑optimized streaming design with a concise code example, and announces the forthcoming EasyExcel‑Plus project along with a free book giveaway.

ExcelJavaOpenSource

0 likes · 7 min read

The Evolution of EasyExcel: From Alibaba’s Internal Tool to the Upcoming EasyExcel‑Plus

Test Development Learning Exchange

Nov 7, 2024 · Fundamentals

40 Essential Python pandas Scripts for Excel Data Processing

This article compiles 40 practical Python pandas scripts covering Excel file reading, sheet selection, date parsing, column manipulation, data filtering, sorting, grouping, merging, pivot tables, visualization, cleaning, and advanced operations, providing clear examples and output for each step to help data analysts efficiently handle tabular data.

ExcelPythonpandas

0 likes · 17 min read

40 Essential Python pandas Scripts for Excel Data Processing

Model Perspective

Nov 5, 2024 · Fundamentals

How to Build Accurate Sales Forecasts in Excel Using Linear and Multivariate Regression

Learn how to use Excel for mathematical modeling by walking through step‑by‑step case studies that build linear and multivariate regression models to forecast product sales, validate results, and explore additional Excel tools such as Solver and PivotTables.

ExcelMultivariate Regression

0 likes · 8 min read

How to Build Accurate Sales Forecasts in Excel Using Linear and Multivariate Regression

Test Development Learning Exchange

Nov 1, 2024 · Fundamentals

Processing Multiple Excel Files with Python pandas and openpyxl

This guide demonstrates how to install pandas and openpyxl, then use Python to read, merge, batch‑process, extract, clean, rename sheets, export to CSV, and analyze data across multiple Excel files, providing complete code examples for each task.

AutomationExceldata-processing

0 likes · 12 min read

Processing Multiple Excel Files with Python pandas and openpyxl

Python Crawling & Data Mining

Oct 26, 2024 · Databases

Export MongoDB Data to CSV, Excel, JSON and More with mongo2file

This article introduces the mongo2file Python library that converts MongoDB collections into various table formats such as CSV, Excel, JSON, Pickle, Feather, and Parquet, explains its PyArrow dependency, shows installation and usage examples, discusses performance bottlenecks, and provides API reference details.

CSVData ExportExcel

0 likes · 11 min read

Export MongoDB Data to CSV, Excel, JSON and More with mongo2file

Test Development Learning Exchange

Oct 19, 2024 · Fundamentals

Python Libraries for CSV and Excel File Processing: csv, openpyxl, pandas, xlsxwriter, and More

This guide introduces and compares several Python libraries—including csv, openpyxl, pandas, xlsxwriter, pyexcel, xlrd/xlwt, xlutils, tablib, ezodf, xlwings, and readxl—detailing their purposes, key features, typical use cases, installation commands, and example code for reading and writing CSV and Excel files.

Exceldata-processingopenpyxl

0 likes · 21 min read

Python Libraries for CSV and Excel File Processing: csv, openpyxl, pandas, xlsxwriter, and More

Rare Earth Juejin Tech Community

Oct 19, 2024 · Frontend Development

Web Tool for Comparing Commute Distances Using AMap API, Vue, and ECharts

This article describes a personal project that automates the calculation of commuting distances and times between multiple residential areas and two workplace locations by leveraging the AMap API within a Vue‑based frontend, generating Excel reports and visual charts for easy comparison.

APIAmapECharts

0 likes · 18 min read

Web Tool for Comparing Commute Distances Using AMap API, Vue, and ECharts

Test Development Learning Exchange

Oct 16, 2024 · Fundamentals

Master Excel Automation with Python: 20 Practical Pandas & Openpyxl Techniques

This step‑by‑step guide shows how to generate a sample Excel file and then use pandas and openpyxl to read, write, update, filter, sort, group, format, chart, and finally save Excel workbooks, covering twenty essential operations for data automation.

AutomationExcelPython

0 likes · 12 min read

Master Excel Automation with Python: 20 Practical Pandas & Openpyxl Techniques

Python Crawling & Data Mining

Oct 16, 2024 · Fundamentals

How to Convert a Python List into an Excel Column: Two Simple Methods

This article shows how to turn a Python list with many elements into the first column of an Excel sheet by presenting two practical solutions—one using openpyxl and another leveraging pandas—complete with code examples and step‑by‑step explanations.

ExcelPythonlist to column

0 likes · 5 min read

How to Convert a Python List into an Excel Column: Two Simple Methods

Software Development Quality

Oct 5, 2024 · Fundamentals

Choosing the Right Data Analysis Tool: Excel, BI, R, Python & More

This guide compares the strengths and weaknesses of common data analysis tools—from basic spreadsheet software and multi‑dimensional tables to professional statistical packages, BI platforms, and programming languages like R and Python—helping readers select the most suitable solution for their needs.

BI ToolsExcelPython

0 likes · 8 min read

Choosing the Right Data Analysis Tool: Excel, BI, R, Python & More

Python Crawling & Data Mining

Oct 4, 2024 · Fundamentals

Understanding Python Class vs Instance Variables: A Clear Guide

This article walks through a fan’s question about Python class and instance variables, explains their differences with examples, and also introduces a ChatGPT‑powered guide for mastering Excel, highlighting key features and how to obtain the free e‑book collection.

ChatGPTClass VariablesExcel

0 likes · 7 min read

Understanding Python Class vs Instance Variables: A Clear Guide

Test Development Learning Exchange

Oct 3, 2024 · Fundamentals

Processing Excel Files in Python with openpyxl and pandas: Reading, Writing, Styling, and Merging

This article explains how to use Python's openpyxl and pandas libraries to read, write, style, and merge Excel files, covering installation, basic operations, advanced cell formatting, data manipulation, and techniques for combining multiple sheets or workbooks into a single DataFrame.

Exceldata-processingopenpyxl

0 likes · 9 min read

Processing Excel Files in Python with openpyxl and pandas: Reading, Writing, Styling, and Merging

Python Crawling & Data Mining

Sep 23, 2024 · Fundamentals

Why Does xlwings .pictures.add Fail? Fixing Python Image Insertion into Excel

This article walks through a Python community Q&A where a user’s xlwings code fails to insert a chart image into Excel, explains that using an absolute file path or passing the figure object directly resolves the error, and shares the final working solution.

Data visualizationExcelPython

0 likes · 5 min read

Why Does xlwings .pictures.add Fail? Fixing Python Image Insertion into Excel

Test Development Learning Exchange

Sep 6, 2024 · Fundamentals

Python Pandas Examples for Reading, Filtering, Sorting, Merging, De‑duplicating, Pivoting, Analyzing, Plotting, Formatting, and Conditional Formatting of Excel Data

This article provides a series of Python pandas code snippets that demonstrate how to read, filter, sort, merge, remove duplicates, create pivot tables, perform statistical analysis, generate charts, apply formatting, and add conditional formatting to Excel files.

Exceldata-analysisdata-processing

0 likes · 5 min read

Python Pandas Examples for Reading, Filtering, Sorting, Merging, De‑duplicating, Pivoting, Analyzing, Plotting, Formatting, and Conditional Formatting of Excel Data

Test Development Learning Exchange

Aug 13, 2024 · Fundamentals

Comprehensive Guide to Excel Data Processing with Pandas in Python

This article provides a step‑by‑step tutorial for reading, filtering, summarizing, grouping, sorting, comparing, merging, cleaning, reshaping, aggregating, and writing Excel data using Python's pandas library, covering a wide range of common data‑processing tasks with complete code examples.

Exceldata-processing

0 likes · 12 min read

Open Source Tech Hub

Aug 7, 2024 · Backend Development

Boost PHP Excel Performance with the High‑Speed xlswriter Extension

The article introduces xlswriter, a high‑performance PHP C extension for reading and writing Excel 2007+ XLSX files across major operating systems, compares it with PHPExcel, presents benchmark results, explains PECL installation, and provides detailed code examples for exporting, importing, and chart generation.

Data ExportExcelPECL

0 likes · 7 min read

Boost PHP Excel Performance with the High‑Speed xlswriter Extension

Volcano Engine Developer Services

Aug 6, 2024 · Artificial Intelligence

How an AI-Powered Bot Turns Excel Files into Interactive Reports

This article introduces an AI‑driven Smart Report Assistant Bot that automatically converts uploaded Excel files into recommended charts, allows users to customize reports, and details the underlying workflow—including Excel parsing, LLM‑generated SQL, dynamic table creation, chart rendering with ECharts, and image‑merging plugins.

AIBotECharts

0 likes · 8 min read

How an AI-Powered Bot Turns Excel Files into Interactive Reports

Test Development Learning Exchange

Aug 4, 2024 · Fundamentals

Using Python to Read Excel Files and Create Various Charts with Matplotlib

This article demonstrates how to read Excel data with Python's pandas library and generate a range of visualizations—including line, bar, pie, scatter, box, histogram, subplot, heatmap, jointplot, and violin plots—using matplotlib and seaborn, with step-by-step code examples and required package installations.

ExcelMatplotlibSeaborn

0 likes · 9 min read

Using Python to Read Excel Files and Create Various Charts with Matplotlib

Test Development Learning Exchange

Jul 16, 2024 · Fundamentals

Comparing Multiple Sheets in Two Excel Files Using Python Pandas

This guide walks you through installing pandas and openpyxl, reading all sheets from two Excel workbooks, comparing matching sheets to identify differences, analyzing those differences, and saving the results to a new Excel file, with a complete code example provided.

Exceldata-analysisdata-comparison

0 likes · 5 min read

Comparing Multiple Sheets in Two Excel Files Using Python Pandas

Python Crawling & Data Mining

Jul 16, 2024 · Fundamentals

How to Split and Extract Numeric Data from Complex Excel Columns Using Pandas

This article walks through a real‑world Python data‑processing problem where a messy Excel column is parsed into separate numeric fields, presenting two Pandas solutions—one using regular expressions and another using string splitting—along with complete code examples and practical tips.

Data ExtractionExcelPython

0 likes · 5 min read

How to Split and Extract Numeric Data from Complex Excel Columns Using Pandas

Test Development Learning Exchange

Jul 15, 2024 · Backend Development

Building a Python Tkinter GUI to Compare Two Excel Files

This tutorial explains how to set up a Python environment, create a Tkinter graphical interface, and use pandas and openpyxl to let users select and compare two Excel files, displaying any differences directly in the application.

ExcelGUITkinter

0 likes · 6 min read

Building a Python Tkinter GUI to Compare Two Excel Files

Test Development Learning Exchange

Jul 13, 2024 · Fundamentals

Styling Excel Cells with Python openpyxl: A Comprehensive Guide

This tutorial demonstrates how to use Python's openpyxl library to apply fonts, borders, fills, alignments, number formats, conditional formatting, merged cells, dimensions, hyperlinks, and combined styles to Excel worksheets, providing full example code for each feature.

ExcelStylingTutorial

0 likes · 7 min read

Styling Excel Cells with Python openpyxl: A Comprehensive Guide

Python Programming Learning Circle

Jul 11, 2024 · Fundamentals

Critical Review of Python in Excel: Limitations, Use Cases, and Recommendations

The article provides a detailed technical analysis of Microsoft’s preview‑only Python in Excel feature, outlining its current capabilities, major limitations such as lack of VBA replacement, restricted package usage, cloud‑dependency, and workflow friction, while suggesting improvements and alternative approaches for data‑centric users.

AutomationAzureExcel

0 likes · 16 min read

Critical Review of Python in Excel: Limitations, Use Cases, and Recommendations

Test Development Learning Exchange

Jul 8, 2024 · Backend Development

The Power of Excel Decorators in Python: Theory and Practical Examples

This article explains how Python decorators can enhance Excel data handling by providing use‑cases such as validation, error handling, logging, performance optimization, multithreading, and permission checks, and demonstrates each scenario with clear, runnable code examples.

Exceldata-processingdecorators

0 likes · 7 min read

The Power of Excel Decorators in Python: Theory and Practical Examples

Test Development Learning Exchange

Jul 4, 2024 · Fundamentals

Parameterized Excel Data Processing with Python: Techniques and Code Examples

This article explains how to use Python's parameterized approach to efficiently read, clean, transform, summarize, visualize, and export Excel data through reusable functions and code snippets, enabling flexible and automated data workflows.

Exceldata-cleaningdata-processing

0 likes · 6 min read

Parameterized Excel Data Processing with Python: Techniques and Code Examples

Test Development Learning Exchange

Jul 3, 2024 · Fundamentals

Automating Excel Column Sorting and Filtering with Python

This guide demonstrates how to use Python's openpyxl and pandas libraries to automatically sort Excel columns by sales amount, filter rows exceeding a threshold, and extend functionality with regex, providing complete code examples for efficient data processing.

ExcelSortingdata-processing

0 likes · 7 min read

Automating Excel Column Sorting and Filtering with Python

macrozheng

Jul 2, 2024 · Backend Development

How to Speed Up Excel-to-Database Imports with Async and Thread Pool Tuning

Learn how to efficiently import large Excel files into a database using POI, JDBC, MyBatis, and Spring Boot, with step-by-step code examples, performance bottlenecks, and optimization techniques such as caching, asynchronous processing, multi-threaded batch inserts, and thread‑pool configuration for maximum throughput.

AsyncExcelJava

0 likes · 16 min read

How to Speed Up Excel-to-Database Imports with Async and Thread Pool Tuning

Test Development Learning Exchange

Jun 25, 2024 · Fundamentals

Python Automation for Excel, Word, PDF, and PowerPoint

This tutorial shows how to use Python libraries such as pandas, python-docx, PyPDF2, and python-pptx to read, write, merge, and manipulate Excel, Word, PDF, and PowerPoint files, providing ready‑to‑run code snippets for each common automation scenario.

ExcelPDFWord

0 likes · 9 min read

Python Automation for Excel, Word, PDF, and PowerPoint

Su San Talks Tech

Jun 22, 2024 · Backend Development

How to Speed Up Excel-to-Database Imports with Async and Thread‑Pool Tuning in Java

This article explains the common slow approach of reading Excel files with POI and inserting rows via JDBC, then presents three practical optimizations—caching data, using asynchronous multithreaded reads, and per‑file async processing—along with thread‑pool configuration tips and EasyExcel examples to dramatically reduce import time from minutes to seconds.

AsyncExcelJava

0 likes · 17 min read

How to Speed Up Excel-to-Database Imports with Async and Thread‑Pool Tuning in Java

Test Development Learning Exchange

Jun 21, 2024 · Fundamentals

10 Python Scripts for Automating Excel Tasks with pandas, openpyxl, and matplotlib

This guide presents ten practical Python scripts that cover installing required libraries, reading and writing Excel files, merging sheets, cleaning and filtering data, creating pivot tables, generating charts, styling cells, and automatically emailing Excel reports, providing a complete workflow for Excel automation.

ExcelMatplotlibdata-analysis

0 likes · 6 min read

10 Python Scripts for Automating Excel Tasks with pandas, openpyxl, and matplotlib

Python Crawling & Data Mining

Jun 13, 2024 · Fundamentals

How to Build a Python FIFO Checker for Excel Inventory with Tkinter

This article walks through a Python solution for validating FIFO inventory rules in Excel files, using pandas and Tkinter to create a GUI tool that reads multiple sheets, checks operation and stock dates, highlights violations, and saves the results, while also addressing common import errors and offering troubleshooting tips.

ExcelFIFOPython

0 likes · 12 min read

How to Build a Python FIFO Checker for Excel Inventory with Tkinter

Python Programming Learning Circle

May 20, 2024 · Fundamentals

A Comprehensive Guide to 20 Data Visualization Tools from Beginner to Expert

This article introduces twenty data visualization tools—including Excel, CSV/JSON, Google Chart API, Flot, Raphael, D3, Visual.ly, Crossfilter, Tangle, various map libraries, Processing, NodeBox, R, Weka, and Gephi—explaining their features, use cases, and suitability for different skill levels and project requirements.

ExcelGISPython

0 likes · 9 min read

A Comprehensive Guide to 20 Data Visualization Tools from Beginner to Expert

Python Crawling & Data Mining

Apr 20, 2024 · Fundamentals

Automate Bulk Excel Column Extraction and Merging with Python Pandas

This tutorial shows how to use Python's pandas library to automatically locate Excel files across many folders, extract specified columns, and merge the data into a single workbook, providing a practical solution for handling hundreds of spreadsheets efficiently.

ExcelPythonpandas

0 likes · 4 min read

Automate Bulk Excel Column Extraction and Merging with Python Pandas

Python Programming Learning Circle

Apr 16, 2024 · Fundamentals

Using Python to Process Excel, Word, and CSV Files

This tutorial demonstrates how to install and use Python libraries such as xlrd, xlwt, xlutils, XlsxWriter, OpenPyXL, python-docx, and the csv module to read, write, modify, and format Excel, Word, and CSV files, including code examples and feature comparisons.

CSVDataProcessingExcel

0 likes · 31 min read

Using Python to Process Excel, Word, and CSV Files

Python Programming Learning Circle

Mar 16, 2024 · Backend Development

Building a Flask Test Site and Retrieving Data with Excel and Python

This tutorial explains how to create a simple Flask web site and RESTful API, then demonstrates retrieving the table data using Excel's web import feature and Python's requests, BeautifulSoup, and pandas libraries, while comparing the two approaches.

Data ExtractionExcelFlask

0 likes · 9 min read

Building a Flask Test Site and Retrieving Data with Excel and Python

Python Crawling & Data Mining

Feb 25, 2024 · Fundamentals

Simplify Excel Age Bucketing in Python with Pandas: Quick Code Solutions

This article walks through a real‑world Python question on categorizing Excel aging data, presents multiple pandas‑based approaches—including pd.cut, conditional logic, and the where method—provides complete code snippets, and compares their suitability for simple versus complex interval requirements.

ExcelPythonage bucket

0 likes · 5 min read

Simplify Excel Age Bucketing in Python with Pandas: Quick Code Solutions

Python Crawling & Data Mining

Feb 24, 2024 · Artificial Intelligence

How ChatGPT Can Generate Ready‑to‑Run Pandas Code for Excel Data Analysis

This article explains how to use ChatGPT to automatically generate accurate pandas scripts for Excel‑based data analysis, compares Python packages with VBA, shows prompt engineering techniques, and demonstrates adapting the code for Excel's built‑in Python feature.

ChatGPTExcelPrompt Engineering

0 likes · 12 min read

How ChatGPT Can Generate Ready‑to‑Run Pandas Code for Excel Data Analysis

Python Crawling & Data Mining

Feb 23, 2024 · Fundamentals

How to Merge Multiple Excel Files and Preserve Headers with Python Pandas

This article walks through handling merged headers and formula cells in Excel using Python's pandas and openpyxl, providing step‑by‑step code to merge multiple workbooks, skip unwanted rows, assign custom headers, and format the final sheet with merged cells.

ExcelPythondata-processing

0 likes · 7 min read

How to Merge Multiple Excel Files and Preserve Headers with Python Pandas

Python Crawling & Data Mining

Feb 21, 2024 · Fundamentals

How to Preserve Original Date Formats When Reading Excel with Pandas

This article explains why pandas adds a time component when reading dates from Excel or CSV files and provides three practical methods—specifying column formats, using datetime.strptime, and setting a date parser for Excel—to keep dates unchanged while still enabling further datetime operations.

ExcelPythondate handling

0 likes · 5 min read

How to Preserve Original Date Formats When Reading Excel with Pandas

Code Ape Tech Column

Feb 5, 2024 · Backend Development

Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel with Caching, Batch Inserts, and Parallel Streams

This article details how to dramatically speed up the import of massive Excel files (over 100,000 rows) into a Java backend by switching to EasyExcel, caching database lookups, using batch VALUES inserts, and parallelizing the write operations with functional utilities.

Batch InsertExcelJava

0 likes · 12 min read

Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel with Caching, Batch Inserts, and Parallel Streams

IT Services Circle

Jan 31, 2024 · Fundamentals

Building a Fully Functional 16‑bit CPU Inside Microsoft Excel

Tech blogger Inkbox demonstrates how to construct a fully functional 16‑bit CPU, complete with 128 KB RAM, a 128×128 pixel display, and a custom 23‑instruction assembly language called Excel‑ASM16, all implemented purely within Microsoft Excel without any VBA scripts or plugins.

Assembly LanguageCPUExcel

0 likes · 2 min read

Building a Fully Functional 16‑bit CPU Inside Microsoft Excel

Su San Talks Tech

Jan 22, 2024 · Backend Development

How to Supercharge Excel-to-Database Imports with Async and Thread‑Pool Tuning in Java

This article walks through the common slow Excel‑to‑DB import pattern, shows why it becomes a bottleneck, and presents three progressive optimizations—including caching, asynchronous multi‑threaded reading, and double‑async processing—along with detailed Spring @Async thread‑pool configuration and EasyExcel alternatives, all illustrated with complete Java code samples.

AsyncExcelJava

0 likes · 17 min read

How to Supercharge Excel-to-Database Imports with Async and Thread‑Pool Tuning in Java

Python Crawling & Data Mining

Jan 20, 2024 · Fundamentals

Convert Excel Scores to Grade Levels Using Python Pandas

This article explains how to transform numeric scores in multiple Excel sheets into categorical grades (Excellent, Good, Average, Poor) with Python, preserving any existing Chinese text, and provides a concise, reusable solution illustrated with screenshots.

ExcelPythonpandas

0 likes · 4 min read

Convert Excel Scores to Grade Levels Using Python Pandas

Python Crawling & Data Mining

Jan 16, 2024 · Fundamentals

How to Filter Excel Rows with Pandas: A Step‑by‑Step Guide

This article walks through a real‑world Pandas question about selecting specific rows from an Excel file, presenting the problem, the solution code, and key tips for effective data filtering in Python.

Data FilteringExcelPython

0 likes · 3 min read

How to Filter Excel Rows with Pandas: A Step‑by‑Step Guide

Selected Java Interview Questions

Jan 12, 2024 · Backend Development

Efficient Excel Processing with EasyExcel in Java

This article introduces EasyExcel, a Java library that simplifies high‑performance Excel read/write operations, explains its core concepts, provides practical code examples for reading, writing, and filling Excel files, and discusses performance‑optimizing techniques and important usage considerations.

BackendDataProcessingExcel

0 likes · 16 min read

Efficient Excel Processing with EasyExcel in Java

macrozheng

Dec 20, 2023 · Backend Development

Export Millions of Records to Excel Efficiently with SpringBoot, EasyExcel, and Async

This article explains how to build a high‑performance, million‑row Excel export feature in Java using SpringBoot, EasyExcel, asynchronous job or MQ processing, pagination, multi‑sheet handling, OSS storage, and WebSocket notifications to avoid timeouts, OOM errors, and improve user experience.

AsyncExcelJava

0 likes · 16 min read

Export Millions of Records to Excel Efficiently with SpringBoot, EasyExcel, and Async

Python Crawling & Data Mining

Dec 12, 2023 · Fundamentals

How to Merge 12 Pandas DataFrames into One Excel Sheet with Spacing

This article walks through how to combine twelve distinct pandas DataFrames into a single Excel worksheet, inserting two blank rows between each table, by determining the current sheet’s last occupied row and appending data accordingly, complete with code snippets and visual guidance.

ExcelPythondata-processing

0 likes · 4 min read

How to Merge 12 Pandas DataFrames into One Excel Sheet with Spacing

Python Crawling & Data Mining

Dec 11, 2023 · Fundamentals

How to Merge Multiple Pandas DataFrames into One Excel Sheet with Spacing

This article walks through a practical solution for combining twelve distinct pandas DataFrames into a single Excel worksheet, inserting two blank rows between each table, and offers alternative approaches using CSV intermediate files, complete with code snippets and visual examples.

ExcelPythondata-processing

0 likes · 4 min read

How to Merge Multiple Pandas DataFrames into One Excel Sheet with Spacing

Java Backend Technology

Dec 7, 2023 · Backend Development

Export Any Java Object to CSV/Excel with Reflection – A Universal Utility

This tutorial demonstrates how to create a universal CSV/Excel export utility in Java that can handle objects of any class by using reflection to generate headers and rows, leveraging Apache POI and Spring Boot for seamless file generation.

Apache POICSVExcel

0 likes · 10 min read

Export Any Java Object to CSV/Excel with Reflection – A Universal Utility

Python Crawling & Data Mining

Dec 7, 2023 · Fundamentals

How to Split and Merge Excel Data with Pandas: A Step‑by‑Step Guide

This article walks through a real‑world Pandas tutorial where a single‑column Excel file is reshaped into 13 columns, duplicate rows are removed, column headers are set, and timestamps from a second workbook are merged, highlighting the challenges of aligning data without a unique key.

ExcelPythonTutorial

0 likes · 5 min read

How to Split and Merge Excel Data with Pandas: A Step‑by‑Step Guide

Architecture Digest

Dec 5, 2023 · Backend Development

Common Java Backend Code Smells and Bugs: Real‑World Cases and Fixes

The article presents a collection of typical Java backend coding mistakes—ranging from misused ternary operators and poor parameter validation to logging pitfalls, dead code, improper exception handling, AOP self‑invocation issues, Redis resilience problems, and Excel file upload bugs—along with concrete examples, images, and corrected code snippets to help developers avoid and fix them.

BackendBugFixesCodeQuality

0 likes · 12 min read

Common Java Backend Code Smells and Bugs: Real‑World Cases and Fixes

IT Services Circle

Nov 24, 2023 · Backend Development

Understanding and Solving Memory Overflow in Apache POI Excel Processing with EasyExcel

The article explains why Apache POI loads entire .xlsx zip files into memory causing OOM, demonstrates the issue with code examples, and shows how switching to EasyExcel's streaming read dramatically reduces memory usage while handling large Excel files in Java.

Apache POIExcelFile Processing

0 likes · 8 min read

Understanding and Solving Memory Overflow in Apache POI Excel Processing with EasyExcel