Scripts Index
Python File Management  

Cross Platform Excel Parsing With Xlrd

download download home home   report broken
important script information
company name:
code.activestate.com
license: Free
minimum requirements: Python
functional limitations:
Cross Platform Excel Parsing With Xlrd description
This script easily extract data from microsoft excel files using this wrapper class for xlrd. The class allows you to create a generator which returns excel data one row at a time as either a list or dictionary. This script is very useful for easily pulling in a variety of excel files without having to deal with COM calls or even needing to have windows. Data is extracted by creating a iterator object which can be used to return data one row at a time. The default extraction method assumes that the worksheet is in tabular format with the first nonblank row containing variable names and all subsequent rows containing values. This method returns a dictionary which uses the variables names as keys for each piece of data in the row. Data can also be extracted with each row represented by a list.

Extracted data is represented fairly logically. By default dates are returned as strings in "yyyy/mm/dd" format or "yyyy/mm/dd hh:mm:ss", as appropriate. However, dates can be return as a tuple containing
(Year, Month, Day, Hour, Min, Second) which is appropriate for usage with mxDateTime or DateTime. Numbers are returned as either INT or FLOAT, whichever is needed to support the data. Text, booleans, and
error codes are also returned as appropriate representations.
Similar scripts
Convert PDF to TIFF (Popularity: ) : This script is a very short code snippet illustrating how to convert individual pages of PDF documents to TIFF files, one TIFF file per page. It works only on Mac OS X with PyObjC installed.As a recipe the code is ...
Count PDF pages (Popularity: ) : Count PDF pages script is a simple way to count the pages of a PDF the pure Python way.
Iterate over .MP4 atoms (Popularity: ) : This script yields the atoms contained in an MP4 file. Mostly is used for extracting the tags contained in it (artist, title etc) using a convenience class (M4ATags). This script could be implemented as an generator.
Counting pages of PDF documents on Mac OS X (Popularity: ) : Given that PDF is a "native" data format on Mac OS X, it is very easy to get access to some properties of such documents. One is the number of pages. Using Python the necessary code to do this is ...
Counting pages of PDF documents on Mac O (Popularity: ) : Given that PDF is a "native" data format on Mac OS X, it is very easy to get access to some properties of such documents. One is the number of pages. Using Python the necessary code to do this is ...
Disk (Popularity: ) : This script provides a simple simulation of secondary memory and is primarily designed to provide a driver interface to a virtual hard drive. The interface is simple and allows the simulation of IO errors. Also provided are methods that allow ...
A Singleton log file creator (Popularity: ) : This class is a basic Singleton log file creator. It allows separate classes/modules to log their activities to the same file (even the same line if they want to).This is a quite basic log file creator, intended to assist in ...
Backup your files (Popularity: ) : Backup your files script makes backup versions for your files.It can be used for non-python source code also.
A Python script to test download mirrors (Popularity: ) : The concept of the script is straightforward: read the mirrors page from RedHat's web site, make a list of all the mirrors, test how long it takes to download from each, and present a sorted list of the results.

The first ...

Handling of command line arguments (Popularity: ) : This script handles arguments for small scripts that need to: - read some command line options - read some command line positional arguments - iterate over all lines of some files given on the command line, or stdin if none ...
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
BitRock Cross Platform Installer (Popularity: ) : BitRock Installbuilder allows you to create easy to use cross platform installers for Linux, Solaris, HP-UX, AIX, Windows and Mac OS X. BitRock installers are native binaries that can run on Windows ME, 2000, XP, 2003, Solaris, Mac OS X ...
MacNames Site License (Popularity: ) : File renamer converting Macintosh filenames for Windows when stored on a Windows Server, removing illegal characters and adding filenames extensions using a translation table easily customized.

Can be installed as a Windows NT/2000 Service and keeps the list of renamed files ...

Accuracer Database System (Popularity: ) : Compact, embedded, single-file, multi-user (file-server and client/server) cross-platform BDE replacement with SQL support based on a new original BDE alternative database engine that supports almost all TTable, TQuery, TDatabase, TSession, TBatchMove functions and provides some special ones to give you ...
VISOCO dbExpress driver for Sybase ASA (Linux version) (Popularity: ) : VISOCO dbExpress driver for Sybase ASA is based on the Embedded SQL database interface, provide direct access to Sybase ASA and allows avoiding Borland Database Engine (BDE), ODBC, ADO, SQL Links and Sybase Open Client. Key features: - High-performance native ...
SQL Examiner Suite 2010 R2 (Popularity: ) : SQL Examiner Suite 2010 R2 is a quick and easy-to-use software solution that enables you to compare and synchronize both schema and data. It covers all your SQL database comparison and synchronization needs, and fulfils any task on merging databases ...
Ultimate++ (Popularity: ) : Ultimate++ is a C++ cross-platform rapid application development suite. It includes a set of libraries (GUI, SQL, etc..), and an integrated development environment.

Rapid development is achieved by the smart and aggressive use of C++ rather than through fancy code ...

SimplifyJT (Popularity: ) : SimplifyJT can make that develops and deploys multi-threading java application so simple. This is a convenient and practical tool. Developer just needs extends Task class to complete plugin development. Then it can implement that remote management multi-threading task. Also it's ...
AbiWord for Linux (Popularity: ) : AbiWord is rapidly becoming a state of the art Word Processor, with lots of features useful for your daily work, personal needs, or for just some good old typing fun.

AbiWord project is unique among word processors in its drive to ...

Voice Chatter (Popularity: ) : Voice Chatter is a cross-platform and 100% free voice communication (chat) software. It was designed with gaming in mind, but can be used for many other purposes.

Why write Voice Chatter? Because there is no voice communication application that I am ...

Brainstorm Lite (Popularity: ) : Brainstorm Lite is a very restrictive brainstorming application that forces you to follow some core brainstorming rules thus achieving better results in less time. The software tracks brainstorming time and prohibits the user from entering new ideas after the time ...
ad


Rate me
supported os
All
stats
downloads 21
version 1.2
size in Kb
popularity   
1945/371354
user rating 6/10
New Scripts
Popular Scripts
Latest Reviews