-
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: spreadsheet
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
PHPExcel: How to Place a Border Around a Cell Range
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 putting a border around a whole range of cells (or just one cell at that). Continue reading
Posted in Tutorials
Tagged border, cell border, creation, Excel, excel 2007, generation, PHP, phpexcel, spreadsheet
5 Comments
PHPExcel: Avoid Exceeding Maximum Execution Time
Today’s little hint is on how one can go about avoiding hitting the dreaded maximum execution time fata error that PHP so loves spitting out at us while generating a PHPExcel excel worksheet. Continue reading
Posted in Tutorials
Tagged creation, Excel, excel 2007, execute, generation, maximum execution time, PHP, phpexcel, run time, spreadsheet
1 Comment
PHPExcel: How to Link to another Worksheet
Today’s little hint is on how one can go about creating a link on one worksheet in your spreadsheet that will then take a user to another worksheet in your spreadsheet by clicking the link, using the PHPExcel engine. Continue reading
Posted in Tutorials
Tagged creation, Excel, excel 2007, generation, hyperlink, internal linking, link, PHP, phpexcel, spreadsheet
2 Comments
