Category: PhpSpreadsheet

  • Convert HTML Table Into Excel

    Convert HTML Table Into Excel

    Convert a table from an HTML file into an excel file with PHP using PHPSpreadSheet. Import an HTML table into an excel file using PHPSpreadSheet. Maintain the same columns and rows, and keep the exact data to their specific positions. Some PHP functions will be used like file_get_contents() to read the entire file into a […]

  • Create a Grocery List Template in Excel

    Create a Grocery List Template in Excel

    Learn How to Create a Grocery List Template in Excel with PHP using PHPSpreadSheet. List down and organize all your grocery item needs before doing a shopping to save time. Group the things-to-buy according to their classification and put both the estimated price for each item and the total estimated price of all the items. […]

  • Insert Pictures In Excel Files In PHP Using PHPSpreadSheet

    Insert Pictures In Excel Files In PHP Using PHPSpreadSheet

    Learn how to insert pictures in excel files in PHP using PHPSpreadSheet. You can insert pictures in excel files by creating a new Drawing object and then set it’s properties such as the path, height, and name of the picture. You can also set the specific cell address where you would exactly like the picture […]

  • Add Header Logo In Excel Files In PHP Using PHPSpreadSheet

    Add Header Logo In Excel Files In PHP Using PHPSpreadSheet

    Learn how to add excel header logo in PHP using PHPSpreadSheet. You can align the header logo to the left side, center, or right side. Make sure you set the correct path to your logo file, otherwise it will not appear at the header even if your codes are correct. Other logo attributes can also […]

  • Create Excel Files With Max Formula In PHP Using PHPSpreadSheet

    Create Excel Files With Max Formula In PHP Using PHPSpreadSheet

    Learn how to create excel files with MAX formula in PHP using PHPSpreadSheet. You can code and write a max formula that would get the maximum value from a given specific range of cells, or get the max value between two cells, or max value of only selected cells. This article will discuss the basic […]

  • Create Excel Files With Average Formula In PHP Using PHPSpreadSheet

    Create Excel Files With Average Formula In PHP Using PHPSpreadSheet

    Learn how to create excel files with AVERAGE formula in PHP using PHPSpreadSheet. You can code and write an average formula that would add values of specific range of cells and get it’s average, or get the total values of only selected cells before getting it’s average. This article will discuss the basic process of […]

  • Create Excel Files With Sum Formula In PHP Using PHPSpreadSheet

    Create Excel Files With Sum Formula In PHP Using PHPSpreadSheet

    Learn how to create excel files with SUM formula in PHP using PHPSpreadSheet. You can code and write a summation formula that would add values of specific range of cells, or get the total values of only selected cells. This article will discuss the basic process of adding cell values together through a sum formula […]

  • What is PHP Excel

    PHP Excel is a library purely written in PHP that provides set of classes to read and write different spreadsheet file formats such as Excel (.xls), CSV, and Excel 2007 (xlsx), to name a few. It was officially deprecated in 2017 and permanently archived in 2019. But because of it’s popularity it is still widely […]

  • Write Excel Files Data Horizontally In PHP Using PHPSpreadSheet

    Use PhpSpreadsheet in PHP to create and write data to excel files horizontally, starting from left to right, and in this particular tutorial example, we will try to write data to the cells of an excel file in the following cell order, A1, B1, C1, and D1. Requirements: Composer PHP 7.2 or newer Step 1. […]