当前位置: 首页>>代码示例>>PHP>>正文

PHP PHPExcel_Writer_Excel2007::setOffice2003Compatibility方法代码示例

本文整理汇总了PHP中PHPExcel_Writer_Excel2007::setOffice2003Compatibility方法的典型用法代码示例。如果您正苦于以下问题：PHP PHPExcel_Writer_Excel2007::setOffice2003Compatibility方法的具体用法？PHP PHPExcel_Writer_Excel2007::setOffice2003Compatibility怎么用？PHP PHPExcel_Writer_Excel2007::setOffice2003Compatibility使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类PHPExcel_Writer_Excel2007的用法示例。


在下文中一共展示了PHPExcel_Writer_Excel2007::setOffice2003Compatibility方法的7个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: xlsToXslx

function xlsToXslx($file_name_input, $file_name_output)
{
    try {
        $objPHPexcel = PHPExcel_IOFactory::load($file_name_input);
        $objWriter = new PHPExcel_Writer_Excel2007($objPHPexcel);
        $objWriter->setOffice2003Compatibility(true);
        $objWriter->save($file_name_output);
        return true;
    } catch (Exception $e) {
        return false;
    }
}
开发者ID:ViktorKITP，项目名称:schedule，代码行数:12，代码来源:xlsToXlsx.php

示例2: generate

 public function generate($format = "Excel5", $docName = "Tabelle")
 {
     switch ($format) {
         case 'Excel2007':
             include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/Excel2007.php';
             $writer = new PHPExcel_Writer_Excel2007($this);
             $ext = 'xlsx';
             $header = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
             //supprime le pre-calcul
             $writer->setPreCalculateFormulas(false);
             break;
         case 'Excel2003':
             include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/Excel2007.php';
             $writer = new PHPExcel_Writer_Excel2007($this);
             $writer->setOffice2003Compatibility(true);
             $ext = 'xlsx';
             //supprime le pre-calcul
             $writer->setPreCalculateFormulas(false);
             break;
         case 'Excel5':
             include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/Excel5.php';
             $writer = new PHPExcel_Writer_Excel5($this);
             $ext = 'xls';
             break;
         case 'CSV':
             include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/CSV.php';
             $writer = new PHPExcel_Writer_CSV($this);
             $writer->setDelimiter(",");
             //l'op�rateur de s�paration est la virgule
             $writer->setSheetIndex(0);
             //Une seule feuille possible
             $ext = 'csv';
             break;
         case 'PDF':
             include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/PDF.php';
             $writer = new PHPExcel_Writer_PDF($this);
             $writer->setSheetIndex(0);
             //Une seule feuille possible
             $ext = 'pdf';
             break;
         case 'HTML':
             include dirname(__FILE__) . '/../3rdParty/Classes/PHPExcel/Writer/HTML.php';
             $writer = new PHPExcel_Writer_HTML($this);
             $writer->setSheetIndex(0);
             //Une seule feuille possible
             $ext = 'html';
             break;
     }
     header('Content-type:' . $header);
     header('Content-Disposition:inline;filename=' . $docName . '.' . $ext);
     $writer->save('php://output');
 }
开发者ID:quantrocket，项目名称:planlogiq，代码行数:52，代码来源:PFExcel.php

示例3: date

