BestHub
Sign in
Tag

Excel Export

0 views collected around this technical thread.

Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Dec 1, 2024 · Backend Development

Optimizing Million-Row Excel Export with EasyExcel: Design, Implementation, and Performance Tuning

This article presents a comprehensive guide to efficiently exporting millions of rows to Excel using EasyExcel, covering performance bottlenecks, resource consumption, asynchronous processing, thread‑pool design, batch querying, streaming writes, and practical code examples to achieve fast, memory‑friendly report generation.

EasyExcelExcel ExportJava
0 likes · 35 min read
Optimizing Million-Row Excel Export with EasyExcel: Design, Implementation, and Performance Tuning
Top Architect
Top Architect
Nov 2, 2024 · Backend Development

Optimizing Excel Export with EasyExcel: Performance Improvements and Merged‑Cell Strategies

This article demonstrates how to boost performance when exporting large datasets to Excel using EasyExcel, covering single‑batch, paginated, and concurrent writes, and explains multiple approaches—including annotations and custom WriteHandlers—to efficiently create merged cells in the generated spreadsheets.

Cell MergingConcurrencyEasyExcel
0 likes · 18 min read
Optimizing Excel Export with EasyExcel: Performance Improvements and Merged‑Cell Strategies
Java Architect Essentials
Java Architect Essentials
Oct 30, 2024 · Backend Development

Optimizing Excel Export with EasyExcel: Performance, Pagination, Concurrency, and Cell‑Merging Strategies

This article demonstrates how to use EasyExcel to efficiently export large volumes of data to Excel by improving performance through pagination, concurrent queries, and custom cell‑merging strategies, including built‑in annotations and WriteHandler implementations, while providing complete Java code examples.

Cell MergingConcurrencyEasyExcel
0 likes · 16 min read
Optimizing Excel Export with EasyExcel: Performance, Pagination, Concurrency, and Cell‑Merging Strategies
Architect's Guide
Architect's Guide
Oct 17, 2024 · Backend Development

Using JXLS for Complex Excel Export in Java Backend Applications

This article introduces the JXLS library for Java, explains how to add Maven dependencies, provides backend utility and controller code for exporting Excel files, and details common XLS expressions such as jx:area, jx:each, jx:mergeCells, and dynamic column handling to simplify complex Excel report generation.

Dynamic ColumnsExcel ExportJXLS
0 likes · 8 min read
Using JXLS for Complex Excel Export in Java Backend Applications
Java Tech Enthusiast
Java Tech Enthusiast
Feb 14, 2024 · Backend Development

Generic Excel Export for Arbitrary Java Objects via Reflection

The article shows how to generically export any Java object's data to an Excel‑compatible CSV file by using reflection to convert objects into maps, building headers (optionally via a @JcExcelName annotation) and writing the result with a reusable utility class and Maven‑managed Apache POI, FastJSON, and Commons‑IO dependencies, illustrated through SpringBoot controller and main‑method examples.

AnnotationCSVExcel Export
0 likes · 10 min read
Generic Excel Export for Arbitrary Java Objects via Reflection
Selected Java Interview Questions
Selected Java Interview Questions
Aug 25, 2023 · Backend Development

Using JXLS for Complex Excel Export in Java

This article introduces the JXLS library for Java, explains how to add Maven dependencies, provides backend utility and controller code for exporting Excel files, and details template creation and common JXLS expressions such as jx:area, jx:each, jx:mergeCells, and dynamic column handling.

Backend DevelopmentExcel ExportJXLS
0 likes · 6 min read
Using JXLS for Complex Excel Export in Java
Laravel Tech Community
Laravel Tech Community
Jul 16, 2023 · Backend Development

Creating Export Classes and Exporting Data with Laravel Excel (Lysice XlsWriter)

This tutorial explains how to generate export classes in Laravel, implement array, query, or collection exports, customize column headers, download files directly, specify file names, formats, response headers, store exports to disk, set document options, and reuse exports with traits, all using the Lysice XlsWriter package.

Backend DevelopmentExcel ExportLaravel
0 likes · 4 min read
Creating Export Classes and Exporting Data with Laravel Excel (Lysice XlsWriter)
Selected Java Interview Questions
Selected Java Interview Questions
Jun 24, 2023 · Backend Development

Guide to Using EasyExcel in Java: Quick Start, Export/Import, and Custom Merge Strategies

This article provides a comprehensive tutorial on EasyExcel, a Java library for fast and memory‑efficient Excel processing, covering dependency setup, simple and complex export examples with custom annotations and merge strategies, import handling, and reference resources.

Backend DevelopmentCustom MergeEasyExcel
0 likes · 14 min read
Guide to Using EasyExcel in Java: Quick Start, Export/Import, and Custom Merge Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Apr 26, 2023 · Backend Development

Implementing a Flexible Excel Export Utility with Apache POI in Java

This article explains how to build a reusable Java utility for exporting large Excel reports using Apache POI, covering header configuration, data transformation, cell formatting, multithreaded data retrieval, asynchronous handling of long‑running exports, and provides full source snippets and SQL schema examples.

