{"action":"closed","issue":{"url":"https://api.github.com/repos/tealeg/xlsx/issues/457","repository_url":"https://api.github.com/repos/tealeg/xlsx","labels_url":"https://api.github.com/repos/tealeg/xlsx/issues/457/labels{/name}","comments_url":"https://api.github.com/repos/tealeg/xlsx/issues/457/comments","events_url":"https://api.github.com/repos/tealeg/xlsx/issues/457/events","html_url":"https://github.com/tealeg/xlsx/issues/457","id":465635287,"node_id":"MDU6SXNzdWU0NjU2MzUyODc=","number":457,"title":"when I use xlsx.OpenFile to set Fill.FgColor don't work","user":{"login":"yunxi177","id":13270237,"node_id":"MDQ6VXNlcjEzMjcwMjM3","avatar_url":"https://avatars1.githubusercontent.com/u/13270237?v=4","gravatar_id":"","url":"https://api.github.com/users/yunxi177","html_url":"https://github.com/yunxi177","followers_url":"https://api.github.com/users/yunxi177/followers","following_url":"https://api.github.com/users/yunxi177/following{/other_user}","gists_url":"https://api.github.com/users/yunxi177/gists{/gist_id}","starred_url":"https://api.github.com/users/yunxi177/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yunxi177/subscriptions","organizations_url":"https://api.github.com/users/yunxi177/orgs","repos_url":"https://api.github.com/users/yunxi177/repos","events_url":"https://api.github.com/users/yunxi177/events{/privacy}","received_events_url":"https://api.github.com/users/yunxi177/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2019-07-09T08:11:50Z","updated_at":"2019-10-12T10:17:01Z","closed_at":"2019-10-12T10:17:00Z","author_association":"NONE","body":"code :\r\n```\r\n        excelFileName := \"./foo.xlsx\"\r\n\txlFile, err := xlsx.OpenFile(excelFileName)\r\n\tif err != nil {\r\n\t\tfmt.Println(err)\r\n\t}\r\n\tfor _, sheet := range xlFile.Sheets {\r\n\t\tfor _, row := range sheet.Rows {\r\n\t\t\tfor _, cell := range row.Cells {\r\n\t\t\t\tstyle := cell.GetStyle()\r\n\t\t\t\tstyle.Fill.FgColor = \"FFFFFF00\"\r\n\t\t\t\tstyle.Fill.BgColor = \"FFFFFF00\"\r\n\t\t\t\tstyle.Fill.PatternType = \"solid\"\r\n\t\t\t\tcell.SetStyle(style)\r\n\r\n\t\t\t\ttext := cell.String()\r\n\t\t\t\tfmt.Printf(\"%s\\n\", text)\r\n\t\t\t}\r\n\t\t}\r\n\t}\r\n\terr = xlFile.Save(\"test.xlsx\")\r\n\tif err != nil {\r\n\t\tfmt.Println(err)\r\n\t}\r\n```"}}
{"actor":{"display_login":"tealeg"}}