viotile/quick-import-export

This package used for import/export functionality in php project.

dev-master 2017-08-23 13:13 UTC

Requires

• phpoffice/phpexcel: ^1.8

MIT

• vishnu divetia

README

This package used for quick import functionality in php project.

Prerequisites

For testing existing example follow the steps

CREATE TABLE `pincodes` (
  `id` bigint(11) NOT NULL,
  `postal_code` int(11) NOT NULL,
  `city` varchar(50) NOT NULL,
  `state` varchar(50) NOT NULL,
  `international_services` varchar(50) NOT NULL,
  `domestic_services` varchar(50) NOT NULL,
  `classification` varchar(50) NOT NULL,
  `is_cod_available` varchar(50) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

ALTER TABLE `pincodes`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `pincodes`
  MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT;

Installation

Install By composer

composer require viotile/quick-import-export