php ExcelReader 读取Excel类

作者:袖梨 2022-06-24
 代码如下 复制代码

$allow_url_override = 1; // set to 0 to not allow changed via post or get
if(!$allow_url_override || !isset($file_to_include))
{
 $file_to_include = "111com.net.xls";
}
if(!$allow_url_override || !isset($max_rows))
{
 $max_rows = 0; //use 0 for no max
}
if(!$allow_url_override || !isset($max_cols))
{
 $max_cols = 5; //use 0 for no max
}
if(!$allow_url_override || !isset($debug))
{
 $debug = 0;  //1 for on 0 for off
}
if(!$allow_url_override || !isset($force_nobr))
{
 $force_nobr = 1;  //force the info in cells not to wrap unless stated explicitly (newline)
}

require_once 'www.111com.net/reader.php';
$data = new spreadsheet_excel_reader();
$data->setoutputencoding('cpa25a');
$data->read($file_to_include);
error_reporting(e_all ^ e_notice);
echo "

";
function make_alpha_from_numbers($number)
{
 $numeric = "abcdefghijklmnopqrstuvwxyz";
 if($number  {
  return $numeric[$number];
 }
 else
 {
  $dev_by = floor($number/strlen($numeric));
  return "" . make_alpha_from_numbers($dev_by-1) . make_alpha_from_numbers($number-($dev_by*strlen($numeric)));
 }
}
echo "

" . make_alpha_from_numbers($i) . "
" . $row . " ";
    if($force_nobr)
    {
     $table_output[$sheet] .= "";
    }
    $table_output[$sheet] .= nl2br(htmlentities($data->sheets[$sheet]['cells'][$row][$col]));
    if($force_nobr)
    {
     $table_output[$sheet] .= "";
    }
    $table_output[$sheet] .= "
";
 $table_output[$sheet] = str_replace(" ","",$table_output[$sheet]);
 $table_output[$sheet] = str_replace(" ","",$table_output[$sheet]);
 $table_output[$sheet] = str_replace(" "," ",$table_output[$sheet]);
 if($debug)
 {
  $debug_output = print_r($data->sheets[$sheet],true);
  $debug_output = str_replace(" ","n",$debug_output);
  $debug_output = str_replace(" ","r",$debug_output);
  $table_output[$sheet] .= "
$debug_output
";
 }
 echo "sheet_html[$sheet] = "$table_output[$sheet]"; ";
}
echo "
function change_tabs(sheet)
{
 //alert('sheet_tab_' + sheet);
 for(i=0;i<" , count($data->sheets) , ";i++)
 {
  document.getelementbyid('sheet_tab_' + i).classname = 'tab_base';
 }
 document.getelementbyid('table_loader_div').innerhtml=sheet_html[sheet];
 document.getelementbyid('sheet_tab_' + sheet).classname = 'tab_loaded';

}
";
echo "

echo
"

"; echo "
www.111com.net

";
//echo "";
/*
echo "
";
print_r($data);
echo "
";
*/

// excelreader这个类你可以到官网去下载哦。

相关文章

精彩推荐