Select Code to Download

add_format(%properties)
  The "add_format()" method can be used to create new Format objects w
+hich
  are used to apply formatting to a cell. You can either define the
...

  See the "CELL FORMATTING" section for more details about Format
  properties and how to set them.

  One problem with the "write()" method is that occasionally data look
+s
  like a number but you don't want it treated as a number. For example
+,
  zip codes or ID numbers often start with a leading zero. If you writ
+e
...
  will be treated as strings and the zeros will be preserved. See the
  "keep_leading_zeros()" section for a full discussion of this issue.
 More  -- ...

 See the note about "Cell notation". The $format parameter is optional

 In general it is sufficient to use the "write()" method.
...

     $worksheet->write_string(0, 0, 'Your text here' );
     $worksheet->write_string('A2', 'or here' );