示例 1：批量生成部门报表

package main

import (
    "fmt"
    "github.com/xuri/excelize/v2"
)

type Product struct {
    Name  string
    Sales int
    Amount float64
}

func createReport(deptName string, data []Product) error {
    f := excelize.NewFile()
    defer f.Close()

    // 设置标题
    f.MergeCell("Sheet1", "A1", "C1")
    f.SetCellValue("Sheet1", "A1", deptName+" - 月度销售报表")

    // 设置表头样式
    style, _ := f.NewStyle(&excelize.Style{
        Font:      &excelize.Font{Bold: true, Color: "#FFFFFF"},
        Fill:      excelize.Fill{Type: "pattern", Color: []string{"#107C41"}, Pattern: 1},
        Alignment: &excelize.Alignment{Horizontal: "center"},
    })

    // 添加表头
    headers := []string{"产品", "销量", "金额"}
    for col, header := range headers {
        cell, _ := excelize.CoordinatesToCellName(col+1, 2)
        f.SetCellValue("Sheet1", cell, header)
        f.SetCellStyle("Sheet1", cell, cell, style)
    }

    // 添加数据
    for row, item := range data {
        rowNum := row + 3
        f.SetCellValue("Sheet1", fmt.Sprintf("A%d", rowNum), item.Name)
        f.SetCellValue("Sheet1", fmt.Sprintf("B%d", rowNum), item.Sales)
        f.SetCellValue("Sheet1", fmt.Sprintf("C%d", rowNum), item.Amount)
    }

    return f.SaveAs(fmt.Sprintf("reports/%s_报表.xlsx", deptName))
}

func main() {
    data := mapstring[]Product{
        "销售部": {{"A", 100, 5000}, {"B", 150, 7500}},
        "技术部": {{"C", 80, 4000}, {"D", 120, 6000}},
    }

    for dept, deptData := range data {
        if err := createReport(dept, deptData); err != nil {
            fmt.Println("✗", dept, "报表生成失败:", err)
        } else {
            fmt.Println("✓", dept, "报表已生成")
        }
    }
}

示例 2：并发批量生成

package main

import (
    "fmt"
    "sync"
    "github.com/xuri/excelize/v2"
)

func generateReportConcurrent(deptName string, data []Product, wg *sync.WaitGroup) {
    defer wg.Done()

    f := excelize.NewFile()
    defer f.Close()

    f.SetCellValue("Sheet1", "A1", deptName+" 报表")

    for i, item := range data {
        row := i + 2
        f.SetCellValue("Sheet1", fmt.Sprintf("A%d", row), item.Name)
        f.SetCellValue("Sheet1", fmt.Sprintf("B%d", row), item.Sales)
    }

    if err := f.SaveAs(fmt.Sprintf("reports/%s_报表.xlsx", deptName)); err != nil {
        fmt.Println("✗", deptName, err)
    } else {
        fmt.Println("✓", deptName, "已完成")
    }
}

func main() {
    data := mapstring[]Product{
        "华北区": {{"A", 100, 5000}},
        "华东区": {{"B", 150, 7500}},
        "华南区": {{"C", 80, 4000}},
        "西南区": {{"D", 120, 6000}},
    }

    var wg sync.WaitGroup
    for dept, deptData := range data {
        wg.Add(1)
        go generateReportConcurrent(dept, deptData, &wg)
    }
    wg.Wait()
    fmt.Println("所有报表生成完毕!")
}

示例 1：写入公式

package main

import (
    "fmt"
    "github.com/xuri/excelize/v2"
)

func main() {
    // 创建工作簿
    f := excelize.NewFile()
    defer f.Close()

    // 设置表头
    f.SetCellValue("Sheet1", "A1", "产品")
    f.SetCellValue("Sheet1", "B1", "单价")
    f.SetCellValue("Sheet1", "C1", "数量")
    f.SetCellValue("Sheet1", "D1", "金额")

    // 基础数据
    products := []struct {
        Name  string
        Price float64
        Qty   int
    }{
        {"苹果", 10, 5},
        {"香蕉", 8, 10},
        {"橙子", 12, 8},
    }

    for i, p := range products {
        row := i + 2
        f.SetCellValue("Sheet1", fmt.Sprintf("A%d", row), p.Name)
        f.SetCellValue("Sheet1", fmt.Sprintf("B%d", row), p.Price)
        f.SetCellValue("Sheet1", fmt.Sprintf("C%d", row), p.Qty)
        // 写入公式：单价 × 数量
        f.SetCellFormula("Sheet1", fmt.Sprintf("D%d", row),
            fmt.Sprintf("=B%d*C%d", row, row))
    }

    // 合计公式
    f.SetCellValue("Sheet1", "A5", "合计")
    f.SetCellFormula("Sheet1", "D5", "=SUM(D2:D4)")

    // 平均值公式
    f.SetCellValue("Sheet1", "A6", "平均")
    f.SetCellFormula("Sheet1", "D6", "=AVERAGE(D2:D4)")

    // 最大值/最小值
    f.SetCellFormula("Sheet1", "D7", "=MAX(D2:D4)")
    f.SetCellFormula("Sheet1", "D8", "=MIN(D2:D4)")

    if err := f.SaveAs("formulas.xlsx"); err != nil {
        fmt.Println("✗ 保存失败:", err)
    } else {
        fmt.Println("✓ 公式已写入")
    }
}

