On Thu, 2008-07-03 at 08:59 -0400, Dan Shirah wrote:
> Happy 4th of July!
How did you know it was my sisters birthday today? Been an exciting
week, first Canada's birthday was on Monday, now my sister's birthday
today. What a thrill ride.
>:)
Cheers,
Rob.
> I am having a little bit of a problem using PHPExcel. I think I'm doing
> everything right but apparently not! I am basically trying to output results
> of a query to Excel using PHPExcel.
>
> My query works fine, my variables are being passed correctly, my database
> connection is fine...within my while () loop the echo "This ".$stat_year."
> ".$stat_month."<br />\n"; properly returns all of the years and months for
> my query. But for whatever reason when I try and put those vaules in the
> Excel objects and export the spreadsheet, the values of my cells are always
> blank.
>
> Any ideas?
>
>
> /** PHPExcel */
> include 'PHPExcel.php';
>
> /** PHPExcel_Writer_Excel2007 */
> include 'PHPExcel/Writer/Excel5.php';
>
> // Create new PHPExcel object
> echo date('H:i:s') . " Create new PHPExcel object<br />\n";
> $objPHPExcel = new PHPExcel();
>
> // Add some data, we will use printing features
> $name_code = $_GET['name'];
> // echo $name;
> $case_age = $_GET['case_age'];
> // echo $case_age;
> $case_cat = $_GET['case_cat'];
> // echo $case_cat;
> $case_status = $_GET['case_status'];
> // echo $case_status;
> include 'Conn/prpr_ifx.php';
> if (!$connect_id = ifx_connect("$database@$host", $user, $pass)) { // THE
> ACTUAL CONNECTION
> echo "Unable to connect to Informix Database\n"; // DISPLAY IF
> CONNECTION FAILS
> exit();
> }
> $sql = "SELECT * FROM brev_pending_summary_detail WHERE name =
> '$name_code'";
> if (!empty($case_age)) {
> $sql.=" AND case_age_group = '$case_age'";
> }
> if (!empty($case_cat)) {
> $sql.=" AND case_category = '$case_cat'";
> }
> if (!empty($case_status)) {
> $sql.=" AND case_status = '$case_status'";
> } // Start our query of the database
> $query = ifx_query($sql, $connect_id);
>
> echo date('H:i:s') . " Add some data<br />\n";
> if(!empty($query)) {
> while ($row = ifx_fetch_row($query)) {
> $stat_year = $row['stat_year'];
> $stat_month = $row['stat_month'];
> echo "This ".$stat_year." ".$stat_month."<br />\n";
> $objPHPExcel->getActiveSheet()->setCellValue('A' . $stat_year);
> $objPHPExcel->getActiveSheet()->setCellValue('B' . $stat_month);
> }
> }
>
> // Set header and footer. When no different headers for odd/even are used,
> odd header is assumed.
> echo date('H:i:s') . " Set header/footer<br />\n";
> $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&C&HPlease
> treat this document as confidential!');
> $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B' .
> $objPHPExcel->getProperties()->getTitle() . '&RPage &P of &N');
>
> // Set page orientation and size
> echo date('H:i:s') . " Set page orientation and size<br />\n";
> $objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
> $objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
> $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
> $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
>
> // Rename sheet
> echo date('H:i:s') . " Rename sheet<br />\n";
> $objPHPExcel->getActiveSheet()->setTitle('Pending Summary');
>
>
> // Set active sheet index to the first sheet, so Excel opens this as the
> first sheet
> $objPHPExcel->setActiveSheetIndex(0);
>
>
> // Save Excel 5 file
> echo date('H:i:s') . " Write to Excel2005 format<br />\n";
> $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
> $objWriter->save(str_replace('.php', '.xls', __FILE__));
>
> // Echo done
> echo date('H:i:s') . " Done writing file.\r\n";
--
http://www.interjinn.com
Application and Templating Framework for PHP
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
