使用poi操作excel_画图

最新推荐文章于 2024-08-01 14:30:01 发布

LUCKSUNBOY

最新推荐文章于 2024-08-01 14:30:01 发布

阅读量3.8k

点赞数

分类专栏： java操作excel之poi java 文章标签： excel poi

本文链接：https://blog.csdn.net/kongpancheng/article/details/73198777

版权

java操作excel之poi 同时被 2 个专栏收录

1 篇文章 0 订阅

订阅专栏

java

1 篇文章 0 订阅

订阅专栏



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 = chart.getChartDataFactory().createScatterChartData();//获取分散数据

  ValueAxis bottomAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);//地轴
  ValueAxis leftAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT);//左轴
  leftAxis.setCrosses(AxisCrosses.AUTO_ZERO);//设置自动交叉

  ChartDataSource<Number> xs = DataSources.fromNumericCellRange(sheet,
    new CellRangeAddress(0, 0, 0, NUM_OF_COLUMNS - 1));
  ChartDataSource<Number> ys1 = DataSources.fromNumericCellRange(sheet,
    new CellRangeAddress(1, 1, 0, NUM_OF_COLUMNS - 1));
  ChartDataSource<Number> 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文件已生成------");
 }
}