virtology Posted August 20, 2009 Share Posted August 20, 2009 Hi , I am creating charts(pie chart) with my php code which gets data from database and chart the respective values . I want to export these charts , or to create this chart in Excel by Clicking a button from web . I have seen it done on some website which I dont remember . Can anyone suggest what will be the best solution for it ? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/171208-exporting-data-to-create-charts-in-excel/ Share on other sites More sharing options...
Mark Baker Posted August 21, 2009 Share Posted August 21, 2009 It's perfectly straightforward to generate an Excel workbook using a library such as PHPExcel. How you do the charting depends on exactly what charts you need; but the easiest method is to generate the chart as an image file (using PHP and GD, and whatever charting libraries you have available), and then to embed that gif, jpg or png file as an image in the workbook. Work on actually handling Excel charts within PHPExcel (which would allow reading and writing of chart streams from within the PHP code) is in the very early stages of prototyping, but won't be available in any public release for a long time yet. Quote Link to comment https://forums.phpfreaks.com/topic/171208-exporting-data-to-create-charts-in-excel/#findComment-903184 Share on other sites More sharing options...
Mark Baker Posted September 1, 2009 Share Posted September 1, 2009 virtology u will find good stuff here www.phpscriptor.comI'll be very impressed if he finds a PHP library capable of handling Excel charts, especially on a site that's virtually empty Quote Link to comment https://forums.phpfreaks.com/topic/171208-exporting-data-to-create-charts-in-excel/#findComment-910350 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.