java操作excel之poi|使用poi操作excel_画图 java操作excel之poi|java

??package com.fujitsu.fb.reporter.subprocess; import java.io.FileOutputStream; import org.apache.poi.ss.usermodel.*; import org.apache.poi.ss.util.*; import org.apache.poi.ss.usermodel.charts.*; import org.apache.poi.xssf.usermodel.XSSFWorkbook; /** * Illustrates how to create a simple scatter chart. * * @author Roman Kashitsyn */ public class ScatterChart { public static void main(String[] args) throws Exception { Workbook wb = new XSSFWorkbook(); Sheet sheet = wb.createSheet("Sheet 1"); final int NUM_OF_ROWS = 3; final int NUM_OF_COLUMNS = 10; // Create a row and put some cells in it. Rows are 0 based. Row row; Cell cell; for (int rowIndex = 0; rowIndex < NUM_OF_ROWS; rowIndex++) { row = sheet.createRow((short) rowIndex); for (int colIndex = 0; colIndex < NUM_OF_COLUMNS; colIndex++) { cell = row.createCell((short) colIndex); cell.setCellValue(colIndex * (rowIndex + 1)); } }Drawing drawing = sheet.createDrawingPatriarch(); ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 2, 5, 10, 15); //设置坐标Chart chart = drawing.createChart(anchor); //创建图表 ChartLegend legend = chart.getOrCreateLegend(); //获取或创建图例 legend.setPosition(LegendPosition.TOP_RIGHT); //设置图例位置ScatterChartData data = https://www.it610.com/article/chart.getChartDataFactory().createScatterChartData(); //获取分散数据ValueAxis bottomAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM); //地轴 ValueAxis leftAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT); //左轴 leftAxis.setCrosses(AxisCrosses.AUTO_ZERO); //设置自动交叉ChartDataSource xs = DataSources.fromNumericCellRange(sheet, new CellRangeAddress(0, 0, 0, NUM_OF_COLUMNS - 1)); ChartDataSource ys1 = DataSources.fromNumericCellRange(sheet, new CellRangeAddress(1, 1, 0, NUM_OF_COLUMNS - 1)); ChartDataSource ys2 = DataSources.fromNumericCellRange(sheet, new CellRangeAddress(2, 2, 0, NUM_OF_COLUMNS - 1)); data.addSerie(xs, ys1); data.addSerie(xs, ys2); chart.plot(data, bottomAxis, leftAxis); String excelPath = "E:\\poi\\ooxml-scatter-chart.xlsx"; // Write the output to a file FileOutputStream fileOut = new FileOutputStream(excelPath); wb.write(fileOut); fileOut.close(); System.out.println("----Excle文件已生成------"); } }

【java操作excel之poi|使用poi操作excel_画图】

java操作excel之poi|使用poi操作excel_画图

推荐阅读

青春期如何长高男生青春期长高方法

Android 关于个推消息透传处理

查询数据库时间查询数据库redis

碱性水果有哪些碱性食物排名第一名是什么

叮当管家

换工作的话企业年金怎么办，跟着转移吗？

京东图书发票有明细表

文档|金山文档云空间可免费升级至 5GB，有效期为永久

恋爱话术库约会开场白有哪些？开场白话术分享

切好的山药发黑能吃吗

如何让员工主动离职？

如何找彩色碧玺石如何找彩色碧玺，如何找彩色碧玺手串

steam最终幻想13打不开 steam最终幻想7打不开

家常香芋烤排

和平精英如何查看自己被谁杀

jQuery上传文件不成功，jq 上传文件

电商是什么怎么做做电商需要懂得什么，做电商需要准备什么

各地过年不同风俗图片大全各地过年的不同风俗

去了皮的蒜还可以做糖醋蒜吗

防火墙的功能风险分析,企业功能风险分析表