How 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:
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:
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:
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:
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!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

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

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

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

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

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.

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 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 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

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.

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