// 	{
// 		// Ligne accès
// 		$sheet->setCellValue('A'.$row_cnt,'No Images registered yet'); // Name
// 		$sheet->mergeCells('A'.$row_cnt.':'.numToLetter($theads_cnt).$row_cnt);
// 		$sheet->duplicateStyleArray($style_access_line,
// 			'A'.$row_cnt.':'.numToLetter($theads_cnt).$row_cnt
// 		);
// 	}
// 	else
// 	{
// 		// Ligne accès
// 		$sheet->setCellValue('A'.$row_cnt,basename($docAccess->basename,'.jpg')); // Name
// 		$sheet->setCellValue('B'.$row_cnt,str_replace(getFtpImagesRoot(),'',$docAccess->srcname)); // Document Name
// 		$sheet->setCellValue('C'.$row_cnt,$docAccess->getREWURL()); // Link
// 		$sheet->setCellValue('D'.$row_cnt,$docAccess->getFileSize()); // Size
// 		$sheet->duplicateStyleArray($style_access_line,
// 			'A'.$row_cnt.':'.numToLetter($theads_cnt).$row_cnt
// 		);
// 	}
// 	$sheet_indexes[$sheet_cnt-1][] = $row_cnt;
//     $i++; $row_cnt++;
// }
// $stmt = NULL;
// unset($stmt);
$workbook->setActiveSheetIndex(0);
$writer = new PHPExcel_Writer_Excel2007($workbook);
$writer->setOffice2003Compatibility(true);
header('Content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition:inline;filename=falcon_export_' . date('mdY') . '.xlsx');
// header('Content-type: application/vnd.ms-excel');
$writer->save('php://output');
开发者ID:Aphax，项目名称:markfalc，代码行数:31，代码来源:generate_reference_xlsx2007.php

示例4: array

 function download_csv($list)
 {
     require_once './application/libraries/PHPExcel/IOFactory.php';
     $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp;
     $cacheSettings = array(' memoryCacheSize ' => '15120MB');
     PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);
     ini_set('memory_limit', '1256M');
     $objPHPExcel = new PHPExcel();
     $objPHPExcel->setActiveSheetIndex(0);
     // baris pertama bold
     $objPHPExcel->getActiveSheet()->getStyle("A1:L1")->getFont()->setBold(true);
     // set width column
     $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(8);
     $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
     $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
     $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(17);
     $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);
     $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(10);
     $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(10);
     $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(46);
     $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20);
     $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20);
     $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(24);
     $objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(20);
     $objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(20);
     $objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(20);
     $objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(24);
     $objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(45);
     $objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(20);
     // alignment default left
     $objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
     // alignment cell
     $objPHPExcel->getActiveSheet()->getStyle('A2:P5')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
     $objPHPExcel->getActiveSheet()->getStyle('A2:P5')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
     //style
     $boldArray = array('font' => array('bold' => true));
     $objPHPExcel->getActiveSheet()->getStyle('A1:P5')->applyFromArray($boldArray);
     // merge cell
     $objPHPExcel->getActiveSheet()->mergeCells('A1:P1');
     $objPHPExcel->getActiveSheet()->mergeCells('A2:P2');
     $objPHPExcel->getActiveSheet()->mergeCells('A3:P3');
     $objPHPExcel->getActiveSheet()->mergeCells('A4:P4');
     // headernya
     $objPHPExcel->getActiveSheet()->SetCellValue('A2', strtoupper("REPORT"));
     $objPHPExcel->getActiveSheet()->SetCellValue('A3', strtoupper("FRISIAN FLAG"));
     $objPHPExcel->getActiveSheet()->SetCellValue('A5', "No");
     $objPHPExcel->getActiveSheet()->SetCellValue('B5', 'Trxid');
     $objPHPExcel->getActiveSheet()->SetCellValue('C5', 'Member id');
     $objPHPExcel->getActiveSheet()->SetCellValue('D5', 'Phone number');
     $objPHPExcel->getActiveSheet()->SetCellValue('E5', 'Reward code');
     $objPHPExcel->getActiveSheet()->SetCellValue('F5', 'Prod code');
     $objPHPExcel->getActiveSheet()->SetCellValue('G5', 'SKU');
     $objPHPExcel->getActiveSheet()->SetCellValue('H5', 'SMS Incoming Content');
     $objPHPExcel->getActiveSheet()->SetCellValue('I5', 'SMS Incoming Date');
     $objPHPExcel->getActiveSheet()->SetCellValue('J5', 'Send to link date');
     $objPHPExcel->getActiveSheet()->SetCellValue('K5', 'Response status form link');
     $objPHPExcel->getActiveSheet()->SetCellValue('L5', 'SMS outgoing content');
     $objPHPExcel->getActiveSheet()->SetCellValue('M5', 'SMS outgoing date');
     $objPHPExcel->getActiveSheet()->SetCellValue('N5', 'Send By');
     $objPHPExcel->getActiveSheet()->SetCellValue('O5', 'Outgouing delivery status');
     $objPHPExcel->getActiveSheet()->SetCellValue('P5', 'System Message');
     $rowCount_p = 6;
     $no_p = 1;
     // echo "<pre>";print_r($list); echo "</pre>";die();
     if ($list != null) {
         $no_p = 1;
         foreach ($list as $ls) {
             $objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount_p, $no_p++);
             $objPHPExcel->getActiveSheet()->SetCellValueExplicit('B' . $rowCount_p, $ls->trxid_links);
             $objPHPExcel->getActiveSheet()->SetCellValue('C' . $rowCount_p, $ls->memberid);
             $objPHPExcel->getActiveSheet()->SetCellValueExplicit('D' . $rowCount_p, $ls->msisdn);
             $objPHPExcel->getActiveSheet()->SetCellValue('E' . $rowCount_p, $ls->rewardcode);
             $objPHPExcel->getActiveSheet()->SetCellValue('F' . $rowCount_p, $ls->prodcode);
             $objPHPExcel->getActiveSheet()->SetCellValue('G' . $rowCount_p, $ls->sku);
             $objPHPExcel->getActiveSheet()->SetCellValue('H' . $rowCount_p, $ls->sms_from_mum);
             $objPHPExcel->getActiveSheet()->SetCellValueExplicit('I' . $rowCount_p, $ls->date_sms);
             $objPHPExcel->getActiveSheet()->SetCellValueExplicit('J' . $rowCount_p, $ls->date_sendlinks);
             $objPHPExcel->getActiveSheet()->SetCellValueExplicit('K' . $rowCount_p, $ls->code_links);
             $objPHPExcel->getActiveSheet()->SetCellValueExplicit('L' . $rowCount_p, $ls->sobject_sms_content);
             $objPHPExcel->getActiveSheet()->SetCellValueExplicit('M' . $rowCount_p, $ls->date_receive_smscomm);
             $objPHPExcel->getActiveSheet()->SetCellValueExplicit('N' . $rowCount_p, $ls->sendby);
             $objPHPExcel->getActiveSheet()->SetCellValueExplicit('O' . $rowCount_p, $ls->delivery_status_sms);
             $objPHPExcel->getActiveSheet()->SetCellValueExplicit('P' . $rowCount_p, $ls->sobject_message);
             // $objPHPExcel->getActiveSheet()->SetCellValueExplicit('P'.$rowCount_p, );
             $rowCount_p++;
         }
     }
     $date_time = date("Ymd His");
     $filename = str_replace(' ', '_', strtoupper("Report_" . $date_time));
     header("Pragma: public");
     header("Expires: 0");
     header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
     header("Content-Type: application/force-download");
     header("Content-Type: application/octet-stream");
     header("Content-Type: application/download");
     header("Content-Disposition: attachment;filename=" . $filename . ".csv");
     header("Content-Transfer-Encoding: binary ");
     $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
     $objWriter->setOffice2003Compatibility(true);
     $objWriter->save('php://output');
//.........这里部分代码省略.........
开发者ID:fajarantono，项目名称:distroApp，代码行数:101，代码来源:report.php

