Table of Contents
Preface
Java sample code
1. Create a mini chart
2. Edit mini chart
3. Delete mini chart
Home Java javaTutorial How to create, edit and delete Excel mini charts in Java

How to create, edit and delete Excel mini charts in Java

Apr 30, 2023 pm 02:01 PM
excel java

Preface

Sparklines are miniature charts that represent data in Excel worksheet cells. Sparklines can be used to display data change trends very intuitively, highlighting maximum and minimum values. Placing them in a data table can achieve a good data analysis effect. This article will introduce how to create spark charts in Excel through Java code examples, as well as edit and delete spark charts in the table.

Program running environment: Java, IDEA, jdk1.8.0, no need to install Microsoft Excel

Use class library: Free Spire.XLS for Java (Free version)

Class library acquisition and import: Download the jar package from the official website, unzip it, and import the jar file in the lib folder into the java program. Or you can download it from the maven repository and import it into the Maven project. The following import effect:

How to create, edit and delete Excel mini charts in Java

Java sample code

1. Create a mini chart

import com.spire.xls.*;

import java.awt.*;

public class CreateSparklineChart {
    public static void main(String[] args) {
        //创建一个Workbook类对象并加载Excel文档
        Workbook workbook = new Workbook();
        workbook.loadFromFile(  "test.xlsx");

        //获取第一个工作表 
        Worksheet sheet = workbook.getWorksheets().get(0);

        //添加折线迷你图,设置折折线迷你图格式
        SparklineGroup sparklineGroup1 = sheet.getSparklineGroups().addGroup();
        sparklineGroup1.setSparklineType(SparklineType.Line);
        sparklineGroup1.setSparklineColor(new Color(153,50,204));
        sparklineGroup1.setShowHighPoint(true);
        //设置添加折现迷你图表的单元格以及图表生成的数据范围
        SparklineCollection sparklines1 = sparklineGroup1.add();
        sparklines1.add(sheet.getCellRange("B3:F3"), sheet.getCellRange("G3"));

        //添加柱形迷你图,并设置图表颜色
        SparklineGroup sparklineGroup2 = sheet.getSparklineGroups().addGroup();
        sparklineGroup2.setSparklineType(SparklineType.Column);
        sparklineGroup2.setSparklineColor(new Color(244,164,96));
        sparklineGroup2.setShowHighPoint(true);
        //设置添加柱形迷你图表的单元格以及图表生成的数据范围
        SparklineCollection sparklines2 = sparklineGroup2.add();
        sparklines2.add(sheet.getCellRange("B4:F4"), sheet.getCellRange("G4"));

        //添加盈亏迷你图,并设置颜色
        SparklineGroup sparklineGroup3 = sheet.getSparklineGroups().addGroup();
        sparklineGroup3.setSparklineType(SparklineType.Stacked);
        sparklineGroup3.setSparklineColor(new Color(255,20,147));
        sparklineGroup3.setShowHighPoint(true);
        //设置盈亏迷你图表的单元格以及图表生成的数据范围
        SparklineCollection sparklines3 = sparklineGroup3.add();
        sparklines3.add(sheet.getCellRange("B5:F5"), sheet.getCellRange("G5"));

        //保存文档
        workbook.saveToFile("AddSparkline.xlsx", ExcelVersion.Version2013);
        workbook.dispose();
    }
}
Copy after login

Mini chart creation effect:

How to create, edit and delete Excel mini charts in Java

2. Edit mini chart

import com.spire.xls.*;
import com.spire.xls.core.spreadsheet.ISparklineGroup;
import com.spire.xls.core.spreadsheet.ISparklines;

public class ModifySparkline {
    public static void main(String[] args) {
        //创建实例,加载文档
        Workbook wb = new Workbook();
        wb.loadFromFile("AddSparkline.xlsx");

        //获取工作表
        Worksheet sheet = wb.getWorksheets().get(0);

        //修改第2个迷你图组中迷你图表类型和数据范围
        ISparklineGroup sparklineGroup = sheet.getSparklineGroups().get(1);
        sparklineGroup.setSparklineType(SparklineType.Line);
        ISparklines sparklines = sparklineGroup.get(1);
        sparklines.refreshRanges(sheet.getCellRange("C4:F4"), sheet.getCellRange("G4"));

        //保存文档
        wb.saveToFile("ModifySparkline.xlsx", ExcelVersion.Version2013);
        wb.dispose();
    }
}
Copy after login

Mini chart modification result:

How to create, edit and delete Excel mini charts in Java

3. Delete mini chart

import com.spire.xls.*;
import com.spire.xls.core.spreadsheet.ISparklineGroup;


