Finish off the spreadsheet generation by using the code below and then open up your freshly generated spreadsheet. To create an underline without any text in Microsoft Word, press Ctrl+U to start the underline, then, press Ctrl+Shift+spacebar to create non-breaking spaces.Press and hold this keyboard shortcut combination to add multiple underlines next to each other, creating an underline. Then we simply use the useful applyFromArray function to apply this style to our selected cell.Īnd that is pretty much it. So from above you can see that we first create a style array that holds our underline information. $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray) 'underline' => PHPExcel_Style_Font::UNDERLINE_SINGLE Okay, so let’s apply a normal underlining to that text we just inserted: $styleArray = array( $objPHPExcel->getActiveSheet()->setCellValue('A1','Underline me!') One of Excels features is the ability to format cells using different colors, fonts, number styles and border types. $objPHPExcel->getActiveSheet()->setTitle('Example')
#HOW TO MAKE A UNDERLINE IN EXCEL HOW TO#
Then we populate a cell with some data so that we’ve got something to underline: $objPHPExcel->setActiveSheetIndex(0) Do you want to know how to how to use Excel formulas If yes then just have a look once to our website and get to know how to make a formula in Excel easily. Then we set the active sheet to the default first sheet in the workbook and give it a title, in this case ‘Example’.
Require_once 'Classes/PHPExcel/IOFactory.php' Header("Content-Disposition: attachment filename=example.xls") Looking at this list, we can see that we pretty much have all the usual underline options that Excel offers us, so let’s go ahead and put this knowledge to action!įirst we initiate our PHPExcel object in the following fashion: header("Content-type: application/vnd.ms-excel")
Opening this file we find: const UNDERLINE_NONE = 'none' Ĭonst UNDERLINE_DOUBLEACCOUNTING = 'doubleAccounting' Ĭonst UNDERLINE_SINGLEACCOUNTING = 'singleAccounting' The easiest way to see this is by checking up which PHPExcel constants have been set up for the underline type and to do this we browse to the Font.php file located in the ClassesPHPExcelStyle folder of your PHPExcel installation/folder structure. Answer (1 of 2): What is the shortcut for underlining in Excel Ctrl + U will do underline the cell, or text within the cell. 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).Īt this point you might of course like to know which underline options you do have available to you. 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.
0 kommentar(er)
