Excel Export/Import - MySQL Data v 2.7.1

PhpSpreadsheet Documentation Purchase Now

Excel/CSV Export is simple web report export tool, you do can use Export/Import – MySQL Data tool for excel/csv file.It can be easily customized as like worksheet name, font, font size, cells fill color, cells border color, text alignment vertical, text alignment horizontal and cells width easily changeable. Excel cells is set number formats and data validation. MySQL Data is showing rows group wise and header(rows and columns merge).You can protected and unprotected easily set on excel worksheet cells.

Excel/CSV Import You can easily data import from excel/csv into MySQL Database Table field.It can be easily customized excel/csv cells and mysql table field.

Last Update: 05/01/2024
created: 04/01/2018
Author: ThemePosh
Email: tspprt7@gmail.com

Thank you for your interest in my tool. If you have any questions that are beyond the scope of this help file, please feel free to contact with our plugin Support page Excel Export/Import - MySQL Data Support or for very critical issue, you can contact with email: tspprt7@gmail.com [Email reply can be delay]. Thank you so much.

Note: Excel Export/Import - MySQL Data tool is depended on php web software

For using Excel Export/Import tool, first you have to confirm that, Excel Export/Import tool is already installed in your site. Also confirm that you have product available in your store. Then install Excel Export/Import tool.

Requirements

PHP version 8.0 or newer
PHP extension php_zip enabled
PHP extension php_xml enabled
PHP extension php_gd2 enabled

To install, Please follow the steps bellow:

Step-1:

Extract the archive file on your machine that you've downloaded from CodeCanyon.

The following screen will appear

Enter into the ExcelExportImport folder

The following screen will appear

Step-2:

Copy this folder ExportImportMySQLData and paste your localhost/web server directory

The following screen will appear

Step-3:

Database create as like(exportimport_db) in localhost/web server
Import database (demo_database/exportimport_db.sql)

The following screen will appear

Step-4:

Find the dbconnection.php page in ExportImportMySQLData folder
Then, change the database connection in (dbconnection.php) page

The following screen will appear

Step-5:

Then, browse this ExportImportMySQLData folder.

Step-1:

Browse this ExportImportMySQLData folder.

The following screen will appear

Step-2:

Following the steps

Excel file export and data entry into excel file
Excel file import
Excel file imported data list

Step-3:

Click on the "Excel Export" link for excel file export

The following screen

Step-4:

The following screen will appear, then click on the "Excel Export" button.

The following screen will appear. New data entry or existing data change then excel file save.

Step-5:

Click on the "Excel Import" link for excel file import

The following screen will appear

Step-6:

Browse excel file. The following screen

Then click on the "Upload" button. The following screen

Same way, CSV and Excel Multiple Worksheet Export and Import

Excel Export
Excel Import
Excel Imported Data
CSV Export
CSV Import
CSV Imported Data
Multiple Worksheet Excel Export
Multiple Worksheet Excel Import
Multiple Worksheet Excel Imported Data

ExportImportMySQLData

assets
demo_database
excel-export
excel-import
images
PhpSpreadsheet

dbconnection.php
export.php
header.php
import.php
index.php
ps-csv-export-data.php
ps-csv-export-data-list.php
ps-csv-import.js
ps-csv-import.php
ps-csv-import-demo-1.php
ps-csv-import-demo-2.php
ps-csv-import-demo-3.php
ps-csv-import-demo-4.php
ps-csv-import-demo-5.php
ps-csv-import-demo-6.js
ps-csv-import-demo-6.php
ps-csv-imported-data-list.php
ps-csv-import-server.php
ps-excel-export-data.php
ps-excel-export-data-list.php
ps-excel-import.js
ps-excel-import.php
ps-excel-import-demo-1.php
ps-excel-import-demo-2.php
ps-excel-import-demo-3.php
ps-excel-import-demo-4.php
ps-excel-import-demo-5.php
ps-excel-import-demo-6.js
ps-excel-import-demo-6.php
ps-excel-imported-data-list.php
ps-excel-import-server.php
ps-multiple-worksheet-excel-export.php
ps-multiple-worksheet-excel-import.js
ps-multiple-worksheet-excel-import.php
ps-multiple-worksheet-excel-import-demo-1.php
ps-multiple-worksheet-excel-import-demo-2.php
ps-multiple-worksheet-excel-import-demo-3.php
ps-multiple-worksheet-excel-import-demo-4.php
ps-multiple-worksheet-excel-import-demo-5.php
ps-multiple-worksheet-excel-import-demo-6.js
ps-multiple-worksheet-excel-import-demo-6.php
ps-multiple-worksheet-excel-import-server.php
ps-multiple-worksheet-export-data-list.php
ps-multiple-worksheet-imported-data-list.php
upload.php

v2.7.1 (05/01/2024)

PhpSpreadsheet library Upgrading To 1.29 From 1.28

v2.7.0 (03/03/2023)

PhpSpreadsheet library Upgrading To 1.28 From 1.23

v2.6 (13/05/2022)

Update PhpSpreadsheet library

v2.5 (04/12/2021)

Update PhpSpreadsheet library

v2.4 (27/01/2021)

Update PhpSpreadsheet library

v2.3 (13/03/2020)

CSV file import bug fixed

v2.2 (03/03/2020)

Design change in Excel Import page
Update PhpSpreadsheet Library
New feature added

v2.1 (01/07/2019)

PhpSpreadsheet Library
Excel Export
Excel Import
Excel Imported Data
CSV Export
CSV Import
CSV Imported Data
Multiple Worksheet Excel Export
Multiple Worksheet Excel Import
Multiple Worksheet Excel Imported Data
Bootstrap Fileinput

v2.0 (06/03/2018)

Added feature
CSV
Added PDO PHP Extension
Added MySQLi Extension

v1.0 (04/01/2018)

Initial Release

#Intro

Excel Export/Import - MySQL Data v 2.7.1

#Installation

Step-1:

Step-2:

Step-3:

Step-4:

Step-5:

#Getting Start

Step-1:

Step-2:

Step-3:

Step-4:

Step-5:

Step-6:

#Features

#Folders and Files Structure

ExportImportMySQLData

#Changelog