From 6244276d1943d99439bdb9a4f71a1d733f85f3f9 Mon Sep 17 00:00:00 2001 From: zhangqian <zhangqian@123.com> Date: 星期四, 13 六月 2024 15:57:45 +0800 Subject: [PATCH] 增加样式,修复错误 --- service/location_forms.go | 33 +++++++++++++++++++++++++++++++-- 1 files changed, 31 insertions(+), 2 deletions(-) diff --git a/service/location_forms.go b/service/location_forms.go index af6a6c9..f6cf85b 100644 --- a/service/location_forms.go +++ b/service/location_forms.go @@ -34,7 +34,8 @@ resp.Unit = amount.Product.Unit resp.Value = resp.Amount.Mul(amount.Product.Cost) - if *amount.Product.MoreUnit { + moreUnit := amount.Product.MoreUnit + if moreUnit != nil && *moreUnit { resp.AmountMoreUnits = CreateMoreUnit(resp.Amount, amount.Product.MoreUnitList) } @@ -111,6 +112,7 @@ } else if childHeaders, ok := h.(map[string][]string); ok { for title, list := range childHeaders { f.SetCellValue("Sheet1", getColumnAlphabet(i)+"1", title) + err = f.MergeCell("Sheet1", getColumnAlphabet(i)+"1", getColumnAlphabet(i-1+len(list))+"1") // 鍚堝苟鍗曞厓鏍� for _, t := range list { f.SetCellValue("Sheet1", getColumnAlphabet(i)+"2", t) i++ @@ -119,13 +121,40 @@ } } + // 璁剧疆琛ㄥご鏍峰紡 + style := &excelize.Style{ + Border: nil, + Fill: excelize.Fill{ + Type: "pattern", + Pattern: 1, + Shading: 0, + }, + Font: &excelize.Font{ + Bold: true, + }, + Alignment: &excelize.Alignment{ + Horizontal: "center", + }, + } + titleStyle, err := f.NewStyle(style) + if err != nil { + return + } + + lastColumn := getColumnAlphabet(i) + f.SetCellStyle("Sheet1", "A1", lastColumn+"2", titleStyle) + // 璁剧疆鍒楀 + f.SetColWidth("Sheet1", "A", "C", 30) + f.SetColWidth("Sheet1", "D", lastColumn, 15) + for i, v := range dataList { - column := strconv.Itoa(i + 2) + column := strconv.Itoa(i + 3) f.SetCellValue("Sheet1", "A"+column, v.LocationName) f.SetCellValue("Sheet1", "B"+column, v.ProductName) f.SetCellValue("Sheet1", "C"+column, v.ProductTypeName) f.SetCellValue("Sheet1", "D"+column, v.Amount) FillMoreUnitToExcel(v.Amount, v.AmountMoreUnits, 4, i+2, f) + f.SetCellValue("Sheet1", "H"+column, v.Value) } fileName = fmt.Sprintf("浣嶇疆鎶ヨ〃%s.xlsx", time.Now().Format("2006-01-02-1504")) -- Gitblit v1.8.0