How to write an XLS file

[lixiaoxi-coder]

We can use addSheet addRow to create a WorkBook, but how to write the content of a WorkBook to an XLS file?

[Shubhankar-Nath]

How did you solve this? Have you tried using os.create an xls file and then to open it using xls.Open ? That returns a workbook

[lixiaoxi-coder]

How did you solve this? Have you tried using os.create an xls file and then to open it using xls.Open ? That returns a workbook

No, I have to use python's xls package with go-python.

[alok87]

@lixiaoxi-coder did you do it? https://github.com/extrame/xls/issues/81#issuecomment-957416017 how was the experience? how fast or slow it is?

[shuiYe-704265085]

This library seems to only support reading xls files, so I used another library to write xls files (although the other library supports writing files, it does not support reading xls files), as shown in the following code

import (
    "fmt"
    "log"

    "github.com/extrame/xls"
    "github.com/tealeg/xlsx"
)

func main() {
    readXLS()
    // writeHandle()
}

func readXLS() {
    // 打开 XLS 文件
    xlsFile, err := xls.Open("test.xls", "utf-8")
    if err != nil {
        fmt.Println("无法打开 XLS 文件:", err)
        return
    }

    // 获取第一个工作表
    sheet := xlsFile.GetSheet(0)

    // 遍历每一行
    for i := 0; i <= int(sheet.MaxRow); i++ {
        row := sheet.Row(i)

        // 遍历每个单元格
        log.Printf("col:%d~%d\n", row.FirstCol(), row.LastCol())
        for i := row.FirstCol(); i < row.LastCol(); i++ {
            fmt.Printf("%v\t", row.Col(i))
        }

        fmt.Println() // 换行
    }
}

func writeHandle() {
    // 创建一个新的 XLS 文件
    file := xlsx.NewFile()

    // 创建一个工作表
    sheet, err := file.AddSheet("Sheet1")
    if err != nil {
        fmt.Println("无法创建工作表:", err)
        return
    }

    // 添加行和单元格
    row := sheet.AddRow()
    cell := row.AddCell()
    cell.Value = "Hello"

    // 保存文件
    err = file.Save("output.xls")
    if err != nil {
        fmt.Println("保存 XLS 文件失败:", err)
        return
    }

    fmt.Println("XLS 文件保存成功")

}