>08\/03\/2016<<\/a><\/p>\n \n \u540e\u7eed\u5f00\u53d1\u65e5\u5fd7 Development Update\uff1a<\/p>\n >10\/04\/2016<<\/a><\/p>\n >\u524d\u5f80\u67e5\u8be2\u5668 Use the checker<<\/a><\/p>\n \u4ee5\u4e0b\u4e3a\u4e3b\u8981\u5f00\u53d1\u5185\u5bb9 The following is the main content\uff1a<\/p>\n \u8fd1\u51e0\u65e5\u5b8c\u6210\u4e86\u67e5\u8be2\u5668\u7684\u4e3b\u8981\u5f00\u53d1\u5de5\u4f5c\u5e76\u4e0a\u7ebf\u6d4b\u8bd5\u3002<\/p>\n Main development work has been finished\u00a0on these days, and the\u00a0tolerance checker has been launched into beta test.<\/p>\n \u9996\u5148\u662f\u786e\u8ba4\u4e86\u9700\u8981\u4f7f\u7528\u7684php excel reader\u5de5\u5177\uff0c\u8d44\u6e90\u6765\u81eaSourceForge\u4e0a\u7684\u4e00\u4e2a\u9879\u76ee:<PHP-ExcelReader><\/a> ;\u8c03\u7528\u65b9\u6cd5\u53c2\u8003\u4e86\u641c\u7d22\u5230\u7684\u8fd9\u7bc7\u65e5\u5fd7:<PHP ExcelReader\u7528\u6cd5><\/a><\/p>\n First, excel reader tool has been selected. It is a\u00a0SourceForge project:<PHP-ExcelReader><\/a>, and I find a Chinese\u00a0user<\/span> <\/span>manual by this link:<PHP ExcelReader\u7528\u6cd5><\/a><\/span><\/p>\n \u5176\u8c03\u7528\u65b9\u6cd5\u662f\uff1a<\/p>\n How to invoke the\u00a0PHP-ExcelReader:<\/p>\n [php] echo $data->sheets[0][‘cells’][i][j]; \/*read the (i,j)cell \u8fd9\u4e2a\u57fa\u672c\u7ed3\u6784\u662f\u9488\u5bf9\u67e5\u56fa\u5b9a\u8def\u5f84\u7684\u5355\u4e2aexcel\u8868\u683c\u7684\uff0c\u6211\u5148\u7f16\u5199\u4e86\u4e00\u4e2a3\u884c3\u5217excel\u8868\u683c\u8fdb\u884c\u6d4b\u8bd5\uff0c\u8868\u5355\u901a\u8fc7post\u5f62\u5f0f\u5c06\u9700\u8981\u7684\u5355\u5143\u683c\u4f4d\u7f6e(i,j)\u5c06\u8868\u5355\u4fe1\u606f\u544a\u77e5excel_reader\uff0creader\u8fd4\u56de\u67e5\u8be2\u6570\u636e\uff1a<\/p>\n The basic code structure of this tool is used to read a single work sheet in one .xls file by solid path. So I created a 3*3 excel sheet for test. Html form choices with (i,j) cell position are sent to\u00a0excel_reader by ‘post’ method, which would return and print out the checking result by code below.<\/p>\n [php]<\/p>\n echo $data->sheets[0][‘cells’][$_POST["row"]][$_POST["column"]];<\/p>\n [\/php]<\/p>\n \u6d4b\u8bd5\u7ed3\u679c\u5982\u56fe1,\u00a0\u6210\u529f!\u8fdb\u5165\u4e0b\u4e00\u6b65\u5f00\u53d1\u3002<\/p>\n Test was successful as fig.1! Next step.<\/p>\n \u56fe.1(Fig.1)<\/p>\n \u6839\u636e\u65e5\u5fd7>2<<\/a>\u4e2d\u56fe2\u7684\u903b\u8f91\u4e0e\u6587\u4ef6\u7ed3\u6784\uff0c\u9700\u8981\u67e5\u8be2\u4e0d\u540c\u8def\u5f84\u4e0b\u4e0d\u540cxls\u7684\u6587\u4ef6\uff0c\u8def\u5f84\u7531\u8868\u5355\u8f93\u51fa\u7684\u6570\u636e\u51b3\u5b9a\uff0c\u6240\u4ee5excel_reader\u8bfb\u53d6\u8def\u5f84\u5904\u4e0d\u80fd\u518d\u586b\u5199\u5b9a\u503c\uff0c\u6545\u5728\u8fd9\u4e4b\u524d\u5b9a\u4e49\u4e86\u4e00\u4e2a\u53d8\u91cf$path,\u00a0\u540c\u6837\u91c7\u53d6post\u7684\u5f62\u5f0f\u83b7\u53d6\u8868\u5355\u6570\u636e\u5e76\u7f16\u5199\u8def\u5f84\uff0c\u7136\u540e\u8ba9reader\u8bfb\u53d6$path\u8def\u5f84\uff1a<\/p>\n According to logic and files structure posted on fig.2 of log\u00a0>2<<\/a>\u00a0, the checker must visit different folders and pick out the exact .xls database file from dozens of them. In other words, the file path and the name of file should be variables. So I\u00a0define a\u00a0$path\u00a0variable which get message from the form by post method as well. And the reader will read the $path instead of solid path.<\/p>\n [php]<\/p>\n $path="db\/".$_POST["type"]."\/".$_POST["zone"].".xls";<\/p>\n \u2026\u2026<\/p>\n $data->read($path);<\/p>\n [\/php]<\/p>\n \u7531\u4e8e\u6211\u53ea\u5728\u4e00\u4e2a\u6587\u4ef6\u5939\u91cc\u5b58\u653e\u4e86\u4e00\u4e2adb.xls\u6587\u4ef6\uff0c\u5f53\u6211\u5728\u8868\u5355\u9009\u62e9\u4e86\u4e00\u4e2a\u7a7a\u8def\u5f84\u7684\u65f6\u5019\u6216\u8005\u6211\u6ca1\u6709\u586b\u5199\u5b8c\u6240\u6709\u8868\u5355\u9879\u5374\u63d0\u4ea4\u4e86\u8868\u5355\uff0creader\u8fd4\u56de\u4e86”The filename \u2026\u2026.xls is not readable”\u7684\u9519\u8bef\u4fe1\u606f\uff0c\u6211\u610f\u8bc6\u5230\u6574\u4e2a\u5355\u9009\u8868\u5355\u5fc5\u987b\u586b\u5199\u5b8c\u6210\u624d\u80fd\u63d0\u4ea4\u3002\u641c\u7d22\u4e86\u8bb8\u591a\u65b9\u6cd5\uff0c\u4e00\u5f00\u59cb\u53d1\u73b0\u9700\u8981\u901a\u8fc7js\u7b49\u5de5\u5177\u8fdb\u884c\u8868\u5355\u9a8c\u8bc1\uff0c\u5f39\u51fa\u63d0\u9192\u6846\u7b49\u7b49\u7b49\u3002\u8e0f\u7834\u94c1\u978b\u65e0\u89c5\u5904\u5f97\u6765\u5168\u4e0d\u8d39\u5de5\u592b\uff0chtml5\u76f4\u63a5\u63d0\u4f9b\u4e86\u8868\u5355\u5fc5\u586b\u7684\u9a8c\u8bc1\uff0c\u5728input\u91cc\u6dfb\u4e0a\u77ed\u77ed\u4e00\u53e5\u4fbf\u53ef\uff1a<\/p>\n I uploaded only one db.xls file to the database folder, then I found a problem when I select a wrong path or leave some form blank \u2014\u2014 reader told me that \u2018The filename \u2026\u2026.xls is not readable\u2019. And I realized I must set something for form correction. So many methods told me to use js code or else when the exactly excellent answer is so simple that you should write only 2 word in the <input>, thanks to html5 :<\/p>\n [html]<\/p>\n required="required"<\/p>\n [\/html]<\/p>\n \u5269\u4e0b\u7684\u5c31\u8ba9\u6d4f\u89c8\u5668\u6765\u505a\u5c31\u597d\u4e86\uff0c\u5982\u56fe2<\/p>\n The <\/span>rest<\/span> <\/span>of<\/span> the <\/span>work? Browsers will do for you as fig.2!<\/span><\/p>\n \u56fe.2(Fig.2)<\/p>\n \u663e\u7136\uff0c\u5982\u4e0a\u56fe\uff0c\u6211\u7528div\u628a\u8868\u5355\u6846\u8d77\u6765\u5e76\u7a0d\u5fae\u7f8e\u5316\u4e86\u4e00\u4e0b\u3002<\/p>\n Obviously, I beautified the page by <div> tag.<\/p>\n \u4e3b\u8981\u7684\u95ee\u9898\u90fd\u89e3\u51b3\u4e86\uff0c\u5c31\u628a\u8868\u5355\u4fee\u6539\u4e3a\u6b63\u5f0f\u7684\u6781\u9650\u504f\u5dee\u67e5\u8be2\u5668\u9879\u76ee\uff0c\u7136\u540e\u4e0a\u4f20\u4e86\u4e00\u4e2a\u5b8c\u6574\u6570\u636e\u7684.xls\u6570\u636e\u8868\uff0c\u6781\u9650\u504f\u5dee\u67e5\u8be2\u5668\u6b63\u5f0f\u8fdb\u5165\u7ebf\u4e0abeta\u6d4b\u8bd5!<\/p>\n Works done and problems solved. The html form was changed into real tolerance checker type. And I uploaded the first database .xls file with useful tolerance data. It is beta test now!<\/p>\n
\n
\n
\nrequire_once ‘Excel\/reader.php’;
\n$data = new Spreadsheet_Excel_Reader(); \/*invoking reader*\/
\n$data->setOutputEncoding(‘UTF-8’); \/*text output encoding*\/
\n$data->read(‘db.xls’); \/*read the excel sheet*\/<\/p>\n
\n and output data*\/
\n[\/php]<\/p>\n![\"20160317-checker_devlop_log-1\"](\"http:\/\/goyuwei.com\/blog\/wp-content\/uploads\/2016\/03\/20160317-checker_devlop_log-1.jpg\")
<\/a><\/p>\n![\"20160317-checker_devlop_log-2\"](\"http:\/\/goyuwei.com\/blog\/wp-content\/uploads\/2016\/03\/20160317-checker_devlop_log-2.jpg\")
<\/a><\/p>\n
![\"20160317-checker_devlop_log-3\"](\"http:\/\/goyuwei.com\/blog\/wp-content\/uploads\/2016\/03\/20160317-checker_devlop_log-3.jpg\")
<\/a><\/p>\n