chenmobuys/easyexcel

PHP的电子表格库。

维护者

详细信息

github.com/chenmobuys/easyexcel

源代码

问题

安装: 3

依赖关系: 0

建议者: 0

安全: 0

星标: 0

关注者: 0

分支: 0

开放问题: 0

1.0.0 2024-04-19 07:56 UTC

Requires

  • php: ^7.1||^8.0
  • ext-fileinfo: *
  • ext-libxml: *
  • ext-simplexml: *
  • ext-xml: *
  • ext-xmlreader: *
  • ext-xmlwriter: *
  • ext-zip: *

Requires (Dev)

Suggests

  • ext-iconv: Parsing csv xls files requires encoding conversion.
  • ext-mbstring: Parsing csv xls files requires encoding conversion.

MIT af58c538e2ac2cf552920b52718da23e5efd8104

  • Chenmobuys <chenmobuys.woop@gmail.com>

phpexcelspreadsheetxlsxlsxcsvwriterreadersheetPHPExcelodsofficeworksheetmsexcel

This package is auto-updated.

Last update: 2024-09-25 06:31:44 UTC

README

Build Status License Platform Support

简介 Summary

使用约3MB的内存读取和写入大型电子表格，支持格式CSV、ODS、XLS、XLSX。

使用约3MB的内存读取和写入大型电子表格，支持格式CSV、ODS、XLS和XLSX。

环境要求 Environment

  • PHP版本 ^7.1||^8.0
  • PHP扩展 xml
  • PHP扩展 libxml
  • PHP扩展 fileinfo
  • PHP扩展 simplexml
  • PHP扩展 xmlreader
  • PHP扩展 xmlwriter
  • PHP扩展 iconv (建议)
  • PHP扩展 mbstring (建议)

安装 Install

composer require chenmobuys/easyexcel

使用方法 Usage

<?php

use EasyExcel\Factory;
use EasyExcel\Metadata\Style;

// read excel
$filename = "/path/to/sample.xlsx";
$reader = Factory::load($filename);
foreach ($reader->getRowIterator() as $row) {
    $rowArray = $row->toArray();
}

// write excel
$filename = "/path/to/sample.xlsx";
$writer = Factory::open($filename);
$writer->addRow(["Foo", "Bar"])->close();

// write excel with style
$filename = "/path/to/sample.xlsx";
$writer = Factory::open($filename);
$style = Style::builder()
    ->setFontSize(12)
    ->setFontColor(Style\Color::RED)
    ->build();
$writer->addRow(["Foo", "Bar"], $style)->close();

参考 Refer