Apache POIBackend DevelopmentExcel Export
0 likes · 13 min read
Implementing a Flexible Excel Export Utility with Apache POI in Java
Architect's Guide
Architect's Guide
Mar 30, 2023 · Backend Development

Universal Java Class-to-Excel Export Using Reflection and CSV Formatting

This article explains how to build a generic Java utility that exports any list of objects to an Excel‑compatible CSV file by using reflection to extract field names for headers and values for rows, includes Maven dependencies, custom annotations, and practical usage examples.

AnnotationsBackend DevelopmentCSV
0 likes · 9 min read
Universal Java Class-to-Excel Export Using Reflection and CSV Formatting
Architect's Tech Stack
Architect's Tech Stack
Oct 26, 2022 · Backend Development

Using EasyExcel Spring Boot Starter for Excel Import, Export and Validation

This article introduces the EasyExcel‑Spring‑Boot‑Starter project, explains the limitations of POI and EasyExcel, shows how to integrate it into a Spring Boot application with Maven dependencies, demonstrates Excel import and export APIs, and provides comprehensive validation and error‑handling mechanisms for robust backend development.

EasyExcelExcel ExportExcel import
0 likes · 10 min read
Using EasyExcel Spring Boot Starter for Excel Import, Export and Validation
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Sep 29, 2022 · Frontend Development

Using Web Workers for Large Excel Export and Batch Image Compression in Frontend Projects

This article explains how to leverage Web Workers and OffscreenCanvas to offload heavy Excel file generation and bulk image compression from the main thread, improving UI responsiveness and reducing rendering stalls in typical backend‑admin web applications.

Excel ExportOffscreenCanvasfrontend performance
0 likes · 14 min read
Using Web Workers for Large Excel Export and Batch Image Compression in Frontend Projects
Top Architect
Top Architect
Apr 18, 2022 · Backend Development

Dynamic Excel Export with EasyPOI: Generating Column Headers and Data Programmatically

This article demonstrates how to use EasyPOI to export Excel files with dynamically generated column headers and data rows in Java, covering dependency configuration, header creation, data population, merging cells, utility methods, DTO definitions, and a complete test case.

Backend DevelopmentDynamic ColumnsEasyPoi
0 likes · 13 min read
Dynamic Excel Export with EasyPOI: Generating Column Headers and Data Programmatically
Baidu Geek Talk
Baidu Geek Talk
Aug 4, 2021 · Artificial Intelligence

PaddleOCR v2.2 Release: PP-Structure for Document Layout Analysis and Table Recognition

PaddleOCR v2.2 launches PP‑Structure, a Python‑installable toolkit that combines PP‑YOLO v2 layout analysis (classifying text, title, table, image, list) with RARE‑based table recognition to extract structured content and export editable Excel files, while supporting custom training and simple command‑line use.

AIExcel ExportPP-Structure
0 likes · 8 min read
PaddleOCR v2.2 Release: PP-Structure for Document Layout Analysis and Table Recognition
php中文网 Courses
php中文网 Courses
Apr 21, 2021 · Backend Development

Exporting Database Data to Excel with PHP

This article demonstrates how to export database records to an Excel file using PHP, detailing the data retrieval, formatting, and a reusable createtable function that outputs the spreadsheet with appropriate headers for download.

CSVDatabaseExcel Export
0 likes · 3 min read
Exporting Database Data to Excel with PHP
Java Architecture Diary
Java Architecture Diary
Mar 31, 2020 · Backend Development

Master Fast, Low-Memory Excel Export in Spring Boot with EasyExcel

This guide introduces EasyExcel, a Java library for memory‑efficient Excel read/write, shows how to add the Spring Boot starter dependency, and demonstrates basic, custom, multi‑sheet, password‑protected, and template‑based export techniques using the @ResponseExcel annotation.

AnnotationEasyExcelExcel Export
0 likes · 6 min read
Master Fast, Low-Memory Excel Export in Spring Boot with EasyExcel
Java Captain
Java Captain
Sep 22, 2018 · Backend Development

EasyExcel Method Encapsulation for Simplified Excel Import and Export in Java

This article introduces a lightweight Java wrapper around Alibaba's EasyExcel library that enables one‑line Excel import and export, explains required Maven dependencies, essential utility classes, and provides complete code examples for reading, writing single‑sheet and multi‑sheet workbooks with custom model mappings.

EasyExcelExcel ExportExcel import
0 likes · 8 min read
EasyExcel Method Encapsulation for Simplified Excel Import and Export in Java
Java Captain
Java Captain
Jun 20, 2018 · Backend Development

Export Excel Files in Java Using Apache POI

This article demonstrates how to use Apache POI in Java to export collections of JavaBean objects to Excel files, covering generic reflection‑based implementation, styling, handling of dates, booleans, images, and integration with a servlet for download.

Apache POIExcel ExportJava
0 likes · 12 min read
Export Excel Files in Java Using Apache POI