def getProvinceInfoEng():
provincesInfo = ExcelTool.getArrayBySheetName(os.path.join(Setting.FILR_DIR["COMMON_DIR"], "Province.xlsx"),"province")
provincesInfoList = ExcelTool.nArrayToList(provincesInfo, 31, 6)
result = {}
for i in range(31):
proEnglishName = provincesInfoList[i][2]
result[proEnglishName] = provincesInfoList[i]
return result
def getIndexDate(request):
# Setting.FILR_DIR["INDEX_DIR"] #文件路径
files = ExcelTool.listExcelFile(Setting.FILR_DIR["INDEX_DIR"])
print(files)
resultList = {}
# 获取省份名列表，包括 ： 中文名、英文名、纬度、经度
provincesInfo = ExcelTool.getArrayBySheetName(
os.path.join(Setting.FILR_DIR["COMMON_DIR"], "Province.xlsx"),
"province")
#provincesInfoList = transform(provincesInfo,31,6)
resultList["province"] = ProvinceTool.getProvinceInfoChina()
for file in files: # 遍历每个excel文件
try:
result = {} # 单个excel文件处理后的结果
fullFileName = file.split("\\")[len(file.split("\\")) - 1]
fileName = fullFileName.split(".")[0]
if (fileName == "1"): #处理1.xlsx
print("1.xlsx")
yearNum = 0 # 有几年
yearList = [] #年份
excelData = xlrd.open_workbook(file, "rb") # excel的全部数据
sheetNameList = excelData.sheet_names() # 获取此文件的全部sheet名
# if ('year' not in sheetNameList):
# # 如果不存item，那么excel错误，
# print("Error: 文件有问题: " + file)
# break
# 读取 year， 获得年份
sheetData = ExcelTool.getNpArrayFromSheet(
excelData, "year", "name", 0, 6) # 只有6列
yearNum = sheetData.shape[0] #有几年
for i in range(yearNum):
yearList.append(str(sheetData[i][0]).split(".")[0])
resultList["year"] = yearList
yearNum = len(yearList) #年数
# 处理 “POP” 人口
sheetDataPOP = ExcelTool.getNpArrayFromSheet(
excelData, "POP", "name", 31, 0) #
sheetDataPOPList = ExcelTool.nArrayToList(
sheetDataPOP, 31, yearNum)
resultList["pop"] = sheetDataPOPList
# 处理GDP
sheetDataGDP = ExcelTool.getNpArrayFromSheet(
excelData, "GDP", "name", 31, 0) #
sheetDataGDPList = ExcelTool.nArrayToList(
sheetDataGDP, 31, yearNum)
resultList["gdp"] = sheetDataGDPList
# 处理Energy
sheetDataenergy = ExcelTool.getNpArrayFromSheet(
excelData, "energy", "name", 31, 0) #
sheetDataenergyList = ExcelTool.nArrayToList(
sheetDataenergy, 31, yearNum)
resultList["energy"] = sheetDataenergyList
print("end 1.xlsx")
elif (fileName == "2"):
print("2.xlsx")
except BaseException:
print("Error: 文件有问题: " + file)
import traceback
traceback.print_exc()
resultListJson = json.dumps(resultList)
return HttpResponse(resultListJson)
def getIndexDate(request):
# Setting.FILR_DIR["INDEX_DIR"] #文件路径
provinceNum = 31 #31个省市 不包括港澳台
files = ExcelTool.listExcelFile(Setting.FILR_DIR["INDEX_DIR"])
print(files)
resultList = {}
resultList2 = {}
# 获取省份名列表，包括 ： 中文名、英文名、纬度、经度
provincesInfo = ExcelTool.getArrayBySheetName(
os.path.join(Setting.FILR_DIR["COMMON_DIR"], "Province.xlsx"),
"province")
#provincesInfoList = transform(provincesInfo,31,6)
resultList["province"] = ProvinceTool.getProvinceInfoChina()
for file in files: # 遍历每个excel文件
try:
result = {} # 单个excel文件处理后的结果
fullFileName = file.split("\\")[len(file.split("\\")) - 1]
fileName = fullFileName.split(".")[0]
if (fileName == "1"): #处理1.xlsx
print("1.xlsx")
yearNum = 0 # 有几年
yearList = [] #年份
excelData = xlrd.open_workbook(file, "rb") # excel的全部数据
sheetNameList = excelData.sheet_names() # 获取此文件的全部sheet名
# if ('year' not in sheetNameList):
# # 如果不存item，那么excel错误，
# print("Error: 文件有问题: " + file)
# break
# 读取 year， 获得年份
sheetData = ExcelTool.getNpArrayFromSheet(
excelData, "year", "name", 0, 6) # 只有6列
yearNum = sheetData.shape[0] #有几年
for i in range(yearNum):
yearList.append(str(sheetData[i][0]).split(".")[0])
resultList["year"] = yearList
yearNum = len(yearList) #年数
# 处理 “POP” 人口
sheetDataPOP = ExcelTool.getNpArrayFromSheet(
excelData, "POP", "name", provinceNum, 0) #
sheetDataPOPList = ExcelTool.nArrayToList(
sheetDataPOP, 31, yearNum)
resultList["pop"] = sheetDataPOPList
# 处理GDP
sheetDataGDP = ExcelTool.getNpArrayFromSheet(
excelData, "GDP", "name", provinceNum, 0) #
sheetDataGDPList = ExcelTool.nArrayToList(
sheetDataGDP, 31, yearNum)
resultList["gdp"] = sheetDataGDPList
# 处理Energy
sheetDataenergy = ExcelTool.getNpArrayFromSheet(
excelData, "energy", "name", provinceNum, 0) #
sheetDataenergyList = ExcelTool.nArrayToList(
sheetDataenergy, 31, yearNum)
resultList["energy"] = sheetDataenergyList
print("end 1.xlsx")
elif (fileName == "2_r"): #处理2_r.xlsx
#读取List
excelData = xlrd.open_workbook(file, "rb") # excel的全部数据
sheetNameList = excelData.sheet_names() # 获取此文件的全部sheet名
# 读取 List， 获得年份
typeNum = 47 #类型总数，一共有47种类型
sheetListData = ExcelTool.getNpArrayFromSheet(
excelData, "List", "name", typeNum, 3) #
title = sheetListData[0][0] # 标题
unit = sheetListData[1][0] # 单位
typeList = []
typeName = []
for i in range(typeNum):
typeList.append(int(float(sheetListData[i][1]))) #划分
typeName.append(sheetListData[i][2]) #类型名称
yearList = [] # 年份
yearDataList = {}
for sheetName in sheetNameList:
if sheetName != "List":
yearList.append(int(sheetName))
yearData = ExcelTool.getNpArrayFromSheet(
excelData, sheetName, "name", typeNum,
provinceNum) # 某年的数据
sheetDataList = ExcelTool.nArrayToList(
yearData, typeNum, provinceNum) #
yearDataList[sheetName] = sheetDataList
resultList2 = {
"title": title,
"unit": unit,
"typeList": typeList,
"typeName": typeName,
"yearList": sorted(yearList),
"yearDataList": yearDataList,
"province": ProvinceTool.getProvinceInfoChina()
}
print("2_r.xlsx")
except BaseException:
print("Error: 文件有问题: " + file)
import traceback
traceback.print_exc()
resultListJson = json.dumps({
"echart1": resultList, #第一个echarts图
"echart2": resultList2 #第二个echarts图
})
return HttpResponse(resultListJson)