Things to do in Cape Town, the Helderberg, and the Cape Winelands

Tag 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! ;)

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.

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

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.

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).

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).

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.

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.

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!

« Older posts

© 2021 An Exploring South African — Powered by WordPress