Download the PHP package tianhe1986/fatexcel without Composer

On this page you can find all versions of the php package tianhe1986/fatexcel. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of tianhe1986/fatexcel

Informations about the package fatexcel

FatExcel

phpexcel / phpspreadsheet的功能非常全面，可对单元格进行各式各样的操作。 然而，它的缺点是，占用内存大，处理速度慢。在数据量小的时候可能没有影响，但是对于大数据量（例如10万+行），导入和导出花费的时间就会非常长。

为了解决这个问题，FatExcel基于其他的第三方开源类库，简单封装了大数据导入导出的方法。但是使用是有一定限制的，在后面会详细阐述。

安装

确保PHP版本在5.5以上。

推荐通过Composer进行安装

Composer的安装请参考官方配置。

安装好Composer后，在你的项目中创建一个 composer.json 文件：

然后在项目文件夹下执行:

之后添加autoloader:

导入

FatExcel类提供了importToArray方法，基于spreadsheet-reader封装，将excel文件直接导入为二维数组，使用方法如下：

要使用该方法，对应的excel文件需要满足的条件是：

导出

与导入相对的，是从二维数组直接导出成excel，基于PHP_XLSXWriter封装。使用方法如下：

对于单元格有格式要求的，可以通过表头数组进行设置，如下：

对于$header数组的每项key和value，key将作为表头写入表格，此列的其他单元格将按照value定义的格式进行写入。

导出的注意事项为：

All versions of fatexcel with dependencies

PHP Build Version
Package Version
Requires php Version >=5.5
mk-j/php_xlsxwriter Version ^0.37.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package tianhe1986/fatexcel contains the following files

Loading the files please wait ....