', null],
['Word wrap', "Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book"],
['Linebreaks', "Line 1nLine 2nLine 3"]
];
SimpleXLSXGen::fromArray($data)
->setDefaultFont('Courier New')
->setDefaultFontSize(14)
->setColWidth(1, 35)
->mergeCells('A20:B20')
->saveAs('styles_and_tags.xlsx');">
' , null ],
[ ' Word wrap ' , " Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book " ],
[ ' Linebreaks ' , " Line 1 n Line 2 n Line 3 " ]
];
SimpleXLSXGen :: fromArray ( $ data )
-> setDefaultFont ( ' Courier New ' )
-> setDefaultFontSize ( 14 )
-> setColWidth ( 1 , 35 )
-> mergeCells ( ' A20:B20 ' )
-> saveAs ( ' styles_and_tags.xlsx ' );
Sequências RAW
Prefixe o valor da célula #0 (use aspas duplas) ou use o método ::raw() ou a tag
Go to second sheet'],
['http', 'https://example.com/'], // autodetect
['http + hash', 'https://en.wikipedia.org/wiki/Office_Open_XML#References'], // autodetect
['external anchor', 'Open XML'],
['relative link', 'books'],
['relative link + cell addr', 'link to second sheet in other book'],
['mailto', '[email protected]'], // autodetect
['mailto 2', 'Please email me'],
])->addSheet([['Second sheet']], 'My books 2')->saveAs('hyperlinks.xlsx');
// Autofilter
$xlsx->autoFilter('A1:B10');
// Freeze rows and columns from top-left corner up to, but not including,
// the row and column of the indicated cell
$xlsx->freezePanes('B2'); // B1 - freeze first column, A2 - freeze top row
// 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.
$xlsx->rightToLeft();
// Set Meta Data Files
// this data in propertis Files and Info file in Office
$xlsx->setAuthor('John Doe ')
->setCompany('JD LLC ')
->setManager('Jane Doe ')
->setLastModifiedBy("John Doe ")
->setTitle('My Books')
->setSubject('My bookshelf')
->setKeywords('Tolkien,Rowling,Kipling')
->setDescription('Cool books worn by time')
->setCategory('Books')
->setLanguage('en-US')
->setApplication('ShuchkinSimpleXLSXGen')">
// Fluid interface, output to browser for downloadShuchkinSimpleXLSXGen :: fromArray ( $ books )-> downloadAs ( ' table.xlsx ' );
// Fluid interface, multiple sheetsShuchkinSimpleXLSXGen :: fromArray ( $ books , ' My books ' )-> addSheet ( $ books2 )-> download ();
// Alternative interface, sheet name, get xlsx content$ xlsx_cache = ( string ) ( newShuchkinSimpleXLSXGen )-> addSheet ( $ books , ' Modern style ' );
// Classic interfaceuseShuchkinSimpleXLSXGen ;
$ xlsx = newSimpleXLSXGen ();
$ xlsx -> addSheet ( $ books , ' Catalog 2021 ' );
$ xlsx -> addSheet ( $ books2 , ' Stephen King catalog ' );
$ xlsx -> downloadAs ( ' books_2021.xlsx ' );
exit ();
// Empty book with title$ xlsx = SimpleXLSX :: create ( ' My books ' );
$ xlsx -> addSheet ( $ books );
$ xlsx -> save (); // ./My books.xlsx// Hyperlinks$ xlsx = SimpleXLSX :: fromArray ([
[ ' internal link ' , ' My books 2 ' !A1">Go to second sheet ' ],
[ ' http ' , ' https://example.com/ ' ], // autodetect
[ ' http + hash ' , ' https://en.wikipedia.org/wiki/Office_Open_XML#References ' ], // autodetect
[ ' external anchor ' , ' Open XML ' ],
[ ' relative link ' , ' books ' ],
[ ' relative link + cell addr ' , ' Sheet 2 ' !A1">link to second sheet in other book ' ],
[ ' mailto ' , ' [email protected] ' ], // autodetect
[ ' mailto 2 ' , ' Please email me ' ],
])-> addSheet ([[ ' Second sheet ' ]], ' My books 2 ' )-> saveAs ( ' hyperlinks.xlsx ' );
// Autofilter$ xlsx -> autoFilter ( ' A1:B10 ' );
// Freeze rows and columns from top-left corner up to, but not including,// the row and column of the indicated cell$ xlsx -> freezePanes ( ' B2 ' ); // B1 - freeze first column, A2 - freeze top row// 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.$ xlsx -> rightToLeft ();
// Set Meta Data Files// this data in propertis Files and Info file in Office $ xlsx -> setAuthor ( ' John Doe ' )
-> setCompany ( ' JD LLC ' )
-> setManager ( ' Jane Doe ' )
-> setLastModifiedBy ( " John Doe " )
-> setTitle ( ' My Books ' )
-> setSubject ( ' My bookshelf ' )
-> setKeywords ( ' Tolkien,Rowling,Kipling ' )
-> setDescription ( ' Cool books worn by time ' )
-> setCategory ( ' Books ' )
-> setLanguage ( ' en-US ' )
-> setApplication ( ' ShuchkinSimpleXLSXGen ' )
