Download the PHP package jarir-ahmed/data-converter without Composer

On this page you can find all versions of the php package jarir-ahmed/data-converter. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of jarir-ahmed/data-converter

Informations about the package data-converter

data-converter

6-way converter — CSV ↔ XLSX ↔ JSON ↔ MySQL. Import/export data between any format, generate SQL INSERT statements, or connect directly via PDO.

Matrix

From \ To CSV XLSX JSON MySQL
CSV — ✅ ✅ ✅
XLSX ✅ — ✅ ✅
JSON ✅ ✅ — ✅
MySQL ✅ ✅ ✅ —

Quick Start

Import: any file → SQL / direct DB insert

Export: SQL / array → any format

Convert: format ↔ format (no database)

JSON Formats

Import supports two formats:

Array of objects (default):

Structured {columns, rows}:

Export supports both — pass 'structured' => true for the structured format.

Options

ImportManager

Option Type Default Description
pdo PDO\|null null PDO for direct DB insert
skipExecute bool false Return SQL even with PDO
batchSize int 50 Rows per INSERT block
hasHeader bool true First row is column names
columns string[] [] Force column names
delimiter string , CSV delimiter
enclosure string " CSV enclosure
ignore bool false Use INSERT IGNORE
emptyAsNull bool true Empty cells → NULL
preview int 0 Only process N rows
onDuplicateKey string null ON DUPLICATE KEY UPDATE
sheetName string first Sheet name (xlsxToSql)
formatDates bool true Excel serial → YYYY-MM-DD
rootPath string null JSON nested path like data.items

ExportManager

Option Type Default Description
delimiter string , CSV delimiter
enclosure string " CSV enclosure
includeHeaders bool true Include CSV header row
utf8Bom bool false UTF-8 BOM for Excel
sheetName string Data XLSX sheet name
styled bool true Blue header styling
pretty bool true Pretty-print JSON
structured bool false {columns, rows} format

Local Testing

Test database (manual verification):

Host Database User Password Port
localhost test-excel root your_secure_password 3306

License

MIT

6-way-data-converter

All versions of data-converter with dependencies

PHP Build Version
Package Version
Requires php Version >=7.4
ext-json Version *
phpoffice/phpspreadsheet Version ^1.29
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package jarir-ahmed/data-converter contains the following files

Loading the files please wait ...