Scripts Index
Python Database Tools  

Read tabular data from Excel spreadsheets

download download home home   report broken
important script information
company name:
code.activestate.com
license: Free
minimum requirements: Python
functional limitations:
Read tabular data from Excel spreadsheets description
Sometimes you get an Excel spreadsheet (say, from the marketing departement) and you want to read tabular data from it (i.e. a line with column headers and lines of data). There are many ways to do this (including ODBC mxODBC), but the easiest way could be this script: provide a file name and a sheet name, and read the data !
Similar scripts
DBF reader and writer (Popularity: ) : In this script the reader iterates over records in Dbase or Xbase files and the writer creates dbf files from Python sequences.
OraSchemadoc (Popularity: ) : OraSchemadoc provides "JavaDoc" style detailed documentation for all objects in schema covering Oracle specific features. Result of execution of oraschemadoc is set of static html files.Features:- data about all tables, including columns- table constraints(check, unique and referential)- indexes, including functional ...
MS SQL Server Database Mover (Popularity: ) : This script automates the movement of databases from one Microsoft SQL Server to another. It is designed to detach, copy, and reattach database files with a single call. It could be used to move databases with a minimum of downtime. ...
SICKnotes (Popularity: ) : SICKnotes which is a short form for site inventory, configuration and knowledge is a web tool which is based on the permissions that assists with inventory, system changes, contact info, and knowledge for anything from a small startup to a ...
Python Hyperschema (Popularity: ) : Python Hyperschema is an open source public domain project that creates very useful HTML hypermaps from SQL database schema, which consists of two small PL/SQL files and one Python (or C) source code file. The thus generated HTML pages have ...
Create table statements for MS Access tables (Popularity: ) : This script parses the output of MS Access's documenter report and generates sql create table statements for the tables in the report.
MS SQL Server log monitor (Popularity: ) : MS SQL Server log monitor is a script that gathers errors, warnings, and failures from Micrsoft SQL Servers and SQL Server Agents. It creates a single HTML file from multiple server logs.It could be used as a quick daily check to determine ...
Book Database (Popularity: ) : Book Database script allows you to learn programming database applications.
Dump a database file to a pickle (Popularity: ) : This script converts the database file given on the command line to a pickle representation.The default is hash. If a pickle file is named it is opened for write access (deleting any existing data). If no pickle file is named, ...
Mapping arbitrary objects to a PostgreSQL database (Popularity: ) : Mapping arbitrary objects to a PostgreSQL database script allows you to introduce arbitrary objects into a PostgreSQL database.
User reviews

Write a review:
1 2 3 4 5 6 7 8 9 10
1=poor 10=excellent
Write review*
Your name*
Email*
  (Comments are moderated, and will not appear on this site until the editor has approved them)
 
Similar Software
Import Table from Excel for SQL Server (Popularity: ) : Import Table for Microsoft SQL Server helps to load data from Excel spreadsheet. The program has easy to use wizard interface. All modern versions of Microsoft SQL Server and all versions of Microsoft Excel are supported. A few options make ...
Import Table from Excel for Oracle (Popularity: ) : Import Table for the Oracle Server helps to load data from Excel spreadsheet. The program has easy to use wizard interface. All modern versions of the Oracle Server and all versions of Microsoft Excel are supported. A few options make ...
Import Table from Excel for DB2 (Popularity: ) : Import Table for the IBM DB2 databases helps to load data from Excel spreadsheet. The program has easy to use wizard interface. All modern versions of the DB2 Server and all versions of Microsoft Excel are supported. A few options ...
Excel MySQL Import, Export & Convert Software (Popularity: ) : Use MS Excel as a front-end interface to a MySQL database. Use Excel to import and export tables to and from a MySQL database. Read and write tables to and from Excel without SQL knowledge. Excel 2000 or higher required.
FD Merge Excel Spreadsheets (Popularity: ) : How to merge or combine rows/columns from mulitple Excel spreadsheets into one master/summary table

“Recently I’ve got something to work on with several excel files. More than 150 excel files generated by a web based application have to be merged into ...

Import Table from Excel for SQL Server Pro (Popularity: ) : Import Table from Excel utility allows the user to load data rows from Excel spreadsheets to new or existing database table. This tool supports all modern versions of Microsoft SQL Server and all versions of Excel. Key product features Easy ...
xCollator (Popularity: ) : xCollator automatically pulls data from multiple spreadsheets and collates that data into one easy-to-use file. You can then load this file into Excel, Access or another database for analysis or storage. Specifying what data you would like to collect with ...
Recover Data from OST File (Popularity: ) : Recover data from OST file 2007 by a perfect solution Recover OST File Tool and provide a user friendly feature and easily recover data from OST files. These OST files are corrupted due to the effect of some external entities ...
Recover Data From Outlook OST File (Popularity: ) : Exchange OST file is crucial file for clients. This OST file contains whole details of offline updates and changes. But sometime corruption makes this OST file inaccessible as well corrupt. So to recover data from Outlook OST file, you have ...
ezViz Office (Popularity: ) : ezViz Office allows users to create stunning graphs of real-time data or static data in excel spreadsheets. ezViz is easy to use, easy to deploy and easy to integrate with existing applications. ezViz allows users to be connected to key ...
ad


Rate me
supported os
Windows, Linux, Mac OS, BSD, Solaris
stats
downloads 24
version 1 2
size in Kb
popularity   
1568/370682
user rating 5/10
New Scripts
Popular Scripts
Latest Reviews