<?php
require_once("Classes/PHPExcel.php");
$phpexcel = new PHPExcel();
$phpexcel = PHPExcel_IOFactory::createReader("Excel5")->load("template.xls");
$phpexcel->getProperties()->setCreator("Liu Jian") // 文档作者
->setLastModifiedBy("Liu Jian") // 最后一次修改者
->setTitle("Office 2003 XLS Test Document") // 标题
->setSubject("Office 2003 XLS Test Document") // 主题
->setDescription("Test document for Office 2003 XLS, generated using PHPExcel.") // 备注
->setKeywords("office 2003 openxml php") // 关键字
->setCategory("Test result file"); // 类别
$phpexcel->createSheet(1);
$sheet = $phpexcel->getSheet(1);Usually there are two ways to instantiate PHPExcel objects
1. Create a blank document through the new keyword
2. Create it by reading an existing template
The PHPExcel object after instantiation is similar to a document file temporarily stored in memory.
You can operate on it to modify the document data and set the document properties. By default, the newly created blank document (via new) There is only one worksheet (sheet), and its index (index) is 0
All resources on this site are contributed by netizens or reprinted by major download sites. Please check the integrity of the software yourself! All resources on this site are for learning reference only. Please do not use them for commercial purposes. Otherwise, you will be responsible for all consequences! If there is any infringement, please contact us to delete it. Contact information: admin@php.cn
Related Article
How Do I Link Static Libraries That Depend on Other Static Libraries?
13 Dec 2024
Linking Static Libraries to Other Static Libraries: A Comprehensive ApproachStatic libraries provide a convenient mechanism to package reusable...
How to Silence TensorFlow\'s Debugging Output?
28 Oct 2024
Suppression of Tensorflow Debugging OutputTensorflow prints extensive information about loaded libraries, found devices, and other debugging data...
How Does jQuery Simplify DOM Manipulation for Web Developers?
03 Jan 2025
Overflow: Hidden and Expansion of HeightjQuery distinguishes itself from other JavaScript libraries through its cross-platform compatibility and...
Which native Java image processing library is right for you?
30 Oct 2024
Native Java Image Processing Libraries for High-Quality ResultsAs you have encountered limitations with ImageMagick and JAI, let's explore other...
How to Execute Command Line Binaries in Node.js?
27 Dec 2024
Executing Command Line Binaries in Node.jsExecuting third-party binaries is an essential task when porting CLI libraries from other languages to...
How to Create and Utilize Static Libraries in g ?
24 Oct 2024
This article guides developers on crafting static libraries in C using g . It demonstrates how to compile source code into object files, create static libraries, and incorporate them into other projects. By leveraging this approach, developers can
Hot Tools
PHP library for dependency injection containers
PHP library for dependency injection containers
A collection of 50 excellent classic PHP algorithms
Classic PHP algorithm, learn excellent ideas and expand your thinking
Small PHP library for optimizing images
Small PHP library for optimizing images