siokobu/phpspreadsheetdb

Library for DB Operation using SpreadSheet

Maintainers

Details

github.com/siokobu/PHPSpreadsheetDB

Source

Issues

Installs: 805

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 1

Forks: 0

Open Issues: 0

2.0.0 2022-07-25 23:34 UTC

Requires

Requires (Dev)

Apache-2.0 837c8967beb1a7e98dd5f49e843be5c3fcf6e2a4

  • tomocky1 <siokobu8400.woop@gmail.com>

This package is auto-updated.

Last update: 2025-02-26 05:02:08 UTC

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);