示例5: export2Excel

 public static function export2Excel($objPHPExcel, $versionExcel = 'Excel2007', $fileName = '')
 {
     switch ($versionExcel) {
         case 'Excel2007':
             // redirect output to client browser with Excel2007
             header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
             header('Content-Disposition: attachment;filename="' . $fileName . '.xlsx"');
             header('Cache-Control: max-age=0');
             $objWriter = new \PHPExcel_Writer_Excel2007($objPHPExcel);
             $objWriter->setOffice2003Compatibility(true);
             $objWriter->setPreCalculateFormulas(false);
             $objWriter->save('php://output');
             break;
         case 'Excel5':
             // redirect output to client browser with Excel 2005
             header('Content-Type: application/vnd.ms-excel');
             header('Content-Disposition: attachment;filename="' . $fileName . '.xls"');
             header('Cache-Control: max-age=0');
             $objWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);
             $objWriter->setPreCalculateFormulas(false);
             $objWriter->save('php://output');
             break;
         default:
             break;
     }
 }
开发者ID:khavq，项目名称:smdemo，代码行数:26，代码来源:ExcelUtility.php

示例6: exportExcelCustomerList

 private function exportExcelCustomerList($statistics)
 {
     $statuses = $this->getDoctrine()->getManager()->getRepository('CoreBundle:ProductStatus')->findAll();
     $excel = new \PHPExcel();
     $worksheet = $excel->getActiveSheet();
     $worksheet->setCellValueByColumnAndRow(0, 1, 'Customer');
     $column = 1;
     foreach ($statuses as $status) {
         $worksheet->setCellValueByColumnAndRow($column++, 1, $status->getName());
     }
     $row = 2;
     foreach ($statistics as $item) {
         $worksheet->setCellValueByColumnAndRow(0, $row, $item['customer']->getName());
         $column = 1;
         foreach ($statuses as $status) {
             $worksheet->setCellValueByColumnAndRow($column++, $row, empty($item['changes'][$status->getId()]) ? '0' : $item['changes'][$status->getId()]);
         }
         $row++;
     }
     header('Content-type: application/ms-excel');
     header('Content-Disposition: attachment; filename=report.xlsx');
     $objWriter = new \PHPExcel_Writer_Excel2007($excel);
     $objWriter->setPreCalculateFormulas(false);
     $objWriter->setOffice2003Compatibility(true);
     $objWriter->save('php://output');
     die;
 }
开发者ID:mishki-svami，项目名称:pa-core，代码行数:27，代码来源:StatisticsController.php

