Hi, I'm using open flash chart 2 library to generate chart with 2 y axis. However, I cannot add legend for the right y axis. Does anybody know how to implement it?
Thank you
bhbrayeun
Last Activity: Apr 25 '10, 09:09 AM
Joined: Apr 12 '10
Location:
-
open flash chart 2 right y axis legend
-
I finally did it using pear. Using this library, the xls file is no longer an XML file, it's a binary file and I think it is embedded because I didn't use <img src...> anymore. Instead, I use :
However, the image files have to be a bmp format so we have to convert the format first. I use JPEXS' bmp library to convert formats.Code:$worksheet->insertBitmap
-
I found the reason it didn't show anything. The include_path in php.ini should be
whereas mine wasCode:include_path = ".;C:\xampp\php\pear\;"
Hope it saves somebody's timeCode:include_path = ".;C:\program files\xampp\php\pear\;"
Thank you for all your helps guys.Leave a comment:
-
Thank you guys for all your suggestions. I think I will try Spreadsheet_Exc el_Writer from pear because I really need the images to be embedded in my xls file. However, when I tried it, it showed blank page. Does it need some special configuration?
...Code:<?php require_once("Spreadsheet/Excel/Writer.php"); $workbook = new Spreadsheet_Excel_Writer(); $workbook->send("file.xls");Leave a comment:
-
Yes it does create an xls file, but as I said before, it cannot embed images from base64 encoded png files. I tried to use different approach : change the base64 encoded png file to a png file and save it in the server then I use <img> tag to display the images. But my problem now, when I delete the images from server, the image in the xls is also disappear because it's only a link I guess. Any suggestions?Leave a comment:
-
how to embed image(png) to Excel using php
I use below to output data to a excel file using PHP,
...Code:echo "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\">"; echo "<head>"; echo "<meta http-equiv=Content-Type content=\"text/html; charset=us-ascii\"> <meta name=ProgId content=Excel.Sheet><meta
No activity results to display
Leave a comment: