本文实例讲述了golang与php输出excel的方法。分享给大家供大家参考，具体如下：
以前输入excel的时候utf8总是乱码还是用其他方式把utf8转换为gbk才能显示,呵呵,其实是输出了csv,后来群里的朋友说需要utf8 bom excel才能正常识别utf8,今天测试了一下,很爽,比以前省了好几行代码.
golang实现:
复制代码 代码如下:
package main
import (
"os"
"encoding/csv"
)
func main() {
f, err := os.create("haha2.xls")
if err != nil {
panic(err)
}
defer f.close()
f.writestring("xefxbbxbf") // 写入utf-8 bom
w := csv.newwriter(f)
w.write([]string{"编号","姓名","年龄"})
w.write([]string{"1","张三","23"})
w.write([]string{"2","李四","24"})
w.write([]string{"3","王五","25"})
w.write([]string{"4","赵六","26"})
w.flush()
}
import (
"os"
"encoding/csv"
)
func main() {
f, err := os.create("haha2.xls")
if err != nil {
panic(err)
}
defer f.close()
f.writestring("xefxbbxbf") // 写入utf-8 bom
w := csv.newwriter(f)
w.write([]string{"编号","姓名","年龄"})
w.write([]string{"1","张三","23"})
w.write([]string{"2","李四","24"})
w.write([]string{"3","王五","25"})
w.write([]string{"4","赵六","26"})
w.flush()
}
php实现:
<?php
$datas = array(
array(1, "张三", 23),
array(2, "李四", 24),
array(3, "王五", 25),
array(4, "赵六", 26),
);
header("content-type:application/vnd.ms-excel");
header("content-disposition:filename=".date('ymdhis').".xls");
$fp = fopen('php://output', 'w');
fwrite($fp, "xefxbbxbf");
$head = array("编号", "姓名", "年龄");
fputcsv($fp, $head);
foreach ($datas as $r) {
fputcsv($fp, $r);
}
fclose($fp);
希望本文所述对大家go语言程序设计有所帮助。
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！