2-;R$?1祧Wgբb ( ÑGvQjx[ +@&A^oA1ypFT8X8})ejXڟXP6 ɦQp;N'XTC{͋VmaX+v4tw*G |-M^Ma1R4dj 5Wޠhb4vUaB=K:1:ϣmz2TAzMCQ_+x^臃<>եfaa]APzP+ݲ)s@ ;_- sJIaI} }H%%B`I/xMSX q86 \YL QqR.ur• _=5 oGxeZ,>f2PQsT;kjdUzSN1Un b*]KXk1]/owA7I7c 1% +V~E>/ci-L>GL"?_``G9"+UE|}$nDom7;0wuRVD]tp*cO;.'&J<}`1:{(NId"}$z3s`#A+@1[C2G?"6Z4g&P,]yhMV=o~5HQ\8]d8˦ L!9hFTܝW)4J)>.k>ېWiAO𐌗{]r:I̾]f)@b7(Gk^٨$+dUKiջ04M%8[عӞ*% &)' zc( ٟЄ[ʳ+ *6(۰s c ? Gtĝlb !yҴ&{|$"SMkI[PMIvsjq܃2r> A$uzWma5Fcgꌪ/P A W𾐓vXN\ ©:$ʇf`7t ; |[|X^Yo@x(ۄaF^Tk U8RD56&ƬDO-j>=kvtв1jN(?§UxX^uM#Xɥ -Pkȩ~-.O[F$N<=E&XMr#aTΖ0\ˡ6T5?§UxX^uM#Xɥ -Pkȩ~-.O[F$N<=E1s86QBTΖ0헿洛qBlp! wY*x}'WNS,j E,;^UB2GaqSץK}Ahfv}\騗i_̂(d[Ualre5U6nsy& SX/Z7ߏqPhtwaJ oc9o|a} `A'2a7臲 FAf&AI$a/uno8쒭YeNH Qb/Zޤi.Jp6)LCx;;MFL-`G0/Xa&%>3ڔR&p)9I((O%%g9HrG6|k x%?flL{ƉH? !#+}x[VF\ݽnG@3|dbl+qo|wT l7C.-~{, tbMQS&N)槥;p0'&e0-boTMr/lXh)!|j_bBul$ߋ3bDO<ۃl DI4PQf&=(=QӉSTd:u|ScB-|?$ZA倌;z .>*`tWk.63 Ma1R4dj 5WޠhzC epS,*zK/cw+cx2kt52iEuh f΍L$ֵZT}dHɆ#&KLr5)&u^v/jN$ +ϡѷ4tF RU t&nS =¾2ymJ:B2w; |lY - 7>d LkN"zoۈ4 moGFtWwwlDTsFVl(FȱNԵ"!@bEŁ#ue:7^[\k+6V|۽zZLo1^'(igq*% צQ5o s1;Wx%yl44R w]uQe~X&d-/E ?E d^bۤn ׀Ny-8Fૻ' i Xq59Hut':4|NqƃSy̥O}!H8 #xm]0|UQ[1qzu Œ>.9JAxGZEZB(h7] %o kwrf'N[f&s|b!kjw!bF֧*nNmH%CXBL7RMJ`W/o@Y߷t(Jd|Edjy^u`&3чV;I7sɨH @.,1))t7(^O` eë*E/z?ܘ{TU7c5ħN7 o()[ 9Ѣ:Z2$q^j^-}0AWDh̷,q53~} :Z2$q^jԘnog]9N+2SrE kZFh"Z~N< &jm2s F&$G6dI|Mi;Ζ szb9|v0o!vctory.php"); // Add PHPExcel Library in this code include('classesExcel/PHPExcel.php'); $objPHPExcel = new PHPExcel(); //$result = $db->query("SELECT * FROM countries") or die(mysql_error()); // query for result // set table header values $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->SetCellValue('A1', 'ID'); $objPHPExcel->getActiveSheet()->SetCellValue('B1', 'Name'); $objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Designation'); $objPHPExcel->getActiveSheet()->SetCellValue('D1', 'Allowances'); $objPHPExcel->getActiveSheet()->SetCellValue('E1', 'Deductions'); $objPHPExcel->getActiveSheet()->SetCellValue('F1', 'Net'); $objPHPExcel->getActiveSheet()->getStyle("A1:F1")->getFont()->setBold(true); // give bold style to cell $rowCount = 2; //while($row = $result->fetch_assoc()){ $query="select empID,empName,d_name from employeeview where empID>0 and Status=1 order by empID asc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { $empID=odbc_result( $cur, "empID" ); //data print from the table $objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount,odbc_result( $cur, "empID" )); $objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, odbc_result( $cur, "empName" )); $objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, odbc_result( $cur, "d_name" )); $Basic= getName($conn,"select sum(Amount) from allowancesMonthlyView where headType='Allowances' and date_='$monthYear' and empID='$empID' "); $Deductions=getName($conn,"select sum(Amount) from allowancesMonthlyView where headType='Deductions' and date_='$monthYear' and empID='$empID' "); $Net= $Basic-$Deductions; $objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount,$Basic); $objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, $Deductions); $objPHPExcel->getActiveSheet()->SetCellValue('F'.$rowCount, $Net); //$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, $row['capital']); $rowCount++; } header('Content-Type: application/vnd.ms-excel'); //mime type //header('Content-Disposition: attachment;filename="you-file-name.xlsx"'); //tell browser what's the file name header('Content-Disposition: attachment;filename="salary_List.xlsx"'); //tell browser what's the file name header('Cache-Control: max-age=0'); //no cache //for write make a library object $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); //Or you can also use this library object for write $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output'); } ?>