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

    Read more


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

    Read more


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

    Read more


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

    Read more


  • Merge Cells

    PhpSpreadsheet (Excel Files) // Merge cells from A1 to D5 $sheet->mergeCells(‘A1:D5’);

    Read more


  • Write Cell Data Horizontally

    PhpSpreadsheet (Excel Files) // Set cell values for A1-D1 foreach (range(‘A’, ‘D’) as $letter) { $sheet->setCellValue($letter . ‘1’, $letter . ‘1’); } Google Sheets API Client Library For PHP (Google Sheets) $body = new Google_Service_Sheets_ValueRange([ ‘values’ => [[‘Hello A1’, ‘Hello B1’, ‘Hello C1’, ‘Hello D1’]] ]); $params = [ ‘valueInputOption’ => ‘RAW’ ]; $result = […]

    Read more


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

    Very similar with the Create A “Hello World” SpreadSheet Using Google Sheets API PHP Client tutorial that was previously published, we will be attempting to further demonstrate the ability of the Google Sheets API and its PHP Client Library to write to a single range of a given Google Sheet. This article will focus on […]

    Read more


  • Change A Spreadsheet Title

    PhpSpreadsheet (Excel Files) // Set the properties or metadata of the file $spreadsheet->getProperties() ->setTitle(“Put The New Title Of The Spreadsheet Here”) ; Google Sheets API Client Library For PHP (Google Sheets) $requests = [ new Google_Service_Sheets_Request([ ‘updateSpreadsheetProperties’ => [ ‘properties’=> [ ‘title’ => ‘Put The New Title Of The Spreadsheet Here’ ], ‘fields’ => ‘title’ […]

    Read more


  • Change Google Spreadsheet Title Using Google Sheets API PHP Client

    Rename Google Spreadsheets using the method spreadsheets.batchUpdate with request UpdateSpreadsheetPropertiesRequest by assigning a new value to it’s title property. Having a clearly defined Google Spreadsheet title will help identify your speadsheets more quickly, thus leaving them more organized and easier to manage. Several prerequisites are listed below, and one of them is we will be […]

    Read more