SPSS Tutorials

BASICS REGRESSION T-TEST ANOVA CORRELATION

Xlrd (Python Module)

Introduction

Xlrd is a Module that allows Python to read data from MS Excel files. This tutorial explains where to get it and how to install it.

Downloading the Python Xlrd Module

Adding an Environment Variable

Python Xlrd Install 1Add Python to Path under Environment Variables in Windows Python Xlrd Install 2

Installing the Python Xlrd Module

Now we'll access the MS Windows Command Prompt. On recent Windows versions, you may need to run the command prompt as an administrator. If you search your programs for cmd, the command prompt should come up. Right-click it and select "Run as administrator".

Now we'll first set the folder where "setup.py" is located as the default directory, for example by chdir /D D:\Downloads\xlrd-0.9.2.tar\dist\xlrd-0.9.2\xlrd-0.9.2. Note that the path can be pasted into the window with a right mouse click. All that's now left to do is the actual installation by running python setup.py install. After doing so, you should be good to go.

Python Xlrd Install 3 Python Xlrd Installation - Final Step

Previous tutorial: Unicode

Next tutorial: Creating Bar Charts with Means by Category

Let me know what you think!

*Required field. Your comment will show up after approval from a moderator.

This tutorial has 14 comments