How can a graph or chart generated with PHPlot be copied to the clipboard for easy pasting into MS Office programs?

To copy a graph or chart generated with PHPlot to the clipboard for easy pasting into MS Office programs, you can use the PHP library PHPExcel to create an Excel file containing the chart image. This Excel file can then be easily copied and pasted into MS Office programs. 

// Create a PHPExcel object
$objPHPExcel = new PHPExcel();

// Add chart image to the Excel file
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName('Chart');
$objDrawing->setDescription('Chart');
$objDrawing->setPath('path_to_chart_image.png');
$objDrawing->setCoordinates('A1');
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

// Save the Excel file
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('chart_excel_file.xlsx');

Keywords

PHPlot graph chart clipboard MS Office

Related Questions