Tag Archives: Excel

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 , , , , , | View 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 , , , , , | View 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 , , , , range, | View 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 , , , , , , , | View 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 , , , , , , , , , , | View Comments
Navigation »