shuchkin/simplexlsxgen

• tag <raw> for styled raw values

• hyperlinks to local files
• num2name static now

• added SimpleXLSXGen::create($title = null) to create empty book with title
• added SimpleXLSXGen::save to save xlsx in current folder as title.xslx or curdate.xlsx
• SimpleXLSXGen::esc and SimpleXLSXGen::date2excel static now
• added examples SimpleXLSXGen::create, SimpleXSLXGen::raw, SimpleXLSXGen:save in README.md
• fixed fpassthru disabled issue
• fixed empty book, A1 empty now, text No data removed
• thx Javier

• force little endian numbers in zip headers

• simple linebreaks

• fixed issue 128 date2excel type cast

• preserve leading or traling spaces

• added meta: setTitle, setSubject, setAuthor, setCompany, setManager, setKeywords, setDescription, setCategory, setApplication, setLastModifiedBy. Thx Oleg Kosarev

• fixed "This action doesn't work on multiple selection" error

• $xlsx->rightToLeft() - RTL mode. Column A is on the far right, Column B is one column left of Column A, and so on. Also, information in cells is displayed in the Right to Left format.

• <style font-size="32">Big Text</style> - font size in cells, thx Andrew Robinson

• freezePanes( corner_cell ) - freezePanes to keep an area of a worksheet visible while you scroll, corner_cell is not included, thx Javier

• added borders <style border="medium">Black Border</style> see colored examples
• added formulas <f v="100">SUM(B1:B10)</f> see examples
• added internal links <a href="sheet2!A1">Go to page 2</a>
• added custom number formats <style nf="&quot;£&quot;#,##0.00">500</style>
• added 3 currencies $data = [ ['$100.23', '2000.00 €', '1200.30 ₽'] ];

• added autoFilter( $range )

$xlsx->autoFilter('A2:B10');

• fixed 0% bug

• added wrap words in long strings <wraptext>long long line</wraptext>

• added example JS array to Excel (AJAX)

• setColWidth(num_col_started_1, size_in_chars) - set column width

• Vertical align (tags top,middle,bottom) <bottom>12345</bottom>

• Row height <style height="50">Custom row height 50</style>

• Added colors <style color="#FFFF00" bgcolor="#00FF00">Yellow text on blue background</style>, thx mrjemson

• Added $xlsx->mergeCells('A1:C1')

• sheet name maximum length is 31 chars, mb_substr used now
• license fixed

• namespace added, use Shuchkin\SimpleXLSXGen

• fixed dates if year < 1900 and time only cells, thx fapth

• Escape \x00 and \x0B (vertical tab)

• Fixed saveAs / downloadAs / etc methods more than once

• Fixed sheet names duplicates (Page, Page (1), Page (2)...)

• Fixed sheet names duplicates

• Fixed email regex

• Fixed " and & in sheets names

• Fixed "&" in hyperlinks

• Fixed mailto hyperlinks detection

• Added mailto hyperlinks support (thx Howard Martin)

SimpleXLSXGen::fromArray([
	['Mailto hyperlink', '<a href="mailto:[email protected]">Please email me</a>']
])->saveAs('test.xlsx');

• Fixed hyperlinks in several sheets
• Added Opencollective donation link

• Fixed hyperlink regex

• Fixed 0.00% format, thx marcrobledo, more examples in README.md

Stable release

• Added hyperlinks and minimal formatting

• Added PHP Datetime object values in a cells

• Percent support

• Fix local floats in XML

• Added multiple sheets support, thx Savino59, class ready for extend now

• Updated images

• Disable type detection if string started with chr(0)

• Numbers like SKU right aligned now

• Fixed fast shared strings index

• Fixed real numbers in 123.45 format detection, fast shared strings index (thx fredriksundin)

• Fixed time detection in HH:MM:SS format

• Escape of shared strings for special chars in cells #1

• Fixed num2name A-Z,AA-AZ column names, thx Ertan Yusufoglu