PHPackages                             keisukesaichi/spread-sheet-wrapper - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [File & Storage](/categories/file-storage)
4. /
5. keisukesaichi/spread-sheet-wrapper

ActiveLibrary[File & Storage](/categories/file-storage)

keisukesaichi/spread-sheet-wrapper
==================================

A lightweight PHP library for reading and writing Google Spreadsheets easily, especially designed for Japanese beginners.

1.3.0(1mo ago)140MITPHPPHP ^8.3

Since Nov 10Pushed 1mo agoCompare

[ Source](https://github.com/twinkle-fff/SpreadSheetWrapper)[ Packagist](https://packagist.org/packages/keisukesaichi/spread-sheet-wrapper)[ RSS](/packages/keisukesaichi-spread-sheet-wrapper/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependencies (4)Versions (6)Used By (0)

**２つのアプリケーションクラス Insert と Readを持っています。 日本の初学者が利用することを考えているためコメントや例外表記を日本語で記しています。 学習用の教材として、スプレッドシートに近い感覚で利用できるよう作成したものであり、 業務等で利用される場合は本家google\\apiclientをお使いください。**

- Insert
- ---
- Googleスプレッドシートへ「追記（append）」と「上書き（update）」を行う
- ユーティリティクラス。値のネスト正規化も内包します。
-
- 【前提】
- - 認証は SpreadSheetAuth が行い、Client を受け取ります
- - .env（例：.env.local）に以下を定義
- ```
    SHEET_ID="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"

    ```
- ```
    SHEET_NAME="シート1"

    ```
-
- 【想定する値の形】
- - 2次元配列（複数行）
- \[\[A1, B1, C1\], \[A2, B2, C2\]\]
- - 1次元配列（1行のみ）
- \[A1, B1, C1\] → 内部で \[\[A1, B1, C1\]\] に正規化
- - 内部要素が配列の場合は改行結合 + JSON で安全に文字列化
-
- 【主なメソッド】
- - insert($values, $range, $sheetName): 追記（append）
- - update($values, $range, $sheetName): 上書き（update）
-
- @package SpreadSheetWrapper\\InterFace\\GoogleSpreadSheet

/\*\*

- ============================================================
- Read
- ---
- Googleスプレッドシートからデータを読み取るクラス。
-
- 【主な機能】
- - 指定範囲を読み取り、列名(A,B,C,...)付きの連想配列として返す。
- - .env から SHEET\_ID / SHEET\_NAME を自動読み込み。
-
- 【返り値形式】
- \[
- \["A" => 値1, "B" => 値2, "C" => 値3\],
- \["A" => 値4, "B" => 値5, "C" => 値6\],
- ...
- \]
-
- 【例】
- $reader = new Read();
- $rows = $reader->read("A1:C5");
- ============================================================ \*/

###  Health Score

43

—

FairBetter than 91% of packages

Maintenance89

Actively maintained with recent releases

Popularity11

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity54

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~31 days

Total

5

Last Release

58d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/6f0ee0d83f22edc8f3db9bd60d0121fe451b60b963f38e783826a1d063415e1e?d=identicon)[twinkle-fff](/maintainers/twinkle-fff)

---

Top Contributors

[![twinkle-fff](https://avatars.githubusercontent.com/u/121096113?v=4)](https://github.com/twinkle-fff "twinkle-fff (7 commits)")

### Embed Badge

![Health badge](/badges/keisukesaichi-spread-sheet-wrapper/health.svg)

```
[![Health](https://phpackages.com/badges/keisukesaichi-spread-sheet-wrapper/health.svg)](https://phpackages.com/packages/keisukesaichi-spread-sheet-wrapper)
```

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)