用php编写读取excel数据的程序怎么写?思路是什么? 我想知道php编写的读取excel数据的程序如何实现的?他的思路是什么? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 //应用begin$workbook = "excelfile.xls"; $sheet = "sheet1"; //读取excelfile.xls文件Read_Excel_File($workbook,$return); for ($i=1;$i<count($return[$sheet]);$i++){ echo $return[$sheet][$i][0]; echo $return[$sheet][$i][1]; ......}//应用end再包含以下读取xls的class:<?define('ABC_CRITICAL', 0);define('ABC_ERROR', 1);define('ABC_ALERT', 2);define('ABC_WARNING', 3);define('ABC_NOTICE', 4);define('ABC_INFO', 5);define('ABC_DEBUG', 6);define('ABC_TRACE', 7);define('ABC_VAR_DUMP', 8);define('ABC_NO_LOG', -1);$php_version = split( "\.", phpversion() );if( $php_version[0] == 4 && $php_version[1] <= 1 ) { if( !function_exists('var_export') ) { function var_export( $exp, $ret ) {ob_start();var_dump( $exp );$result = ob_get_contents();ob_end_clean();return $result;}}}function print_bt(){print "<code>\n";$cs = debug_backtrace();for( $i = 1; $i < count($cs) ; $i++ ){$item = $cs[ $i ];for( $j = 0; $j < count($item['args']); $j++ )if( is_string($item['args'][$j]) )$item['args'][$j] = "\"" . $item['args'][$j] . "\"";$args = join(",", $item['args'] );if( isset( $item['class'] ) )$str = sprintf("%s(%d): %s%s%s(%s)",$item['file'],$item['line'],$item['class'],$item['type'],$item['function'],$args );else$str = sprintf("%s(%d): %s(%s)",$item['file'],$item['line'],$item['function'],$args );echo $str . "<br>\n";}print "</code>\n";}function _die( $str ){print "Script died with reason: $str<br>\n";print_bt();exit();}class DebugOut{var $priorities = array(ABC_CRITICAL => 'critical', ABC_ERROR => 'error', ABC_ALERT => 'alert', ABC_WARNING => 'warning', ABC_NOTICE => 'notice', ABC_INFO => 'info', ABC_DEBUG => 'debug', ABC_TRACE => 'trace', ABC_VAR_DUMP => 'dump' );var $_ready = false;var $_currentPriority = ABC_DEBUG;var $_consumers = array();var $_filename;var $_fp;var $_logger_name; 这个类太长了帖不上,自己在网上搜索,名叫excel_class.php 如何截取别人信息 请教一个关于读取文件类型的问题!急!!!!!!!!!! PHP插件(钩子)机制的疑惑 zend encoder 和 Zend Optimizer 和 zend studio 有啥区别?? 字符串'k:\mrp\PhotoPath\',在php中怎麼寫呀? 在第一页定义了cookie变量并赋了值,为什么在另一个页面该变量就为空了!! 向MYSQL中取出数据的问题! COOKIE的问题? 关于PHP接收SOCKET php加ACCESS崩溃的乱码 PHP 遇到个问题。。 想找份在武汉干PHP的活好难
$workbook = "excelfile.xls";
$sheet = "sheet1";
//读取excelfile.xls文件
Read_Excel_File($workbook,$return);
for ($i=1;$i<count($return[$sheet]);$i++){
echo $return[$sheet][$i][0];
echo $return[$sheet][$i][1];
......
}
//应用end再包含以下读取xls的class:<?
define('ABC_CRITICAL', 0);
define('ABC_ERROR', 1);
define('ABC_ALERT', 2);
define('ABC_WARNING', 3);
define('ABC_NOTICE', 4);
define('ABC_INFO', 5);
define('ABC_DEBUG', 6);
define('ABC_TRACE', 7);
define('ABC_VAR_DUMP', 8);
define('ABC_NO_LOG', -1);
$php_version = split( "\.", phpversion() );
if( $php_version[0] == 4 && $php_version[1] <= 1 ) {
if( !function_exists('var_export') ) {
function var_export( $exp, $ret ) {
ob_start();
var_dump( $exp );
$result = ob_get_contents();
ob_end_clean();
return $result;
}}}function print_bt()
{
print "<code>\n";
$cs = debug_backtrace();
for( $i = 1; $i < count($cs) ; $i++ )
{
$item = $cs[ $i ];
for( $j = 0; $j < count($item['args']); $j++ )
if( is_string($item['args'][$j]) )
$item['args'][$j] = "\"" . $item['args'][$j] . "\"";
$args = join(",", $item['args'] );
if( isset( $item['class'] ) )
$str = sprintf("%s(%d): %s%s%s(%s)",
$item['file'],
$item['line'],
$item['class'],
$item['type'],
$item['function'],
$args );
else
$str = sprintf("%s(%d): %s(%s)",
$item['file'],
$item['line'],
$item['function'],
$args );
echo $str . "<br>\n";
}print "</code>\n";
}function _die( $str )
{
print "Script died with reason: $str<br>\n";
print_bt();
exit();
}
class DebugOut
{
var $priorities = array(ABC_CRITICAL => 'critical',
ABC_ERROR => 'error',
ABC_ALERT => 'alert',
ABC_WARNING => 'warning',
ABC_NOTICE => 'notice',
ABC_INFO => 'info',
ABC_DEBUG => 'debug',
ABC_TRACE => 'trace',
ABC_VAR_DUMP => 'dump'
);
var $_ready = false;
var $_currentPriority = ABC_DEBUG;
var $_consumers = array();
var $_filename;
var $_fp;
var $_logger_name;