search
HomeJavajavaTutorialHow to create, edit and delete Excel mini charts in 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();
    }
}

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();
    }
}

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();
    }
}

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
This article is reproduced at:亿速云. If there is any infringement, please contact admin@php.cn delete
Are there any emerging technologies that threaten or enhance Java's platform independence?Are there any emerging technologies that threaten or enhance Java's platform independence?Apr 24, 2025 am 12:11 AM

Emerging technologies pose both threats and enhancements to Java's platform independence. 1) Cloud computing and containerization technologies such as Docker enhance Java's platform independence, but need to be optimized to adapt to different cloud environments. 2) WebAssembly compiles Java code through GraalVM, extending its platform independence, but it needs to compete with other languages ​​for performance.

What are the different implementations of the JVM, and do they all provide the same level of platform independence?What are the different implementations of the JVM, and do they all provide the same level of platform independence?Apr 24, 2025 am 12:10 AM

Different JVM implementations can provide platform independence, but their performance is slightly different. 1. OracleHotSpot and OpenJDKJVM perform similarly in platform independence, but OpenJDK may require additional configuration. 2. IBMJ9JVM performs optimization on specific operating systems. 3. GraalVM supports multiple languages ​​and requires additional configuration. 4. AzulZingJVM requires specific platform adjustments.

How does platform independence reduce development costs and time?How does platform independence reduce development costs and time?Apr 24, 2025 am 12:08 AM

Platform independence reduces development costs and shortens development time by running the same set of code on multiple operating systems. Specifically, it is manifested as: 1. Reduce development time, only one set of code is required; 2. Reduce maintenance costs and unify the testing process; 3. Quick iteration and team collaboration to simplify the deployment process.

How does Java's platform independence facilitate code reuse?How does Java's platform independence facilitate code reuse?Apr 24, 2025 am 12:05 AM

Java'splatformindependencefacilitatescodereusebyallowingbytecodetorunonanyplatformwithaJVM.1)Developerscanwritecodeonceforconsistentbehavioracrossplatforms.2)Maintenanceisreducedascodedoesn'tneedrewriting.3)Librariesandframeworkscanbesharedacrossproj

How do you troubleshoot platform-specific issues in a Java application?How do you troubleshoot platform-specific issues in a Java application?Apr 24, 2025 am 12:04 AM

To solve platform-specific problems in Java applications, you can take the following steps: 1. Use Java's System class to view system properties to understand the running environment. 2. Use the File class or java.nio.file package to process file paths. 3. Load the local library according to operating system conditions. 4. Use VisualVM or JProfiler to optimize cross-platform performance. 5. Ensure that the test environment is consistent with the production environment through Docker containerization. 6. Use GitHubActions to perform automated testing on multiple platforms. These methods help to effectively solve platform-specific problems in Java applications.

How does the class loader subsystem in the JVM contribute to platform independence?How does the class loader subsystem in the JVM contribute to platform independence?Apr 23, 2025 am 12:14 AM

The class loader ensures the consistency and compatibility of Java programs on different platforms through unified class file format, dynamic loading, parent delegation model and platform-independent bytecode, and achieves platform independence.

Does the Java compiler produce platform-specific code? Explain.Does the Java compiler produce platform-specific code? Explain.Apr 23, 2025 am 12:09 AM

The code generated by the Java compiler is platform-independent, but the code that is ultimately executed is platform-specific. 1. Java source code is compiled into platform-independent bytecode. 2. The JVM converts bytecode into machine code for a specific platform, ensuring cross-platform operation but performance may be different.

How does the JVM handle multithreading on different operating systems?How does the JVM handle multithreading on different operating systems?Apr 23, 2025 am 12:07 AM

Multithreading is important in modern programming because it can improve program responsiveness and resource utilization and handle complex concurrent tasks. JVM ensures the consistency and efficiency of multithreads on different operating systems through thread mapping, scheduling mechanism and synchronization lock mechanism.

See all articles

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

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

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

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment