note 50472 added to ref.xsl
| From: | venkatesh at lammersmedical dot com | Date: | Tue, 01 Mar 2005 14:17:51 +0000 |
| Subject: | note 50472 added to ref.xsl | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-85712@lists.php.net to get a copy of this message | ||
Here is function to read from the XSL sheet which is saved as a text file.
function ReadExcelSheet($filename){
$test=file($filename);
$ar1=str_replace("~[^\t]*\t","\t",$test);
$ar2=str_replace("~","",$ar1);
$ar=str_replace("³","",$ar2);
$temp=array();
for ($i=0; $i<count($ar); $i++) {
if((substr($ar[$i],0,1)!= "\t")){
if($ar[$i]!=="\r\n"){
array_push($temp,$ar[$i]);
}
}
}
$name=split("\t",$temp[0]);
$ExcelList=array();
for($i=1;$i<count($temp);$i++){
$split_result=split("\t",$temp[$i]);
array_push($ExcelList,$split_result);
}
$result=insert_into_array($ExcelList,0,$name);
return($result);
}
----
Manual Page -- http://www.php.net/manual/en/ref.xsl.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+50472
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+50472&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+50472&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+50472&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+50472&report=yes&reason=useless
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+50472&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+50472&report=yes
Search -- http://master.php.net/manage/user-notes.php