示例7: export

 /**
  * undocumented function
  *
  * @return void
  * @author apple
  **/
 function export()
 {
     $this->autoRender = FALSE;
     $node = isset($this->request->query['node']) ? $this->request->query['node'] : FALSE;
     if (!$node) {
         return FALSE;
     }
     // node
     $a_node = explode('/', $node);
     $q_node = end(explode('/', $node));
     $prefix = substr($q_node, 0, strripos($q_node, '_'));
     $value = substr($q_node, strripos($q_node, '_') + 1, 100);
     $roles = TRUE;
     $params = array();
     if ($prefix == 'grid_classm') {
         // 班级管理里面的班级
         $params['college'] = substr($a_node[0], strripos($a_node[0], '_') + 1);
         $params['grade'] = substr($a_node[1], strripos($a_node[1], '_') + 1);
         $params['subject'] = substr($a_node[2], strripos($a_node[2], '_') + 1);
         $classResut = ClassRegistry::init('TClass')->find('first', array('conditions' => array('TClass.Id' => $value)));
         $params['class'] = $classResut['TClass']['FName'];
         $data = $this->TPerson->getClassPersonResult($params['college'], $params['grade'], $params['subject'], $params['class'], FALSE);
         $roles = ClassRegistry::init('TChapterAdmin')->getRolesCase($this->uid, 'TClass', $value, 'export');
     } else {
         if ($prefix == 'grid_class') {
             // 学院管理里面的班级
             $classResut = ClassRegistry::init('TClass')->find('first', array('conditions' => array('TClass.Id' => $value)));
             $params['college'] = $classResut['TCollege']['FName'];
             $params['grade'] = date('Y', strtotime($classResut['TClass']['FStartdate']));
             $params['subject'] = $classResut['TSpecialty']['FName'];
             $params['class'] = $classResut['TClass']['FName'];
             $data = $this->TPerson->getClassPersonResult($params['college'], $params['grade'], $params['subject'], $params['class'], FALSE);
             $roles = ClassRegistry::init('TChapterAdmin')->getRolesCase($this->uid, 'TClass', $value, 'export');
         } else {
             if ($prefix == 'grid_college') {
                 // 学院
                 $classResut = ClassRegistry::init('TCollege')->find('first', array('conditions' => array('TCollege.Id' => $value)));
                 $params['college'] = $classResut['TCollege']['FName'];
                 $data = $this->TPerson->getCollegePersonResult($params['college'], FALSE);
                 $roles = ClassRegistry::init('TChapterAdmin')->getRolesCase($this->uid, 'TCollege', $value, 'export');
             } else {
                 if ($prefix == 'grid_grade') {
                     // 年级
                     $college = substr($a_node[0], strripos($a_node[0], '_') + 1);
                     $classResut = ClassRegistry::init('TCollege')->find('first', array('conditions' => array('TCollege.Id' => $college)));
                     $params['college'] = $classResut['TCollege']['FName'];
                     $params['grade'] = $value;
                     $data = $this->TPerson->getGradePersonResult($params['college'], $params['grade'], FALSE);
                     $roles = ClassRegistry::init('TChapterAdmin')->getRolesCase($this->uid, 'TCollege', $college, 'export');
                 } else {
                     // 专业
                     $college = substr($a_node[0], strripos($a_node[0], '_') + 1);
                     $grade = substr($a_node[1], strripos($a_node[1], '_') + 1);
                     $specialty = substr($a_node[2], strripos($a_node[2], '_') + 1);
                     $classResut = ClassRegistry::init('TClass')->find('first', array('conditions' => array('TCollege.Id' => $college, "date_format(TClass.FStartDate, '%Y')" => $grade, "TClass.FSpecialty" => $specialty)));
                     $params['college'] = $classResut['TCollege']['FName'];
                     $params['grade'] = $grade;
                     $params['subject'] = $classResut['TSpecialty']['FName'];
                     $data = $this->TPerson->getSubjectPersonResult($params['college'], $params['grade'], $params['subject'], FALSE);
                     $roles = ClassRegistry::init('TChapterAdmin')->getRolesCase($this->uid, 'TCollege', $college, 'export');
                 }
             }
         }
     }
     // roles
     if (!$roles) {
         exit('Access Denied！<br /><br />对不起，您没有此操作权限。');
     }
     // 导出EXCEL
     App::import('Vendor', 'PHPExcel/PHPExcel');
     if (class_exists('PHPExcel')) {
         if (!is_array($data)) {
             return FALSE;
         }
         foreach ($data as $key => $vals) {
             $objPHPExcel = new PHPExcel();
             $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
             $objWriter->setOffice2003Compatibility(true);
             //设置文档基本属性
             $objProps = $objPHPExcel->getProperties();
             $objProps->setCreator("NianCode");
             $objProps->setLastModifiedBy("NianCode");
             $objProps->setTitle("Office XLS Persons Document");
             $objProps->setSubject("Office XLS Persons Document");
             $objProps->setDescription("Office XLS Persons Document");
             $objProps->setKeywords("Office XLS Persons Document");
             $objProps->setCategory("Persons");
             $objPHPExcel->setActiveSheetIndex(0);
             $objActSheet = $objPHPExcel->getActiveSheet();
             //设置当前活动sheet的名称
             $objActSheet->setTitle('人员数据');
             // debug
             // echo '<pre>';print_r($data);exit;
             //由PHPExcel根据传入内容自动判断单元格内容类型
//.........这里部分代码省略.........
开发者ID:Demired，项目名称:CakeWX，代码行数:101，代码来源:PersonController.php


注：本文中的PHPExcel_Writer_Excel2007::setOffice2003Compatibility方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。