Here's a quick demo of how to use Python to pull a designated range from a spreadsheet.
In this example I'm working with this spreadsheet:
Import the the xlrd library
>>> import xlrd
Set the location of the file you are analyzing:
>>> loc = ("C:\FooFolder\Cities.xlsx")
Access the workbook:
>>> wb = xlrd.open_workbook(loc)
Designate the worksheet number you're reviewing:
>>> sheet = wb.sheet_by_index(0)
Get a column heading:
Get the total number of rows on the worksheet with data, and then print just the data in those rows from the first column
>>> for i in range(sheet.nrows):
Varying the script this way, will get all of the column headings:
>>> for x in range(sheet.ncols):
Check out Geeks for Geeks for more excellent Python tips.