Implementing Efficient Excel Import/Export in Spring Boot with EasyExcel
Optimizing Excel Data Handling in Spring Boot Applications
When dealing with Excel import/export functionality in Java web applications, memory efficiency becomes crucial. Traditional libraries like EasyPoi or Hutool can consume significant memory, making EasyExcel a better choice for large datasets. This implementation leverages Java 8 functio ...
Posted on Tue, 23 Jun 2026 17:31:45 +0000 by sangamon
Magicodes.IE 2.4 Release with Enhanced Excel Export Features
The latest version 2.4 of Magicodes.IE has been released, incorporating community feedback and continuously improving based on user requirements. Our current release cycle maintains an average of one beta version per week and a stable release monthly. We encourage more developers to contribute by submitting issues and pull requests.
Project rep ...
Posted on Sat, 30 May 2026 22:41:58 +0000 by The_Black_Knight
Implementing Multi-Sheet Excel Export Functionality in Java
Implementing Multi-Sheet Excel Export Functionality in Java
Apache POI library provides comprehansive support for Excel file manipulation in Java applications. For multi-sheet exports, begin by adding the necessary Maven dependancy:
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifact ...
Posted on Mon, 25 May 2026 23:45:44 +0000 by ramli
Exporting DataGrid Content to Excel with Custom JavaScript
Integrate the datagrid-export.js script by copying and pasting it in to your project.
(function($){
function retrieveRows(targetElement) {
var gridState = $(targetElement).data('datagrid');
if (gridState.filterSource) {
return gridState.filterSource.rows;
} else {
return gridState.data.rows;
...
Posted on Mon, 18 May 2026 17:44:49 +0000 by EmperorDoom
Formatting and Exporting Structured Excel Files with C# and NPOI
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.SS.Util;
using NPOI.XSSF.UserModel;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
public IActionResult GenerateInventoryDailyReport()
{
var userId = AuthHelper.GetCurrentUserId();
var reportData = DapperRepository.QueryDataSet(
...
Posted on Sat, 16 May 2026 23:12:04 +0000 by djcee