siokobu/phpspreadsheetdb

Library for DB Operation using SpreadSheet

v3.0.1 2025-12-15 12:55 UTC

Requires

• phpoffice/phpspreadsheet: ~5.3

Requires (Dev)

• phpunit/phpunit: ^10.5

Apache-2.0

• tomocky1

README

PhpSpreadsheet is a library written in pure PHP and offers a function to export data from DB to Spreadsheet and a function to import data from Spreadsheet to DB

Supported Databases

Microsoft SQL Server And SQLite, PostgreSQL, MariaDB is Supported.

Supported Spreadsheet

Only Microsoft Excel is Supported.

Installation

Use composer to install PhpSpreadsheetDB into your project:

composer require siokobu/phpspreadsheetdb

Often PhpSpreadsheetDB to help PHPUnit test.

composer require --dev siokobu/phpspreadsheetdb

How to use

• SQL Server

$db = new SQLSrv($host, $port, $database, $user, $password);
$xlsx = new Xlsx($path);
$phpSpreadsheetDB = new PHPSpreadsheetDB($SQLSrv, $xlsx);
$phpSpreadsheetDB->import();

• Postgres

$db = new Postgres($host, $port, $database, $user, $password);
$xlsx = new Xlsx($path);
$phpSpreadsheetDB = new PHPSpreadsheetDB($postgres, $xlsx);
$phpSpreadsheetDB->import();

• MariaDB

$db = new MariaDB($host, $port, $database, $user, $password);
$xlsx = new Xlsx($path);
$phpSpreadsheetDB = new PHPSpreadsheetDB($db, $xlsx);
$phpSpreadsheetDB->import();

• SQLite

$db = new SQLite($filename);
$xlsx = new Xlsx($path);
$phpSpreadsheetDB = new PHPSpreadsheetDB($db, $xlsx);
$phpSpreadsheetDB->import();