'330000': '浙江省', '120000': '天津市', '320000': '江苏省',
'640000': '宁夏回族自治区', '500000': '重庆市', '310000': '上海市',
'150000': '内蒙古自治区', '360000': '江西省', '450000': '广西壮族自治区',
'410000': '河南省', '510000': '四川省', '650000': '新疆维吾尔自治区',
'430000': '湖南省', '420000': '湖北省', '620000': '甘肃省',
'530000': '云南省', '110000': '北京市', '350000': '福建省',
'520000': '贵州省', '140000': '山西省', '220000': '吉林省',
'460000': '海南省', '370000': '山东省', '630000': '青海省',
'210000': '辽宁省', '340000': '安徽省', '230000': '黑龙江省',
'540000': '西藏自治区'}
Province_dict_reversed = {Province_dict[key]:key for key in Province_dict}
print(Province_dict_reversed)
db = Database()
db._connect('internetDB','Hospital')
filename = 'D:/temp/hospital.xlsx'
mexcel = Excel(filename)
print(mexcel.sheetname)
for province in mexcel.sheetname:
if province in Province_dict_reversed:
province_id = Province_dict_reversed[province]
else:
print('Not Match: province')
hospital_list = mexcel.read(sheet=province)
hospital_list.pop(0)
for record in hospital_list:
mongodb_record = {'医院名称':record[0],'医院类别':record[1],'医院等级':record[2],
