public static function run($dataDir = null) { $imageFormat = new ImageFormat(); //Instantiate a new workbook with path to an Excel file $book = new Workbook($dataDir . "MyTestBook1.xls"); //Create an object for ImageOptions $imgOptions = new ImageOrPrintOptions(); //Set the image type $imgOptions->setImageFormat($imageFormat->getPng()); //Get the first worksheet. $sheet = $book->getWorksheets()->get(0); //Create a SheetRender object for the target sheet $sr = new SheetRender($sheet, $imgOptions); for ($j = 0; $j < $sr->getPageCount(); $j++) { //Generate an image for the worksheet $sr->toImage($j, $dataDir . "mysheetimg" . $j . ".png"); } // Print message print "Images generated successfully." . PHP_EOL; }
public static function run($dataDir = null) { $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(); // Print message print "<BR>"; print "Processing performed successfully."; }