Archive
Author: admin
Split A Text Column With The TEXTSPLIT Function In Excel
Text to Columns overwrites your data once. TEXTSPLIT keeps splitting as the data changes, and TEXTBEFORE and TEXTAFTER narrow the result to a single piece, with no character…
August 27, 2026 · Excel Formulas
Find And Replace In A Google Sheet Using Google Sheets API PHP Client
Run a bulk find and replace across a Google Sheet with one request, and see what the default flags quietly match along the way. Turning on includeFormulas can…
August 20, 2026 · Google Sheets API PHP Client
Add A Chart To A Google Sheet Using Google Sheets API PHP Client
Build a chart in a Google Sheet from PHP with addChart, putting a second series on its own axis when the two do not share a scale. Charts…
August 20, 2026 · Google Sheets API PHP Client
Protect A Range In A Google Sheet Using Google Sheets API PHP Client
Lock cells in a Google Sheet with addProtectedRange, choose between blocking an edit and warning about it, and protect a whole sheet while leaving one column open. None…
August 19, 2026 · Google Sheets API PHP Client
Filter Rows In A Google Sheet Using Google Sheets API PHP Client
Set a basic filter on a Google Sheet from PHP, then add named filter views that sort and narrow the data without disturbing anyone else. A filter hides…
August 19, 2026 · Google Sheets API PHP Client
Sort A Range In A Google Sheet Using Google Sheets API PHP Client
Reorder rows that are already in a Google Sheet with a single sortRange request, sorting on one column or several at once. The catch is that the range…
August 19, 2026 · Google Sheets API PHP Client
Add A Dropdown To A Google Sheet Using Google Sheets API PHP Client
Add a dropdown to a Google Sheet from PHP using a fixed list of values or a range of options. The strict flag stops a person typing a…
August 17, 2026 · Google Sheets API PHP Client
Insert Rows And Columns In A Google Sheet Using Google Sheets API PHP Client
Insert rows and columns in a Google Sheet from PHP with insertDimension, and control whether the new cells inherit their neighbour's formatting. Batch several inserts and the order…
August 17, 2026 · Google Sheets API PHP Client
Add Conditional Formatting In A Google Sheet Using Google Sheets API PHP Client
Add conditional formatting in a Google Sheet from PHP: a boolean rule that shades low stock, and a gradient that runs a colour scale across a price column.…
August 16, 2026 · Google Sheets API PHP Client