Tired of writting long lines of SQL code to create tables for a data base? Now, imagine typing all that data from an Excel file.. Yeah wasted time. Well not any more using this PHP module.
- To create the SLQ snippet run "index.php"
- Select the file and then click on "Upload"
- Your SQL snippet will be printed!
WARNING YOU .XLS FILE WILL BE DELETED AFTER THE PROCESS, INSIDE THE PROJECT FOLDER
To know more about read the notes section
To correctly use this tool is necessary to follow this format: Link to an Excel file
-The file that is in charge of creating the SQL snippet is named fileHandler.php
-If you want to avoid deleting the .xls file remove line 152 of fileHandler.php
For reading the spreadsheet we use the "spreadsheet-reader" by Nuovo. Our creation is the production of the SQL lines using the reader from Nuovo. Here is the link to the original repo.
All of the code in this library is licensed under the MIT license. The Spreadsheet Reader code is owned by Nuovo.