pip install Spire.XLS

from spire.xls import Workbook
from spire.xls import Worksheet
from spire.xls import FileFormat

# 創(chuàng)建Excel工作簿
workbook = Workbook()

# 刪除工作表并創(chuàng)建新的工作表
workbook.Worksheets.Clear()
worksheet = workbook.Worksheets.Add("成員信息")

# 設(shè)置單元格格式
worksheet.Range["A1:D1"].Style.Font.IsBold = True
worksheet.Rows[0].RowHeight = 30
worksheet.Range["A1:D1"].Style.Font.Size = 12
worksheet.Range["A2:D4"].Style.Font.Size = 11

# 寫入表頭數(shù)據(jù)
worksheet.Range["A1"].Text = "序號"
worksheet.Range["B1"].Text = "姓名"
worksheet.Range["C1"].Text = "年齡"
worksheet.Range["D1"].Text = "職業(yè)"

# 寫入其他數(shù)據(jù)
worksheet.Range["A2"].Text = "1"
worksheet.Range["A3"].Text = "2"
worksheet.Range["A4"].Text = "3"

worksheet.Range["B2"].Text = "約翰"
worksheet.Range["B3"].Text = "喬伊"
worksheet.Range["B4"].Text = "邁克"

worksheet.Range["C2"].Text = "35"
worksheet.Range["C3"].Text = "28"
worksheet.Range["C4"].Text = "42"

worksheet.Range["D2"].Text = "工程師"
worksheet.Range["D3"].Text = "律師"
worksheet.Range["D4"].Text = "醫(yī)生"

# 保存工作簿
workbook.SaveToFile("output/寫入數(shù)據(jù)到單元格.xlsx", FileFormat.Version2016)
workbook.Dispose()

from spire.xls import Workbook
from spire.xls import FileFormat

# 創(chuàng)建Excel工作簿
workbook = Workbook()

# 清除默認(rèn)工作表并新建工作表
workbook.Worksheets.Clear()
worksheet = workbook.Worksheets.Add("銷售數(shù)據(jù)")

# 設(shè)置單元格格式
worksheet.Range["A1:D1"].Style.Font.IsBold = True
worksheet.Rows[0].RowHeight = 30
worksheet.Range["A1:D1"].Style.Font.Size = 12
worksheet.Range["A2:D4"].Style.Font.Size = 11

# 數(shù)組
tableArray = [
    ["日期", "產(chǎn)品", "銷售額"],
    ["20220101", "產(chǎn)品A", "1000"],
    ["20220101", "產(chǎn)品B", "1500"],
    ["20220102", "產(chǎn)品A", "1200"],
    ["20220102", "產(chǎn)品B", "1800"],
    ["20220103", "產(chǎn)品A", "900"],
    ["20220103", "產(chǎn)品B", "1600"]
]

# 將數(shù)據(jù)逐行插入工作表
i = 1
for array in tableArray:
    worksheet.InsertArray(array, i, 1, False)

# 保存工作簿
workbook.SaveToFile("output/寫入數(shù)組到工作表.xlsx", FileFormat.Version2016)
workbook.Dispose()

from spire.xls import Workbook
from spire.xls import FileFormat

# 創(chuàng)建Workbook類的對象
workbook = Workbook()

# 載入CSV文件
workbook.LoadFromFile("銷量統(tǒng)計.csv", ",")

# 保存為Excel工作簿
workbook.SaveToFile("output/寫入CSV數(shù)據(jù)到工作表.xlsx", FileFormat.Version2016)
workbook.Dispose()

from spire.xls import *
from spire.common import *
import xml.etree.ElementTree as ET

# 創(chuàng)建一個Workbook類的對象
workbook = Workbook()

# 清除默認(rèn)工作表并添加一個工作表
workbook.Worksheets.Clear()
worksheet = workbook.Worksheets.Add("學(xué)生信息")

# 設(shè)置單元格格式
for i in range(len(worksheet.Columns)):
    col = worksheet.Columns.get_Item(i)
    col.ColumnWidth = 10

# 加載 XML 數(shù)據(jù)
xml_tree = ET.parse("學(xué)生信息.xml")
xml_root = xml_tree.getroot()

# 獲取第一個order節(jié)點來確定列數(shù)和表頭
first_student = xml_root.find("student")
header = list(first_student.iter())[1:]  # 跳過第一個節(jié)點

# 寫入表頭
for col_index, header_node in enumerate(header, start=1):
    header_text = header_node.tag
    worksheet.SetValue(1, col_index, header_text)

# 寫入數(shù)據(jù)
row_index = 2
for student in xml_root.iter("student"):
    for col_index, data_node in enumerate(list(student.iter())[1:], start=1):  # 跳過第一個節(jié)點
        value = data_node.text
        header_text = list(header[col_index - 1].iter())[0].tag
        worksheet.SetValue(row_index, col_index, value)
    row_index += 1

# 保存工作簿為新的 Excel 文件
workbook.SaveToFile("output/寫入XML到工作表.xlsx")
workbook.Dispose()

<?xml version="1.0" encoding="UTF-8"?>
<students>
  <student>
    <id>1</id>
    <name>John Doe</name>
    <major>Data Science</major>
    <gpa>3.8</gpa>
    <age>20</age>
    <gender>Male</gender>
    <contact>
      <email>john.doe@example.com</email>
      <phone>123-456-7890</phone>
    </contact>
  </student>