PHP XLSX Cheetsheet

Functions

Setup

setTitle($title='') setSubject($subject='') setAuthor($author='') setCompany($company='') setKeywords($keywords='') setDescription($description='') setTempDir($tempdir='') setRightToLeft($isRightToLeft=false)

Output

writeToStdOut() writeToString() writeToFile($filename)

Cell writing

writeSheetHeader($sheet_name, array $header_types, $col_options = null) writeSheetRow($sheet_name, array $row, $row_options=null) countSheetRows($sheet_name = '') markMergedCell($sheet_name, $start_cell_row, $start_cell_column, $end_cell_row, $end_cell_column) writeSheet(array $data, $sheet_name='', array $header_types=array())

That's all. Nothing more you can use or need.

Style

These are allowed for style font=Arial|Courier New|Times New Roman|Comic Sans MS font-size=10 font-style=bold fill=#eee halign=left|right|center|none border=left,right,top,bottom font-style=bold|italic|underline|strikethrough color=#f00 fill=#ffc
Published
1-Oct-2022
Updated
1-Oct-2022