Php uses excel_class.php to operate Excel files & lt ;? Php // header ("Content-type: application/vnd. ms-excel"); // header ("Content-Disposition: attachment; Filename php use excel_class.php to operate Excel files
""); // Echo "warehouse inventory report \ t \ n"; // echo "pnumber \ tcounts \ t \ n "; $ data [0] [0] = "Warehouse Inventory Report"; $ data [0] [1] = ""; $ data [1] [0] = "pnumber "; $ data [1] [1] = "counts"; $ s = 2; for ($ I = 0; $ I
3) {$ str = trim ($ return ['sheet1'] [$ I] [$ j]). "-";} if ($ j = 5 & $ I> 3) {$ str. = strtr (trim ($ return ['sheet1'] [$ I] [$ j]), $ trans ). "-";} if (strpos ($ str, "M") | strpos ($ str, "male") {$ n = 38 ;} else {$ n = 34;} for ($ m = 0; $ m <10; $ m ++) {if ($ j = 20 + $ m) & $ I> 3) {if (trim ($ return [Sheet1] [$ I] [$ j]! = "") {// Echo $ str. ($ n + $ m ). "\ t ". trim ($ return [Sheet1] [$ I] [$ j]). "\ t \ n"; $ data [$ s] [0] = $ str. ($ n + $ m); $ data [$ s] [1] = trim ($ return ['sheet1'] [$ I] [$ j]); $ s ++ ;}}}} Create_Excel_File (dirname (_ FILE __). "\ ddd.xls", $ data);?>