Category Archives: PHPExcel

Update Excel Content

 

Set cell value as string

Get text value of a RichTextObject

 

Read Excel

Reference:

PHPExcel Ultimate Example

 

PHPExcel

常用方法:

Memory Exausted Issue

http://jeffath.pixnet.net/blog/post/53919683-phpexcel%E8%A8%98%E6%86%B6%E9%AB%94%E4%BD%BF%E7%94%A8%E9%87%8F%E9%81%8E%E5%A4%A7

Date value from Excel to PHP

$sheet -> getCell(‘A1’) -> getValue()

If the value is a “date”, then this statement will get a “number”.

To convert this number for PHP to use:

Reference:

Set Widths of Columns

Example: