[convert string to number in excel]

Hello,

  I hve the excelwriter.inc.php which writes data into excel sheet. I have a few columns that are numbers but the entire data is written as string & I get "The number in this cell is formatted as text or preced by an apostrophe" message in the sheet . This is the line which writes data into the sheet:

fwrite($this->fp,"<td class=xl24 width=64 >".$col."</td>");

I hve tried using intval

fwrite($this->fp,"<td class=xl24 width=64 >".intval($col)."</td>");

but it still gives me the same message.

 

Please help, i m stuck becaouse of this!!

[Format excel cells]

Hello,

  I am writing data to a .xls file using fwrite.

$fp = fopen($xls_file, 'w');

fwrite($fp,$csv_data);

I want some cells in the file to be bold. How do we format it? I do not want to use the PEAR excel writer..

Thank you,

Ira

[Wikipedia]

Hello,
  Does anybody know how to integrate wikipedia results into a site? Is there any API for accessing the contents of wikipidea?

Please help,
Ira

[extract url from anchor tag]

Thanks for the help but let me explain in details what i exactly need.
  I want to search say www.domainname.com in other sites say www.ab.com,www.cc.com
  When i find that the domainname is present i want to retrieve the link as well as the text
i.e <a href="http://www.domainname.com">My domain</a>
the anchor text may also be like
<a href="http://www.domainname.com" target="_blank">My domain</a>
or
<a href="http://www.domainname.com"><font size="2">My domain</font></a>
and the output should be [b]www.domainname.com [/b]and [b]My domain[/b].

Please help!!!

[extract url from anchor tag]

I get an error for
$tag = '<a href="www.url.com/index.html">';
$url = ereg_replace('/<a href="(?!\")">/','\1',$tag);

besides the format can be either <a href="www.something.com/index.php">
or <a href='www.something.com'>

[extract url from anchor tag]

Hello,
  Can anyone please tell me how to extract the url from an anchor tag?
Eg:<a href="www.url.com/index.html">HTML Code </a>
I want www.url.com/index.html as well as HTML code....
Please help!!!

[Search for word in a string]

[!--quoteo(post=367944:date=Apr 24 2006, 12:30 PM:name=wisewood)--][div class=\'quotetop\']QUOTE(wisewood @ Apr 24 2006, 12:30 PM) [snapback]367944[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Run this code as is, and you'll see what it does. Any more help you might need, just yell.
[code]
<?php
$needle = "£";
$string = "If it costs £252.62 to buy something that should cost £300.00, you've bagged yourself a bargain and got it for £47.38 cheaper than it should have been.";
echo "<b>Original String:</b><br>$string<br><br>";

$number_of_occurances = substr_count("$string", "$needle");
echo "$needle appears $number_of_occurances times.<br><br>";

$count = 0;
while ($count<$number_of_occurances)
{
$string = substr($string, strpos("$string", "$needle")+1);
echo "$string<br><br>";        
$count++;
}

?>
[/code]
[/quote]


Thanks a lot...the code is great!!!!

[Search for word in a string]

But this will give me only the occurence of the first &pound , I need to get all the &pound appearing in the string, how do i do that :( ?

[Search for word in a string]

Hi,
I want to search for £ 14.23 i.e £ followed by decimal numbers occuring in a string.
Can someone tell me how to do it?

Regards,
Ira