示例 2：读取公式

package main

import (
    "fmt"
    "github.com/xuri/excelize/v2"
)

func main() {
    // 加载工作簿
    f, err := excelize.OpenFile("formulas.xlsx")
    if err != nil {
        fmt.Println("✗ 打开失败:", err)
        return
    }
    defer f.Close()

    // 读取公式（返回公式字符串）
    formula, _ := f.GetCellFormula("Sheet1", "D5")
    fmt.Printf("D5 公式：%s\n", formula)

    // 读取计算结果（需要设置 calc_param）
    result, _ := f.GetCellValue("Sheet1", "D5",
        excelize.Options{UnzipSizeLimit: 100 << 20})
    fmt.Printf("D5 结果：%s\n", result)

    // 遍历所有单元格
    rows, _ := f.GetRows("Sheet1")
    for i, row := range rows {
        for j, cell := range row {
            fmt.Printf("[%d,%d]: %s  ", i+1, j+1, cell)
        }
        fmt.Println()
    }
}

示例 3：常用公式

package main

import (
    "fmt"
    "github.com/xuri/excelize/v2"
)

func main() {
    f := excelize.NewFile()
    defer f.Close()

    // 常用公式示例
    formulas := map[string]string{
        "A1": "=SUM(A1:A10)",           // 求和
        "A2": "=AVERAGE(A1:A10)",      // 平均值
        "A3": "=COUNT(A1:A10)",        // 计数
        "A4": "=MAX(A1:A10)",          // 最大值
        "A5": "=MIN(A1:A10)",          // 最小值
        "A6": "=SUMIF(A1:A10, \">100\")", // 条件求和
        "A7": "=COUNTIF(A1:A10, \">100\")", // 条件计数
        "A8": "=IF(A1>100, \"达标\", \"未达标\")", // IF 条件
    }

    f.SetCellValue("Sheet1", "B1", "公式名称")
    f.SetCellValue("Sheet1", "C1", "公式")

    row := 2
    for cell, formula := range formulas {
        f.SetCellValue("Sheet1", fmt.Sprintf("B%d", row), cell)
        f.SetCellFormula("Sheet1", fmt.Sprintf("C%d", row), formula)
        row++
    }

    if err := f.SaveAs("common_formulas.xlsx"); err != nil {
        fmt.Println("✗ 保存失败:", err)
    } else {
        fmt.Println("✓ 常用公式已保存")
    }
}

from openpyxl import Workbook
import pandas as pd

# 方法 1: openpyxl 写入
wb = Workbook()
ws = wb.active
ws.title = "员工信息"

# 写入表头
ws.append(["姓名", "年龄", "城市"])

# 写入数据
data = [
    ["张三", 28, "北京"],
    ["李四", 32, "上海"],
    ["王五", 25, "广州"]
]
for row in data:
    ws.append(row)

wb.save("output.xlsx")

# 方法 2: pandas 写入 (推荐)
df = pd.DataFrame({
    "姓名": ["张三", "李四", "王五"],
    "年龄": [28, 32, 25],
    "城市": ["北京", "上海", "广州"]
})
df.to_excel("output_pandas.xlsx", index=False)

import pandas as pd

# 读取数据
df = pd.read_excel("sales_data.xlsx")

# 数据筛选
high_sales = df[df["销售额"] > 10000]

# 分组聚合
region_summary = df.groupby("地区").agg({
    "销售额": "sum",
    "数量": "mean"
}).reset_index()

# 数据透视表
pivot = pd.pivot_table(
    df,
    values="销售额",
    index="产品",
    columns="地区",
    aggfunc="sum",
    fill_value=0
)

# 数据排序
sorted_df = df.sort_values("销售额", ascending=False)

# 保存结果
with pd.ExcelWriter("analysis_result.xlsx") as writer:
    high_sales.to_excel(writer, sheet_name="高销售额", index=False)
    region_summary.to_excel(writer, sheet_name="地区汇总", index=False)
    pivot.to_excel(writer, sheet_name="产品透视")

