一聚教程网:一个值得你收藏的教程网站

热门教程

php ExcelReader 读取Excel类

时间:2022-06-24 19:09:46 编辑:袖梨 来源:一聚教程网

 代码如下 复制代码

$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 "";
echo "


";
for($sheet=0;$sheetsheets);$sheet++)
{
 echo "
";
}

echo
"

";
echo "
  onmousedown="change_tabs($sheet);">", $data->boundsheets[$sheet]['name'] , "

www.111com.net

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

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

热门栏目