go接口中响应一个html页面
// ExcelShow 数据显示为excel
func ExcelShow(ctx context.Context, req ghttp.Request) ghttp.Response {
return ghttp.NewHTMLResponse(http.StatusOK, []byte(`
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>excel预览</title>
<link rel="stylesheet" href="/static/js-preview-lib/excel.css" />
<script src="/static/js-preview-lib/excel.umd.js"></script>
</head>
<body>
<div id="excel" style="width: 100vw; height: 100vh"></div>
<script>
const myExcelPreviewer = jsPreviewExcel.init(document.getElementById('excel'));
myExcelPreviewer .preview('/xxx/data?is_show=true&page=1&perPage=99999999&is_weight=0').then(()=>{
console.log('预览完成');
}).catch(e=>{
console.log('预览失败', e);
})
</script>
</body>
</html>
`))
}
go接口中返回一个excel文件:如果你不 知道怎么生成excel内容,请参考我前面的文章
// GETxxx 获取xxx数据
func GETxxx(ctx context.Context, req ghttp.Request) ghttp.Response {
params := &roimodel.xxxParams{}
if err := request.ShouldBind(req, ¶ms); err != nil {
return response.StdErrorResponseWithMsg(response.InvalidParams, err.Error())
}
data, err := xxxservice.GETData(ctx, params)
if err != nil {
return response.StdErrorResponseWithMsg(response.Failed, err.Error())
}
if params.IsShow {
reader, _ :=xxxdata.ShowExcelTable1(data)
contentType := mime.TypeByExtension(".xlsx")
return response.StdResponseStream(contentType, reader)
}
return response.StdSuccess(data)
}