37,720
社区成员
发帖
与我相关
我的任务
分享
excel = xlwt.Workbook(encoding = 'utf-8')
sheet = excel.add_sheet("123", cell_overwrite_ok=False)
temp_value = 'HYPERLINK("https://wwww.baidu.com";"百度一下")'
sheet.write(1, 1, xlwt.Formula(temp_value))
excel.save("1231.xls")
data = xlrd.open_workbook('1231.xls')
table = data.sheets()[0]
print (table.row_values(1))
data = xlrd.open_workbook('1231.xls')
table = data.sheets()[0]
print (table.row_values(1))
from openpyxl import load_workbook
sheet_index = 0
file_templet = r'd:\test.xlsx'
try:
wb = load_workbook(file_templet,data_only=True)
sheet_list = wb.get_sheet_names()
ws = wb.get_sheet_by_name(sheet_list[sheet_index])
print ws['C1'].value
print ws.cell(row=1, column=3).value
except Exception, e:
str_status = "模板" + file_templet + "读取错误"
wb = load_workbook(file_templet,data_only=True)
from openpyxl import load_workbook
sheet_index = 0
file_templet = r'd:\test.xlsx'
file_save = r'd:\test2.xlsx'
try:
wb = load_workbook(file_templet,data_only=True)
sheet_list = wb.get_sheet_names()
ws = wb.get_sheet_by_name(sheet_list[sheet_index])
ws['B3'].value = '=HYPERLINK("https://wwww.baidu.com:", "百度一下")'
ws['B3'].style = 'Hyperlink'
wb.save(file_save)
except Exception, e:
str_status = "模板" + file_templet + "读取错误"
试试这个
from openpyxl import load_workbook
def save_data(file_templet,sheet_index,row_index ,rs, file_save,key_index=0):
#打开模板文件file_templet,选择sheet_index工作簿,从raw_index 行起保存结果集rs到文件file_save
try:
wb = load_workbook(file_templet)
sheet_list = wb.get_sheet_names()
ws = wb.get_sheet_by_name(sheet_list[sheet_index])
except Exception,e:
str_status = "模板" + file_templet + "读取错误"
# print str_status,str(e)
return str_status
row_i = row_index-1
for x in rs:
row_i = row_i + 1
y_i = 0
ws['A%d' % row_i] = row_i - row_index + 1
for y in x:
y_i = y_i + 1
if y is None:
ws[chr(ord('A')+y_i ) + '%d' % row_i] = ""
else:
ws[chr(ord('A') + y_i) + '%d' % row_i] = y
# 保存文件
try:
wb.save(file_save)
except Exception, e:
# print repr(e)
str_status = "保存文件" + file_save + "错误\n"+repr(e)
return str_status
else:
return "成功生成报表" + file_save + " ," + str(row_i - row_index + 1) +"条。"