import pandas as pd
import pymongo
client = pymongo.MongoClient(‘localhost‘,27017)
excel = client[‘CMC‘]
sheet1 = excel[‘CMC1‘]
import json
data = pd.DataFrame(list(sheet1.find())[:])
del data[‘-id‘]
data.to_excel(io)
原文：http://www.cnblogs.com/lcl691408557/p/7098133.html