siokobu/phpspreadsheetdb

Library for DB Operation using SpreadSheet

2.0.0 2022-07-25 23:34 UTC

Requires

• phpoffice/phpspreadsheet: ~1.0

Requires (Dev)

• phpunit/phpunit: ^9.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 is Supported For importing to Microsoft SQL Server from Microsoft Excel.

Supported Spreadsheet

Only Microsoft Excel is Supported. And only import to Microsoft SQL Server from Microsoft Excel.

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

$connectionInfo = array(
    "Database" => $database,
    "UID" => $uid,
    "PWD" => $pwd,
    "CharacterSet" => $charset);
$sqlSrv = new SQLSrv($hostname, $connectionInfo);
$sqlSrv->insertData($tableName, $excel);