-
-
-
set_include_path('.'. PATH_SEPARATOR .
-
'D:ZealPHP_LIBS' . PATH_SEPARATOR .
-
get_include_path());
-
-
-
-
-
-
require_once 'PHPExcel.php';
-
-
-
-
-
-
$objExcel = new PHPExcel();
-
-
-
-
-
-
-
-
$objProps = $objExcel->getProperties();
-
$objProps->setCreator("Zeal Li");
-
$objProps->setLastModifiedBy("Zeal Li");
-
$objProps->setTitle("Office XLS Test Document");
-
$objProps->setSubject("Office XLS Test Document, Demo");
-
$objProps->setDescription("Test document, generated by PHPExcel.");
-
$objProps->setKeywords("office excel PHPExcel");
-
$objProps->setCategory("Test");
-
-
-
-
-
$objExcel->setActiveSheetIndex(0);
-
$objActSheet = $objExcel->getActiveSheet();
-
-
$objActSheet->setTitle('Test Sheet');
-
-
-
-
-
$objActSheet->setCellValue('A1', 'String content') ;
-
$objActSheet->setCellValue('A2', 26);
-
$objActSheet->setCellValue('A3', true);
-
$objActSheet->setCellValue('A4', '=SUM(A2:A2)' );
-
-
$objActSheet->setCellValueExplicit('A5', '847475847857487584', >
- PHPExcel_Cell_DataType::TYPE_STRING);
- //Merge cells
- $objActSheet->mergeCells('B1:C22');
- //Separate cells
- $objActSheet->unmergeCells('B1:C22');
- //******************************************
- //Set cell style
- //
- //Set width
- $objActSheet->getColumnDimension('B')->setAutoSize(true);
- $objActSheet->getColumnDimension('A')->setWidth(30);
- $objStyleA5 = $objActSheet->getStyle('A5');
- //Set the number format of the cell content.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
$objStyleA5
-
->getNumberFormat()
-
->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER);
-
-
$objFontA5 = $objStyleA5->getFont();
-
$objFontA5->setName('Courier New');
-
$objFontA5->setSize(10);
-
$objFontA5->setBold(true);
-
$objFontA5->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
-
$objFontA5->getColor()->setARGB('FF999999');
-
-
$objAlignA5 = $objStyleA5->getAlignment();
-
$objAlignA5->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
-
$objAlignA5->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
-
-
$objBorderA5 = $objStyleA5->getBorders();
-
$objBorderA5->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
-
$objBorderA5->getTop()->getColor()->setARGB('FFFF0000');
-
$objBorderA5->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
-
$objBorderA5->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
-
$objBorderA5->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
-
-
$objFillA5 = $objStyleA5->getFill();
-
$objFillA5->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
-
$objFillA5->getStartColor()->setARGB('FFEEEEEE');
-
-
$objActSheet->duplicateStyle($objStyleA5, 'B1:C22');
-
-
-
$objDrawing = new PHPExcel_Worksheet_Drawing();
-
$objDrawing->setName('ZealImg');
-
$objDrawing->setDescription('Image inserted by Zeal');
-
$objDrawing->setPath('./zeali.net.logo.gif');
-
$objDrawing->setHeight(36);
-
$objDrawing->setCoordinates('C23');
-
$objDrawing->setOffsetX(10);
-
$objDrawing->setRotation(15);
-
$objDrawing->getShadow()->setVisible(true);
-
$objDrawing->getShadow()->setDirection(36);
-
$objDrawing->setWorksheet($objActSheet);
-
-
$objExcel->createSheet();
-
$objExcel->getSheet(1)->setTitle('Test 2');
-
-
$objExcel->getSheet(1)->getProtection()->setSheet(true);
-
$objExcel->getSheet(1)->protectCells('A1:C22', 'PHPExcel' );
-
-
-
-
$outputFileName = "output.xls";
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
?>
-
from:zeroplace.cn
http://www.bkjia.com/PHPjc/478626.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/478626.htmlTechArticle? //Set the includepath of the PHPExcel class library set_include_path( . .PATH_SEPARATOR. D:ZealPHP_LIBS .PATH_SEPARATOR. get_include_path() ); /** www.2cto.com *The following are usage examples, for...
Statement:The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn