Hi,
Can i write to MS-Excel using PHP? I am using PHP 5 on Linux. Any help
would be appreciated!
Thanks,
Raghu
Can i write to MS-Excel using PHP? I am using PHP 5 on Linux. Any help
would be appreciated!
Thanks,
Raghu
-
-
Re: PHP with Excel
ABC wrote:That depends - you can write a file, which Excel can read, and add aHi,
Can i write to MS-Excel using PHP? I am using PHP 5 on Linux. Any help
would be appreciated!
>
Thanks,
Raghu
link to that. AFAIK only ASP has an option to open a file in Excel.
Correct me if I am wrong.
Af for exporting there are a few tricks:
$ff3=fopen($tar getdir."\\some_ file.xls", "w");
fwrite($ff3, "<html><tab le border=1>\r\n") ;
fwrite($ff3, "<tr><td><b>Ite m:</b></td<td><b>Used
in:</b></td<tr>\r\n");
fwrite($ff3, "<tr><td>su gar</td><td>coffee</td></tr>");
For tricks with numbers, try:
<STYLE TYPE="text/css"><!--
.number2dec {mso-number-format: Fixed;}
--></STYLE>
and use it like
<td class=""number2 dec"">" . $price ."</td><td class=""number2 dec"">
=d" . $y1 . "*e" . $y2 ."</td>"
This will add the first as a number, and the seconds as a fomula.
Try play around with this.
S
-
Re: PHP with Excel
PEAR can nicely write an Excel-File. I use it in one of my projects and
it works really good.
Hope that helps.
Comment
-
Re: PHP with Excel
ABC wrote:As mentioned, the Pear package works well.Hi,
Can i write to MS-Excel using PHP? I am using PHP 5 on Linux. Any help
would be appreciated!
>
Thanks,
Raghu
>
If your target spreadsheet is very complicated, though, you could always
just write out a csv file of the data, and use some VBA code in Excel to
import it as you saw fit.
This would however entail the user running macros when the sheet opens,
and not all folks like to do that.
Comment
-
Re: PHP with Excel
Cord-Heinrich Pahlmann wrote:
I second that - it works well and you have reasonable control overPEAR can nicely write an Excel-File. I use it in one of my projects and
it works really good.
http://pear.php.net/package/Spreadsheet_Excel_Writer
formatting so you can make sure that the exported file looks nice.
Pete
--
Comment
-
Re: PHP with Excel
ABC wrote:Hi,
Can i write to MS-Excel using PHP? I am using PHP 5 on Linux. Any help
would be appreciated!
Easy! Just give an XML, HTML, CSV or other file an ".xls"
extension. Excel will load it like it and display it and
manipulate it just fine.
Comment
-
Re: PHP with Excel
Sanders Kaufman wrote:
Really though - Spreadsheet_Exc ell_Writer is not that difficult and thereEasy! Just give an XML, HTML, CSV or other file an ".xls"
extension. Excel will load it like it and display it and
manipulate it just fine.
are good examples of its use on the web - it gives so much more with only a
little bit of learning.
Pete
--
Comment
Comment