poi在Excel中创建折线图

r囧r小猫 2023-02-18 06:58 213阅读 0赞

### 效果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p6Y2hhbmNlcw_size_16_color_FFFFFF_t_70][]

### 代码 ###

import org.apache.poi.ss.usermodel.\*;  
import org.apache.poi.ss.usermodel.charts.\*;  
import org.apache.poi.ss.util.CellRangeAddress;  
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileOutputStream;

public class LineChartDemo \{  
    public static void main(String\[\] args) throws Exception \{  
        Workbook wb = new XSSFWorkbook();  
        Sheet sheet = wb.createSheet("linechart");  
        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, 0, 5, 10, 15);

Chart chart = drawing.createChart(anchor);  
        ChartLegend legend = chart.getOrCreateLegend();  
        legend.setPosition(LegendPosition.TOP\_RIGHT);

LineChartData data = chart.getChartDataFactory().createLineChartData();

// Use a category axis for the bottom axis.  
        ChartAxis bottomAxis = chart.getChartAxisFactory().createCategoryAxis(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);

// Write the output to a file  
        FileOutputStream fileOut = new FileOutputStream("F://excel\_demo/line\_demo.xlsx");  
        wb.write(fileOut);  
        fileOut.close();  
    \}  
\}

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p6Y2hhbmNlcw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200616120829657.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p6Y2hhbmNlcw==,size_16,color_FFFFFF,t_70