phpeveryday.com

PHP Excel Report Step By Step Tutorial: Until previous tutorial, we always write cell use string type. In this excel class, we can use several types: string, number, note, blank, url, formula.

String

Write a string to the specified row and column (zero indexed). There is an Excel 5 defined limit of 255 characters.

Number

Write a double to the specified row and column (zero indexed). An integer can be written as a double. Excel will display an integer.

Note

Writes a note associated with the cell given by the row and column. Records don't have a length limit.

Blank

Write a blank cell to the specified row and column (zero indexed). A blank cell is used to specify formatting without adding a string or a number. A blank cell without a format serves no purpose. Therefore, we don't write a BLANK record unless a format is specified. This is mainly an optimisation for the write_row() and write_col() methods.

Formula

Write a formula to the specified row and column (zero indexed)

Url

Write a hyperlink. This is comprised of two elements: the visible label and the invisible link. The visible label is the same as the link unless an alternative string is specified. The label is written using the write_string() method. Therefore the 255 characters string limit applies. $string and $format are optional and their order is interchangeable. The hyperlink can be to a http, ftp, mail, internal sheet, or external directory url.

Example:

Result: