-
What, who, where am I?!?
Craig Lotter is a web developer based in Gordon's Bay, South Africa, who seems completely incapable of shaking off that pesky inner child within, the one that forces him to love all things animated or hand drawn.
The Rugged Rock of Craig contains snippets of his life, popular culture and all the important things like anime, manga, games and comic books. The CodeUnit of Craig on the other hand contains the more serious stuff like code snippets and tutorials, while the House of C chronicles his foray into the world of web comics.
For which it never seems he has enough time anyway.
CodeUnit Post Archive
Tag Archives: phpexcel
PHPExcel: How to Bold a Cell’s Value
Today’s quick code tip is on how to embolden a cell’s value – in other words how to replace that big B bold button with some code! ;) Continue reading
Posted in Technology & Code, Tutorials
Tagged bold, cells, Excel, PHP, phpexcel, worksheet
5 Comments
PHPExcel: How to Set the Width of Cells
Today’s quick code tip is on how to specify or set the width of individual columns in your worksheet. Continue reading
Posted in Technology & Code, Tutorials
Tagged cells, Excel, PHP, phpexcel, width, worksheet
5 Comments
PHPExcel: How to Merge Cells
Today’s quick code hint deals with how one sets about merging a cell range using PHPExcell. Unfortunately for me though, the solution is so simple that this will only take one line of my time! :P Continue reading
Posted in Technology & Code, Tutorials
Tagged cells, Excel, merge, phpexcel, range, workseet
2 Comments
Setting Your Worksheet Printing Layout Options in PHPExcel
I’ve gone on and on in length over just how awesome the PHPExcel OpenXML spreadsheet reader/writer project is over the last bit here in this blog, and today is no exception as I take a quick look at how one can set the page printing layout when generating an Excel spreadsheet. Continue reading
Posted in Technology & Code, Tutorials
Tagged Excel, fit to page, layout, PHP, phpexcel, printing, scaling, spreadsheet
4 Comments
PHPExcel: How to Underline a Cell’s Text
The CodePlex project PHPExcel is an absolutely brilliant implementation around Microsoft’s OpenXML standard, giving us a powerful PHP object driven engine that is capable of creating and reading from Excel 2007, PDF, HTML and even Excel 2003 spreadsheets and documents. Today’s little hint is on how one can go about underlining the value of a cell (for example, if you want to use that text as a link in your worksheet). Continue reading
Posted in Tutorials
Tagged cell, creation, Excel, excel 2007, generation, PHP, phpexcel, spreadsheet, underline, underline cell, underlining
Leave a comment
