-
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: generation
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
Create Excel 2007 Spreadsheets using PHP
For the quickest implementation time in terms of churning out Excel 2007 spreadsheets in your PHP-based project, look no further than the brilliant PHPExcel project! Continue reading
Posted in Software & Websites
Tagged codeplex, creation, Excel, excel 2003, excel 2007, generation, microsoft, openxml, PHP, phpexcel, spreadsheet
3 Comments
