python对 excel的操作

-- coding : utf-8 --

coding: utf-8

import openpyxl
import xlrd
import xlwt
from xlutils.copy import copy
from decimal import Decimal
import pandas as pd
import numpy as np

def write_excel(filename,rowNum, columnList,dataList):
print(rowNum)
workbook = xlrd.open_workbook(filename)
worksheet = workbook.sheet_by_name(‘Raw Data’)
new_workbook = copy(workbook) # 将xlrd对象拷贝转化为xlwt对象
new_worksheet = new_workbook.get_sheet(0) # 获取转化后工作簿中的第一个表格
for each in columnList:
dataList2 = dataList[columnList.index(each)]
for i in range(1,rowNum-1):
# new_worksheet.write(i, each,dataList2[i])
new_worksheet.write(i, each, Decimal(dataList2[i]).quantize(Decimal(‘0.000’)))
# dataList2.index(dataList2[i])
print(i)
new_workbook.save(‘IPAnew.xls’)
return

def make_pivottabl