PHP Libraries

Other libraries

PHP class library for generating Excel and other documents

Other libraries

Get it now

PHP class library for generating Excel and other documents

<?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

Disclaimer

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

How Do I Link Static Libraries That Depend on Other Static Libraries?

13Dec2024

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?$ How to Silence TensorFlow\'s Debugging Output?

28Oct2024

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?

03Jan2025

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?

30Oct2024

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?

27Dec2024

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 ?

24Oct2024

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

See all articles