![]() CATEGORIES: BiologyChemistryConstructionCultureEcologyEconomyElectronicsFinanceGeographyHistoryInformaticsLawMathematicsMechanicsMedicineOtherPedagogyPhilosophyPhysicsPolicyPsychologySociologySportTourism |
Setting the images root of the HTML fileThere might be situations where you want to explicitly set the included images root. For example, one might want to see <img style="position: relative; left: 0px; top: 0px; width: 140px; height: 78px;" src="http://www.domain.com/images/logo.jpg" border="0"> instead of <img style="position: relative; left: 0px; top: 0px; width: 140px; height: 78px;" src="./images/logo.jpg" border="0">.
You can use the following code to achieve this result: $objWriter->setImagesRoot('http://www.example.com'); Formula pre-calculation By default, this writer pre-calculates all formulas in the spreadsheet. This can be slow on large spreadsheets, and maybe even unwanted. You can however disable formula pre-calculation: $objWriter = new PHPExcel_Writer_HTML($objPHPExcel); $objWriter->save("05featuredemo.htm"); Embedding generated HTML in a web page There might be a situation where you want to embed the generated HTML in an existing website. PHPExcel_Writer_HTML provides support to generate only specific parts of the HTML code, which allows you to use these parts in your website.
Supported methods:
Here’s an example which retrieves all parts independently and merges them into a resulting HTML page:
<?php <style> <!-- html { font-family: Times New Roman; font-size: 9pt; background-color: white; } <?php --> </style> <?php Writing UTF-8 HTML files A HTML file can be marked as UTF-8 by writing a BOM file header. This can be enabled by using the following code: $objWriter = new PHPExcel_Writer_HTML($objPHPExcel); $objWriter->save("05featuredemo.htm"); Decimal and thousands separators See section PHPExcel_Writer_CSV how to control the appearance of these. PHPExcel allows you to write a spreadsheet into PDF format, for fast distribution of represented data.
i PDF limitations PHPExcel_Writer_PDF
i Please note that PHPExcel_Writer_PDF only outputs the first worksheet by default. Writing a spreadsheet You can write a .pdf file using the following code: $objWriter = new PHPExcel_Writer_PDF($objPHPExcel); $objWriter->save("05featuredemo.pdf"); Write all worksheets PDF files can contain one or more worksheets. If you want to write all sheets into a single PDF file, use the following code: $objWriter->writeAllSheets(); Write a specific worksheet PDF files can contain one or more worksheets. Therefore, you can specify which sheet to write to PDF: $objWriter->setSheetIndex(0); Date: 2016-03-03; view: 937
|