PHPackages                             ljw/excel - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [PDF & Document Generation](/categories/documents)
4. /
5. ljw/excel

ActiveLibrary[PDF & Document Generation](/categories/documents)

ljw/excel
=========

my excel data

v2.2(8y ago)2951MITPHPPHP >=5.3.0

Since Jan 4Pushed 8y ago1 watchersCompare

[ Source](https://github.com/lejianwen/excel)[ Packagist](https://packagist.org/packages/ljw/excel)[ Docs](http://github.com/lejianwen/excel)[ RSS](/packages/ljw-excel/feed)WikiDiscussions master Synced 2mo ago

READMEChangelogDependencies (1)Versions (6)Used By (1)

excel
=====

[](#excel)

利用phpexcel读取数据, 依赖phpexcel

安装
==

[](#安装)

composer require "ljw/excel":"dev-master"

示例
==

[](#示例)

```
//先实例化对象
$excel = new \Ljw\Excel\Excel();
$excel->loadFile($file);

```

读取数据
----

[](#读取数据)

### excel中某行或者某列是公式

[](#excel中某行或者某列是公式)

```
// A列是公式
$excel->setCalculatedIndex('A');
// 5行是公式
$excel->setCalculatedIndex(5);

```

### 读取整个excel数据

[](#读取整个excel数据)

```
//按列读取整个excel中的数据
//请保证每个sheet中的数据都是按列分组的，即一列一组数据
$excel->loadDataFromExcelCol();
//按列读取整个excel中的数据
//请保证每个sheet中的数据都是按行分组的，即一行一组数据
$excel->loadDataFromExcelRow();
$data = $excel->getExcelData();

```

### 读取某个sheet中的数据

[](#读取某个sheet中的数据)

```
//读取sheet中的数据
$i=0; //sheet的索引值,从0开始
//按行分组读取，即每行一组数据
$excel->loadDataFromSheetRow($i);
//按列分组读取，即每列一组数据
$excel->loadDataFromSheetCol($i);
$data = $excel->getSheetData($i);

```

保存图片
----

[](#保存图片)

### 保存整个excel中的图片

[](#保存整个excel中的图片)

```
//图片保存路径
$path = '/data/';
//保存整个excel中的图片，返回图片路径数组
$excel->saveImagesFromExcel($path);
//只保存某个sheet的图片
$excel->saveImagesFromSheet(1,$path);
//如果只需要保存某列的图片或者某行的图片

$excel->saveRowImagesFromSheet(1,5,$image_path);  //保存第二个sheet中第5行的图片

$excel->saveColImagesFromSheet(0,'B',$image_path);   //保存第一个sheet中B列的图片
//获取图片数据
$images = $excel->getImages();

```

### 将图片数据加入到数据中

[](#将图片数据加入到数据中)

```
//图片数据加入到数据中
$excel->combineExcelData();
$all_data = $excel->getExcelData();
//某个sheet的数据
$sheet_data = $excel->getSheetData(1);

```

###  Health Score

29

—

LowBetter than 59% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity12

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity62

Established project with proven stability

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~41 days

Total

5

Last Release

3252d ago

Major Versions

v1.1 → v2.02017-01-05

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/15119474?v=4)[乐](/maintainers/lejianwen)[@lejianwen](https://github.com/lejianwen)

---

Top Contributors

[![lejianwen](https://avatars.githubusercontent.com/u/15119474?v=4)](https://github.com/lejianwen "lejianwen (12 commits)")

---

Tags

excelljw

### Embed Badge

![Health badge](/badges/ljw-excel/health.svg)

```
[![Health](https://phpackages.com/badges/ljw-excel/health.svg)](https://phpackages.com/packages/ljw-excel)
```

###  Alternatives

[liuggio/excelbundle

This is a Symfony2 Bundle helps you to read and write Excel files (including pdf, xlsx, odt), thanks to the PHPExcel library

3776.4M10](/packages/liuggio-excelbundle)[wisembly/excelant

72158.3k](/packages/wisembly-excelant)[arogachev/yii2-excel

ActiveRecord import and export based on PHPExcel for Yii 2 framework

6480.3k1](/packages/arogachev-yii2-excel)[dakota/cake-excel

CakePHP excel generator

2324.9k](/packages/dakota-cake-excel)[phpnt/yii2-export

Yii2 It saves data in xls, csv, word, html, pdf files.

158.9k](/packages/phpnt-yii2-export)[akeneo-labs/excel-connector-bundle

Akeneo PIM Excel connector bundle

166.4k](/packages/akeneo-labs-excel-connector-bundle)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)