from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill, Alignment, Border, Side

wb = Workbook()
ws = wb.active

# 定义样式
header_font = Font(bold=True, color="FFFFFF", size=12)
header_fill = PatternFill(start_color="107c41", end_color="107c41", fill_type="solid")
center_align = Alignment(horizontal="center", vertical="center")

thin_border = Border(
    left=Side(style="thin"),
    right=Side(style="thin"),
    top=Side(style="thin"),
    bottom=Side(style="thin")
)

# 写入数据并应用样式
headers = ["姓名", "销售额", "完成率"]
for col, header in enumerate(headers, 1):
    cell = ws.cell(row=1, column=col, value=header)
    cell.font = header_font
    cell.fill = header_fill
    cell.alignment = center_align
    cell.border = thin_border

data = [
    ["张三", 150000, "120%"],
    ["李四", 120000, "96%"],
    ["王五", 98000, "78%"]
]

for row_idx, row_data in enumerate(data, 2):
    for col_idx, value in enumerate(row_data, 1):
        cell = ws.cell(row=row_idx, column=col_idx, value=value)
        cell.alignment = center_align
        cell.border = thin_border
        # 条件格式：完成率低于 90% 标红
        if col_idx == 3 and float(value.rstrip("%")) < 90:
            cell.font = Font(color="FF0000", bold=True)

# 调整列宽
ws.column_dimensions["A"].width = 15
ws.column_dimensions["B"].width = 12
ws.column_dimensions["C"].width = 10

wb.save("formatted_report.xlsx")

package main

import (
    "fmt"
    "github.com/xuri/excelize/v2"
)

func main() {
    // 创建新工作簿
    f := excelize.NewFile()
    defer f.Close()

    // 设置工作表名
    f.SetSheetName("Sheet1", "员工信息")

    // 写入表头
    headers := []string{"姓名", "年龄", "城市"}
    for i, h := range headers {
        cell, _ := excelize.CoordinatesToCellName(i+1, 1)
        f.SetCellValue("Sheet1", cell, h)
    }

    // 写入数据
    data := [][]interface{}{
        {"张三", 28, "北京"},
        {"李四", 32, "上海"},
        {"王五", 25, "广州"},
    }

    for i, row := range data {
        for j, value := range row {
            cell, _ := excelize.CoordinatesToCellName(j+1, i+2)
            f.SetCellValue("Sheet1", cell, value)
        }
    }

    // 保存文件
    if err := f.SaveAs("output.xlsx"); err != nil {
        fmt.Println("保存失败:", err)
    }
}

package main

import (
    "fmt"
    "github.com/xuri/excelize/v2"
)

func main() {
    f := excelize.NewFile()
    defer f.Close()

    // 定义样式
    style, _ := f.NewStyle(&excelize.Style{
        Font: &excelize.Font{
            Bold:  true,
            Color: "#FFFFFF",
            Size:  12,
        },
        Fill: excelize.Fill{
            Type:    "pattern",
            Color:   []string{"#107C41"},
            Pattern: 1,
        },
        Alignment: &excelize.Alignment{
            Horizontal: "center",
            Vertical:   "center",
        },
    })

    // 应用样式到表头
    headers := []string{"姓名", "销售额", "完成率"}
    for i, h := range headers {
        cell, _ := excelize.CoordinatesToCellName(i+1, 1)
        f.SetCellValue("Sheet1", cell, h)
        f.SetCellStyle("Sheet1", cell, cell, style)
    }

    // 调整列宽
    f.SetColWidth("Sheet1", "A", "C", 15)

    if err := f.SaveAs("formatted.xlsx"); err != nil {
        fmt.Println("保存失败:", err)
    }
}

package main

import (
    "fmt"
    "sync"
    "github.com/xuri/excelize/v2"
)

func processFile(filename string, wg *sync.WaitGroup) {
    defer wg.Done()

    f, err := excelize.OpenFile(filename)
    if err != nil {
        fmt.Printf("打开失败 %s: %v\n", filename, err)
        return
    }
    defer f.Close()

    // 处理数据...
    rows, _ := f.GetRows("Sheet1")
    fmt.Printf("%s: %d 行数据\n", filename, len(rows))
}

func main() {
    files := []string{
        "report1.xlsx",
        "report2.xlsx",
        "report3.xlsx",
    }

    var wg sync.WaitGroup
    for _, file := range files {
        wg.Add(1)
        go processFile(file, &wg)
    }
    wg.Wait()

    fmt.Println("所有文件处理完成!")
}