| 代码如下 |
复制代码 |
|
$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这个类你可以到官网去下载哦。