import xlsxwriter 
 # 創(chuàng)建一個工作簿并添加一個工作表
 workbook = xlsxwriter.Workbook("demo.xlsx")
 worksheet = workbook.add_worksheet() 
 # 設置列寬
 worksheet.set_column("A:A", 20) 
 # 設置格式
 bold = workbook.add_format({"bold": True})
 # 設置單元格的值
 worksheet.write("A1", "Hello")
 # 帶格式的單元格
 worksheet.write("A2", "World")
 # 寫一些數(shù)字，用行列標識
 worksheet.write(2, 0, 123)
 worksheet.write(3, 0, 123.456, bold)
 # 插入一張圖片
 worksheet.insert_image("B5", "C:/Users/Cheng/Desktop/1.png")
 # 關閉文件流
 workbook.close()

 import xlrd
 import xlsxwriter 
 source_xls = ["D:/python/1.xlsx", "D:/python/2.xlsx"]
 target_xls = "D:/python/3.xlsx"
 # 讀取數(shù)據(jù)
 data = []
 for i in source_xls:
  wb = xlrd.open_workbook(i)
  for sheet in wb.sheets():
   for rownum in range(sheet.nrows):
    data.append(sheet.row_values(rownum))
 print(data)
 # 寫入數(shù)據(jù)
 workbook = xlsxwriter.Workbook(target_xls)
 worksheet = workbook.add_worksheet()
 font = workbook.add_format({"font_size":14})
 for i in range(len(data)):
  for j in range(len(data[i])):
   worksheet.write(i, j, data[i][j], font)
 # 關閉文件流
 workbook.close()