|
A script to import data to a
This all-new version allows
PHP Excel Converter is a PHP
This php excel script will
MySQL database from CSV
users to upload their csv
script that extracts data
dump your data from SQL
files. Open a CSV file and
files directly using the
from your Excel file and
table (MySQL, supply your
preview it. Then, connect
script or files already on
imports it to MySQL
own SQL query) to a
to your MySQL database,
the server. Using the
database. It processes large
microsoft excel (.xls) file.
select which fields should
easy-to-use interface of
Excel files up to 10 Mb.
The Excel file is specified
receive which column (or set
drop-downs and buttons, the
Customizable versions for
as such by a set of headers,
value) and then import. You
users can preview their
larger sizes are available
defining content. using
can add, update or even add
file, select the table and
upon your request. The
php's header() function,
and update with this script.
then insert the data into
Converter processes
also the rows and columns of
This new version allows you
MySQL.
This version
hyperlink, string, integer,
the excel file are defined
to create tables prior to
contains a config file so
float, date, formula (
by tab and new line chars.
import, import via rules
letting other
returned values only ),time,
(insert/update only where
not-so-experienced users use
percent, empty, Error (
column X is greater than
the system is no longer a
error code ),Sheet
13), delete from table and
hassle!
PHP CSV Importer
name,Multiple sheet files,
save your rules. There is
runs on templates and CSS so
MAC Excel files. PHP Excel
also now a file browser to
you can re-design all you
Converter supports Excel
find your
like! It also supports
files versions
multiple languages, too.
5.0/97/2000/XP/2003. All
Remember to read the terms
features are fully
and conditions before you
documented. Demo and free
begin. d:-)
Visit:
downloadable trial versions
<a
are available online.
Date: Apr, 11 2005 Date: Aug, 14 2006 Date: Mar, 22 2006 Date: Nov, 02 2003 |
|
New PHP Excel Parser Pro 4.6
This PHP class can import
PHP Grid shows your database
A class for very basic MySQL
is now available! New
data from an Excel file
information in a good
database connectivity.
features: outline group
without using COM, ODBC,
looking way.
Everything is
Written to reduce redundant
support, new properties
etc. It will be useful in
done in real-time, like
code in my own projects
(country, code page) and
content management systems,
sorting, resizing and
aswell as aid in debugging
improved hyperlink
for writting various
updating.
The price is the
and error reporting during
parsing.
Need a script that
converters (Excel to HTML,
same even when you
the developement phase.
reads Excel file and
Excel to MySQL,
distrubute PHP Grid in your
Currently connects to a
transports the information
etc.).
On-line demo and
own programs. The
database, execute external
into Database or creates an
trial version available for
application you build around
files containing SQL
HTML file? PHP Excel Parser
download.
ExcelExplorer
PHP Grid must be more than a
commands, insert and update
Pro is the answer! Works
will work on any PHP
thin layer simply put on top
from an array of key =>
under Unix, Linux, SunOS,
platform. Supports Windows
of PHP Grid. It must provide
value pairs, insert and
Windows using PHP without
and Mac Excel files. No
substantial additional
update with sql command,
any additional modules. The
additional classes, modules
end-user functionality
query (one result), query
parser imports data from
are required. No
(large web site, affiliate
(multiple rows), and dump a
Excel files (versions
configurations needed. Just
system, etc.)
select query to a table. The
5.0/97/2000/XP). Imported
include it in your own
Features:
All actions
zip file contains the class
Excel data types are:
script and use it. With this
are done in real-time, no
aswell as a demonstration
outline group, hyperlink,
class you can read such data
page reload needed.
Handy
script.
integer, float, string
as used color, fonts, rich
when updating
(compressed Unicode, 8-bits
text, asian phonetics, etc.
databases.
Download the
per character or
What data can be imported:
grid as an Excel
uncompressed Unicode,
worksheets name, type
file.
Print function that
16-bits per character,
(ordinal, chart or Visual
opens the grid in a new
formats), date, time,
Basic Module), visibility
window.
Resizable
percent, formula (returns
flag; rows and columns info;
columns.
Developed with Ajax
digits only).
Parser Pro
cells - type (integer and
supports multiple Excel
float numbers, percentage,
fonts and MAC files.
text, formula, logical,
error, date in Windows Excel
and Mac Excel formats),
empty, blank and merged.
Date: Mar, 22 2006 Date: Sep, 21 2006 Date: Sep, 15 2006 Date: Apr, 29 2005 |