PHP

连接数据库：http://www.jb51.net/article/59155.htm

读写excel：

http://www.cnblogs.com/cocowool/p/4025852.html

http://www.jb51.net/article/55154.htm

替换字符函数 http://www.w3school.com.cn/php/func_string_str_replace.asp

例子：

function trimall($str)//删除空格  
{  
    $qian=array(" ","　","\t","\n","\r");  
         $hou=array("","","","","");  
    return str_replace($qian,$hou,$str);      
} 

输出函数：(php中var_dump()函数的详解说明)http://www.php100.com/html/php/hanshu/2013/0905/4344.html