Author: admin

  • 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 […]

  • Duplicate Google Sheets Sheet Using Google Sheets API PHP Client

    Duplicate Google Sheets Sheet Using Google Sheets API PHP Client

    Using the method spreadsheets.batchUpdate with request DuplicateSheetRequest you can quickly duplicate a Google Sheets sheet. The source sheet ID is required, other parameters are optional and will be automatically generated if not set. For the spreadsheet resource sample that we will be using for this tutorial, the result of the tutorial Update Google Sheets Cells […]

  • Update Google Sheets Cells Using Google Sheets API PHP Client

    Update Google Sheets Cells Using Google Sheets API PHP Client

    Update specific google sheets cells using the method spreadsheets.batchUpdate with request UpdateCellsRequest. Simply choose a precise cell position and update the value inside it. We will be using the result of the tutorial Unmerge Google Sheets Cells Using Google Sheets API PHP Client for this example. The goal of this tutorial is to update the […]

  • Unmerge Google Sheets Cells Using Google Sheets API PHP Client

    Unmerge Google Sheets Cells Using Google Sheets API PHP Client

    Separate all cells in the given range by selecting merged rows and columns using the method spreadsheets.batchUpdate with request UnmergeCellsRequest. This will unmerge cells of Google Spreadsheets using Google Sheets API PHP Client. This is a follow up and the result of the tutorial Merge Google Sheets Cells Using Google Sheets API PHP Client will […]

  • 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 […]

  • Merge Google Sheets Cells Using Google Sheets API PHP Client

    Merge cells of Google Spreadsheets using the method spreadsheets.batchUpdate with request MergeCellsRequest. Select your desired rows and columns and combine all cells in the given range. One of the several prerequisites (others listed below) is we will be using the created Google Spreadsheet on our tutotial Create A Blank SpreadSheet Using Google Sheets API PHP […]

  • Change Google Sheets Border Using Google Sheets API PHP Client

    With the use of the method spreadsheets.batchUpdate together with the request UpdateBordersRequest , Google Sheets Spreadsheet borders can be changed. Different styles can be set like DOTTED, DASHED, SOLID, SOLID_MEDIUM, SOLID_THICK, DOUBLE. And if the border needs to be removed, just set the style to NONE. In this tutorial, the sample spreadsheet that we will […]

  • Write Google Sheets Data To A Multiple Range Horizontally Using Google Sheets API PHP Client

    Write data horizontally on multiple ranges on a Google Sheet Spreadsheet through Google Sheets API PHP Client using a spreadsheets.values.batchUpdate request. Use this method to situate your data to numerous specific column-row combination side by side starting from the left all at the same time in a single loop. Be sure to arrange your ranges […]

  • 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. […]