Conversion du graphique en image en PHP

Aspose.Cells - Conversion du graphique en image

Pour convertir un graphique en image à l’aide de Aspose.Cells for Java en PHP, il suffit d’invoquer le module Converter.

Code PHP

 $chartType = new ChartType();

$color = new Color();

$imageFormat = new ImageFormat();

//Create a new Workbook.

$workbook = new Workbook();

//Get the first worksheet.

$sheet = $workbook->getWorksheets()->get(0);

//Set the name of worksheet

$sheet->setName("Data");

//Get the cells collection in the sheet.

$cells = $workbook->getWorksheets()->get(0)->getCells();

//Put some values into a cells of the Data sheet.

$cells->get("A1")->setValue("Region");

$cells->get("A2")->setValue("France");

$cells->get("A3")->setValue("Germany");

$cells->get("A4")->setValue("England");

$cells->get("A5")->setValue("Sweden");

$cells->get("A6")->setValue("Italy");

$cells->get("A7")->setValue("Spain");

$cells->get("A8")->setValue("Portugal");

$cells->get("B1")->setValue("Sale");

$cells->get("B2")->setValue(70000);

$cells->get("B3")->setValue(55000);

$cells->get("B4")->setValue(30000);

$cells->get("B5")->setValue(40000);

$cells->get("B6")->setValue(35000);

$cells->get("B7")->setValue(32000);

$cells->get("B8")->setValue(10000);

//Create chart

$chartIndex = $sheet->getCharts()->add($chartType->COLUMN, 12, 1, 33, 12);

$chart = $sheet->getCharts()->get($chartIndex);

//Set properties of chart title

$chart->getTitle()->setText("Sales By Region");

$chart->getTitle()->getFont()->setBold(true);

$chart->getTitle()->getFont()->setSize(12);

//Set properties of nseries

$chart->getNSeries()->add("Data!B2:B8", true);

$chart->getNSeries()->setCategoryData("Data!A2:A8");

//Set the fill colors for the series's data points (France - Portugal(7 points))

$chartPoints = $chart->getNSeries()->get(0)->getPoints();

$point = $chartPoints->get(0);

$point->getArea()->setForegroundColor(java_values($color->getCyan()));

$point = $chartPoints->get(1);

$point->getArea()->setForegroundColor($color->getBlue());

$point = $chartPoints->get(2);

$point->getArea()->setForegroundColor($color->getYellow());

$point = $chartPoints->get(3);

$point->getArea()->setForegroundColor($color->getRed());

$point = $chartPoints->get(4);

$point->getArea()->setForegroundColor($color->getBlack());

$point = $chartPoints->get(5);

$point->getArea()->setForegroundColor($color->getGreen());

$point = $chartPoints->get(6);

$point->getArea()->setForegroundColor($color->getMaroon());

//Set the legend invisible

$chart->setShowLegend(false);



//Get the Chart image

$imgOpts = new ImageOrPrintOptions();

$imgOpts->setImageFormat($imageFormat->getEmf());

$fs = new FileOutputStream($dataDir . "Chart.emf");

//Save the chart image file.

$chart->toImage($fs, $imgOpts);

$fs->close();  

Télécharger le code en cours d’exécution

Télécharger Conversion du graphique en image (Aspose.Cells) de l’un des sites de codage social mentionnés ci-dessous :

• GitHub