go 读写 excel 读取 txt 繁体中文转码

读取txt，繁体中文转码

package mainimport ("bufio""fmt""golang.org/x/text/encoding/traditionalchinese""os"
)func readTxtTest() {txtPath := `C:\Users\admin\Desktop\contact.txt`file, err := os.Open(txtPath)if err != nil {fmt.Println("无法打开文件:", err)return}defer file.Close()scanner := bufio.NewScanner(file)scanner.Buffer(nil, 4096)decoder := traditionalchinese.Big5.NewDecoder()for scanner.Scan() {lineBytes := scanner.Bytes()decodedLine, err := decoder.Bytes(lineBytes)if err != nil {fmt.Println("解码时出错:", err)continue}line := string(decodedLine)fmt.Println(line)}if err := scanner.Err(); err != nil {fmt.Println("读取文件时出错:", err)}}

写 excel

package mainimport "github.com/xuri/excelize"func readExcel() {f := excelize.NewFile()// 创建一个工作表index, _ := f.NewSheet("Sheet2")// 设置单元格的值f.SetCellValue("Sheet2", "A2", "Hello world.")f.SetCellValue("Sheet1", "B2", 100)// 设置工作簿的默认工作表f.SetActiveSheet(index)// 根据指定路径保存文件if err := f.SaveAs("Book1.xlsx"); err != nil {println(err.Error())}
}

参考
https://zhuanlan.zhihu.com/p/33417413