public class ClearSparkline {
    public static void main(String[] args) {
        //创建实例,加载文档
        Workbook wb = new Workbook();
        wb.loadFromFile("AddSparkline.xlsx");

        //获取工作表
        Worksheet sheet = wb.getWorksheets().get(0);

        //获取第3个迷你图
        ISparklineGroup sparklineGroup = sheet.getSparklineGroups().get(2);

        //从工作表中删除图表
        sheet.getSparklineGroups().clear((SparklineGroup) sparklineGroup);

        wb.saveToFile("ClearSparkline.xlsx",ExcelVersion.Version2013);
        wb.dispose();
    }
}
Copy after login

Mini chart deletion effect:

How to create, edit and delete Excel mini charts in Java

The above is the detailed content of How to create, edit and delete Excel mini charts in Java. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Java Spring Interview Questions Java Spring Interview Questions Aug 30, 2024 pm 04:29 PM

In this article, we have kept the most asked Java Spring Interview Questions with their detailed answers. So that you can crack the interview.

Break or return from Java 8 stream forEach? Break or return from Java 8 stream forEach? Feb 07, 2025 pm 12:09 PM

Java 8 introduces the Stream API, providing a powerful and expressive way to process data collections. However, a common question when using Stream is: How to break or return from a forEach operation? Traditional loops allow for early interruption or return, but Stream's forEach method does not directly support this method. This article will explain the reasons and explore alternative methods for implementing premature termination in Stream processing systems. Further reading: Java Stream API improvements Understand Stream forEach The forEach method is a terminal operation that performs one operation on each element in the Stream. Its design intention is

TimeStamp to Date in Java TimeStamp to Date in Java Aug 30, 2024 pm 04:28 PM

Guide to TimeStamp to Date in Java. Here we also discuss the introduction and how to convert timestamp to date in java along with examples.

Java Program to Find the Volume of Capsule Java Program to Find the Volume of Capsule Feb 07, 2025 am 11:37 AM

Capsules are three-dimensional geometric figures, composed of a cylinder and a hemisphere at both ends. The volume of the capsule can be calculated by adding the volume of the cylinder and the volume of the hemisphere at both ends. This tutorial will discuss how to calculate the volume of a given capsule in Java using different methods. Capsule volume formula The formula for capsule volume is as follows: Capsule volume = Cylindrical volume Volume Two hemisphere volume in, r: The radius of the hemisphere. h: The height of the cylinder (excluding the hemisphere). Example 1 enter Radius = 5 units Height = 10 units Output Volume = 1570.8 cubic units explain Calculate volume using formula: Volume = π × r2 × h (4

PHP vs. Python: Understanding the Differences PHP vs. Python: Understanding the Differences Apr 11, 2025 am 12:15 AM

PHP and Python each have their own advantages, and the choice should be based on project requirements. 1.PHP is suitable for web development, with simple syntax and high execution efficiency. 2. Python is suitable for data science and machine learning, with concise syntax and rich libraries.

PHP: A Key Language for Web Development PHP: A Key Language for Web Development Apr 13, 2025 am 12:08 AM

PHP is a scripting language widely used on the server side, especially suitable for web development. 1.PHP can embed HTML, process HTTP requests and responses, and supports a variety of databases. 2.PHP is used to generate dynamic web content, process form data, access databases, etc., with strong community support and open source resources. 3. PHP is an interpreted language, and the execution process includes lexical analysis, grammatical analysis, compilation and execution. 4.PHP can be combined with MySQL for advanced applications such as user registration systems. 5. When debugging PHP, you can use functions such as error_reporting() and var_dump(). 6. Optimize PHP code to use caching mechanisms, optimize database queries and use built-in functions. 7

Create the Future: Java Programming for Absolute Beginners Create the Future: Java Programming for Absolute Beginners Oct 13, 2024 pm 01:32 PM

Java is a popular programming language that can be learned by both beginners and experienced developers. This tutorial starts with basic concepts and progresses through advanced topics. After installing the Java Development Kit, you can practice programming by creating a simple "Hello, World!" program. After you understand the code, use the command prompt to compile and run the program, and "Hello, World!" will be output on the console. Learning Java starts your programming journey, and as your mastery deepens, you can create more complex applications.

How to Run Your First Spring Boot Application in Spring Tool Suite? How to Run Your First Spring Boot Application in Spring Tool Suite? Feb 07, 2025 pm 12:11 PM

Spring Boot simplifies the creation of robust, scalable, and production-ready Java applications, revolutionizing Java development. Its "convention over configuration" approach, inherent to the Spring ecosystem, minimizes manual setup, allo

See all articles