import csv

csvfile = open('data_text.csv','rb')

reader = csv.reader(csvfile)           # 返回数据为列表类型

# reader = csv.DictReader(csvfile)     #返回数据为字典类型

for row in reader:

    print (row)
 

import json

json_data = open('data_text.json').read()

data = json.load(json_data)

for item in data:

    print(item)

from xml.etree import ElementTree as ET

tree = ET.parse('data_text.xml')

root = tree.getroot()

data = root.find('Data')

all_data = []

for observation in data:

    record = {}

    for item in observation:

        lookup_key = item.attrib.keys()[0]

        if lookup_key== 'Numeric':

            rec_value = item.attrib['Numeric']

        else :

            rec_key = item.attrib[lookup_key]

            rec_value = item.attrib['Code']

        record[rec_key] = rec_value

    all_data.append(record)

print all_data
 

import xlrd

book = xlrd.open_workbook('data_text.xlsx')

for sheet in book.sheets():

    print sheet.name

sheet = book.sheet_by_name('Table_9')

data = {}

for i in xrange(14,sheet.nrows):

    row = sheet.row_values(i)