diff options
| author | xuri <xuri.me@gmail.com> | 2022-08-13 11:21:59 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-08-13 11:21:59 +0800 |
| commit | 551fb8a9e4b03fe718a339e75aeacc8b5581378a (patch) | |
| tree | 17e38203f802da690e709072305476b450a620ac /styles.go | |
| parent | 8152bbb2cec76f074dc18c43f3c66bf8abdf9de0 (diff) | |
This closes #1244 and closes #1314, improving the compatibility with Google Sheet
- Format code with `gofmt`
Diffstat (limited to 'styles.go')
| -rw-r--r-- | styles.go | 1913 |
1 files changed, 955 insertions, 958 deletions
@@ -985,863 +985,862 @@ func parseFormatStyleSet(style interface{}) (*Style, error) { // // The following shows the border styles sorted by excelize index number: // -// Index | Name | Weight | Style -// -------+---------------+--------+------------- -// 0 | None | 0 | -// 1 | Continuous | 1 | ----------- -// 2 | Continuous | 2 | ----------- -// 3 | Dash | 1 | - - - - - - -// 4 | Dot | 1 | . . . . . . -// 5 | Continuous | 3 | ----------- -// 6 | Double | 3 | =========== -// 7 | Continuous | 0 | ----------- -// 8 | Dash | 2 | - - - - - - -// 9 | Dash Dot | 1 | - . - . - . -// 10 | Dash Dot | 2 | - . - . - . -// 11 | Dash Dot Dot | 1 | - . . - . . -// 12 | Dash Dot Dot | 2 | - . . - . . -// 13 | SlantDash Dot | 2 | / - . / - . +// Index | Name | Weight | Style +// -------+---------------+--------+------------- +// 0 | None | 0 | +// 1 | Continuous | 1 | ----------- +// 2 | Continuous | 2 | ----------- +// 3 | Dash | 1 | - - - - - - +// 4 | Dot | 1 | . . . . . . +// 5 | Continuous | 3 | ----------- +// 6 | Double | 3 | =========== +// 7 | Continuous | 0 | ----------- +// 8 | Dash | 2 | - - - - - - +// 9 | Dash Dot | 1 | - . - . - . +// 10 | Dash Dot | 2 | - . - . - . +// 11 | Dash Dot Dot | 1 | - . . - . . +// 12 | Dash Dot Dot | 2 | - . . - . . +// 13 | SlantDash Dot | 2 | / - . / - . // // The following shows the borders in the order shown in the Excel dialog: // -// Index | Style | Index | Style -// -------+-------------+-------+------------- -// 0 | None | 12 | - . . - . . -// 7 | ----------- | 13 | / - . / - . -// 4 | . . . . . . | 10 | - . - . - . -// 11 | - . . - . . | 8 | - - - - - - -// 9 | - . - . - . | 2 | ----------- -// 3 | - - - - - - | 5 | ----------- -// 1 | ----------- | 6 | =========== +// Index | Style | Index | Style +// -------+-------------+-------+------------- +// 0 | None | 12 | - . . - . . +// 7 | ----------- | 13 | / - . / - . +// 4 | . . . . . . | 10 | - . - . - . +// 11 | - . . - . . | 8 | - - - - - - +// 9 | - . - . - . | 2 | ----------- +// 3 | - - - - - - | 5 | ----------- +// 1 | ----------- | 6 | =========== // // The following shows the shading styles sorted by excelize index number: // -// Index | Style | Index | Style -// -------+-----------------+-------+----------------- -// 0 | Horizontal | 3 | Diagonal down -// 1 | Vertical | 4 | From corner -// 2 | Diagonal Up | 5 | From center +// Index | Style | Index | Style +// -------+-----------------+-------+----------------- +// 0 | Horizontal | 3 | Diagonal down +// 1 | Vertical | 4 | From corner +// 2 | Diagonal Up | 5 | From center // // The following shows the patterns styles sorted by excelize index number: // -// Index | Style | Index | Style -// -------+-----------------+-------+----------------- -// 0 | None | 10 | darkTrellis -// 1 | solid | 11 | lightHorizontal -// 2 | mediumGray | 12 | lightVertical -// 3 | darkGray | 13 | lightDown -// 4 | lightGray | 14 | lightUp -// 5 | darkHorizontal | 15 | lightGrid -// 6 | darkVertical | 16 | lightTrellis -// 7 | darkDown | 17 | gray125 -// 8 | darkUp | 18 | gray0625 -// 9 | darkGrid | | +// Index | Style | Index | Style +// -------+-----------------+-------+----------------- +// 0 | None | 10 | darkTrellis +// 1 | solid | 11 | lightHorizontal +// 2 | mediumGray | 12 | lightVertical +// 3 | darkGray | 13 | lightDown +// 4 | lightGray | 14 | lightUp +// 5 | darkHorizontal | 15 | lightGrid +// 6 | darkVertical | 16 | lightTrellis +// 7 | darkDown | 17 | gray125 +// 8 | darkUp | 18 | gray0625 +// 9 | darkGrid | | // // The following the type of horizontal alignment in cells: // -// Style -// ------------------ -// left -// center -// right -// fill -// justify -// centerContinuous -// distributed +// Style +// ------------------ +// left +// center +// right +// fill +// justify +// centerContinuous +// distributed // // The following the type of vertical alignment in cells: // -// Style -// ------------------ -// top -// center -// justify -// distributed +// Style +// ------------------ +// top +// center +// justify +// distributed // // The following the type of font underline style: // -// Style -// ------------------ -// single -// double +// Style +// ------------------ +// single +// double // // Excel's built-in all languages formats are shown in the following table: // -// Index | Format String -// -------+---------------------------------------------------- -// 0 | General -// 1 | 0 -// 2 | 0.00 -// 3 | #,##0 -// 4 | #,##0.00 -// 5 | ($#,##0_);($#,##0) -// 6 | ($#,##0_);[Red]($#,##0) -// 7 | ($#,##0.00_);($#,##0.00) -// 8 | ($#,##0.00_);[Red]($#,##0.00) -// 9 | 0% -// 10 | 0.00% -// 11 | 0.00E+00 -// 12 | # ?/? -// 13 | # ??/?? -// 14 | m/d/yy -// 15 | d-mmm-yy -// 16 | d-mmm -// 17 | mmm-yy -// 18 | h:mm AM/PM -// 19 | h:mm:ss AM/PM -// 20 | h:mm -// 21 | h:mm:ss -// 22 | m/d/yy h:mm -// ... | ... -// 37 | (#,##0_);(#,##0) -// 38 | (#,##0_);[Red](#,##0) -// 39 | (#,##0.00_);(#,##0.00) -// 40 | (#,##0.00_);[Red](#,##0.00) -// 41 | _(* #,##0_);_(* (#,##0);_(* "-"_);_(@_) -// 42 | _($* #,##0_);_($* (#,##0);_($* "-"_);_(@_) -// 43 | _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_) -// 44 | _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) -// 45 | mm:ss -// 46 | [h]:mm:ss -// 47 | mm:ss.0 -// 48 | ##0.0E+0 -// 49 | @ +// Index | Format String +// -------+---------------------------------------------------- +// 0 | General +// 1 | 0 +// 2 | 0.00 +// 3 | #,##0 +// 4 | #,##0.00 +// 5 | ($#,##0_);($#,##0) +// 6 | ($#,##0_);[Red]($#,##0) +// 7 | ($#,##0.00_);($#,##0.00) +// 8 | ($#,##0.00_);[Red]($#,##0.00) +// 9 | 0% +// 10 | 0.00% +// 11 | 0.00E+00 +// 12 | # ?/? +// 13 | # ??/?? +// 14 | m/d/yy +// 15 | d-mmm-yy +// 16 | d-mmm +// 17 | mmm-yy +// 18 | h:mm AM/PM +// 19 | h:mm:ss AM/PM +// 20 | h:mm +// 21 | h:mm:ss +// 22 | m/d/yy h:mm +// ... | ... +// 37 | (#,##0_);(#,##0) +// 38 | (#,##0_);[Red](#,##0) +// 39 | (#,##0.00_);(#,##0.00) +// 40 | (#,##0.00_);[Red](#,##0.00) +// 41 | _(* #,##0_);_(* (#,##0);_(* "-"_);_(@_) +// 42 | _($* #,##0_);_($* (#,##0);_($* "-"_);_(@_) +// 43 | _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_) +// 44 | _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) +// 45 | mm:ss +// 46 | [h]:mm:ss +// 47 | mm:ss.0 +// 48 | ##0.0E+0 +// 49 | @ // // Number format code in zh-tw language: // -// Index | Symbol -// -------+------------------------------------------- -// 27 | [$-404]e/m/d -// 28 | [$-404]e"年"m"月"d"日" -// 29 | [$-404]e"年"m"月"d"日" -// 30 | m/d/yy -// 31 | yyyy"年"m"月"d"日" -// 32 | hh"時"mm"分" -// 33 | hh"時"mm"分"ss"秒" -// 34 | 上午/下午 hh"時"mm"分" -// 35 | 上午/下午 hh"時"mm"分"ss"秒" -// 36 | [$-404]e/m/d -// 50 | [$-404]e/m/d -// 51 | [$-404]e"年"m"月"d"日" -// 52 | 上午/下午 hh"時"mm"分" -// 53 | 上午/下午 hh"時"mm"分"ss"秒" -// 54 | [$-404]e"年"m"月"d"日" -// 55 | 上午/下午 hh"時"mm"分" -// 56 | 上午/下午 hh"時"mm"分"ss"秒" -// 57 | [$-404]e/m/d -// 58 | [$-404]e"年"m"月"d"日" +// Index | Symbol +// -------+------------------------------------------- +// 27 | [$-404]e/m/d +// 28 | [$-404]e"年"m"月"d"日" +// 29 | [$-404]e"年"m"月"d"日" +// 30 | m/d/yy +// 31 | yyyy"年"m"月"d"日" +// 32 | hh"時"mm"分" +// 33 | hh"時"mm"分"ss"秒" +// 34 | 上午/下午 hh"時"mm"分" +// 35 | 上午/下午 hh"時"mm"分"ss"秒" +// 36 | [$-404]e/m/d +// 50 | [$-404]e/m/d +// 51 | [$-404]e"年"m"月"d"日" +// 52 | 上午/下午 hh"時"mm"分" +// 53 | 上午/下午 hh"時"mm"分"ss"秒" +// 54 | [$-404]e"年"m"月"d"日" +// 55 | 上午/下午 hh"時"mm"分" +// 56 | 上午/下午 hh"時"mm"分"ss"秒" +// 57 | [$-404]e/m/d +// 58 | [$-404]e"年"m"月"d"日" // // Number format code in zh-cn language: // -// Index | Symbol -// -------+------------------------------------------- -// 27 | yyyy"年"m"月" -// 28 | m"月"d"日" -// 29 | m"月"d"日" -// 30 | m-d-yy -// 31 | yyyy"年"m"月"d"日" -// 32 | h"时"mm"分" -// 33 | h"时"mm"分"ss"秒" -// 34 | 上午/下午 h"时"mm"分" -// 35 | 上午/下午 h"时"mm"分"ss"秒 -// 36 | yyyy"年"m"月 -// 50 | yyyy"年"m"月 -// 51 | m"月"d"日 -// 52 | yyyy"年"m"月 -// 53 | m"月"d"日 -// 54 | m"月"d"日 -// 55 | 上午/下午 h"时"mm"分 -// 56 | 上午/下午 h"时"mm"分"ss"秒 -// 57 | yyyy"年"m"月 -// 58 | m"月"d"日" +// Index | Symbol +// -------+------------------------------------------- +// 27 | yyyy"年"m"月" +// 28 | m"月"d"日" +// 29 | m"月"d"日" +// 30 | m-d-yy +// 31 | yyyy"年"m"月"d"日" +// 32 | h"时"mm"分" +// 33 | h"时"mm"分"ss"秒" +// 34 | 上午/下午 h"时"mm"分" +// 35 | 上午/下午 h"时"mm"分"ss"秒 +// 36 | yyyy"年"m"月 +// 50 | yyyy"年"m"月 +// 51 | m"月"d"日 +// 52 | yyyy"年"m"月 +// 53 | m"月"d"日 +// 54 | m"月"d"日 +// 55 | 上午/下午 h"时"mm"分 +// 56 | 上午/下午 h"时"mm"分"ss"秒 +// 57 | yyyy"年"m"月 +// 58 | m"月"d"日" // // Number format code with unicode values provided for language glyphs where // they occur in zh-tw language: // -// Index | Symbol -// -------+------------------------------------------- -// 27 | [$-404]e/m/ -// 28 | [$-404]e"5E74"m"6708"d"65E5 -// 29 | [$-404]e"5E74"m"6708"d"65E5 -// 30 | m/d/y -// 31 | yyyy"5E74"m"6708"d"65E5 -// 32 | hh"6642"mm"5206 -// 33 | hh"6642"mm"5206"ss"79D2 -// 34 | 4E0A5348/4E0B5348hh"6642"mm"5206 -// 35 | 4E0A5348/4E0B5348hh"6642"mm"5206"ss"79D2 -// 36 | [$-404]e/m/ -// 50 | [$-404]e/m/ -// 51 | [$-404]e"5E74"m"6708"d"65E5 -// 52 | 4E0A5348/4E0B5348hh"6642"mm"5206 -// 53 | 4E0A5348/4E0B5348hh"6642"mm"5206"ss"79D2 -// 54 | [$-404]e"5E74"m"6708"d"65E5 -// 55 | 4E0A5348/4E0B5348hh"6642"mm"5206 -// 56 | 4E0A5348/4E0B5348hh"6642"mm"5206"ss"79D2 -// 57 | [$-404]e/m/ -// 58 | [$-404]e"5E74"m"6708"d"65E5" +// Index | Symbol +// -------+------------------------------------------- +// 27 | [$-404]e/m/ +// 28 | [$-404]e"5E74"m"6708"d"65E5 +// 29 | [$-404]e"5E74"m"6708"d"65E5 +// 30 | m/d/y +// 31 | yyyy"5E74"m"6708"d"65E5 +// 32 | hh"6642"mm"5206 +// 33 | hh"6642"mm"5206"ss"79D2 +// 34 | 4E0A5348/4E0B5348hh"6642"mm"5206 +// 35 | 4E0A5348/4E0B5348hh"6642"mm"5206"ss"79D2 +// 36 | [$-404]e/m/ +// 50 | [$-404]e/m/ +// 51 | [$-404]e"5E74"m"6708"d"65E5 +// 52 | 4E0A5348/4E0B5348hh"6642"mm"5206 +// 53 | 4E0A5348/4E0B5348hh"6642"mm"5206"ss"79D2 +// 54 | [$-404]e"5E74"m"6708"d"65E5 +// 55 | 4E0A5348/4E0B5348hh"6642"mm"5206 +// 56 | 4E0A5348/4E0B5348hh"6642"mm"5206"ss"79D2 +// 57 | [$-404]e/m/ +// 58 | [$-404]e"5E74"m"6708"d"65E5" // // Number format code with unicode values provided for language glyphs where // they occur in zh-cn language: // -// Index | Symbol -// -------+------------------------------------------- -// 27 | yyyy"5E74"m"6708 -// 28 | m"6708"d"65E5 -// 29 | m"6708"d"65E5 -// 30 | m-d-y -// 31 | yyyy"5E74"m"6708"d"65E5 -// 32 | h"65F6"mm"5206 -// 33 | h"65F6"mm"5206"ss"79D2 -// 34 | 4E0A5348/4E0B5348h"65F6"mm"5206 -// 35 | 4E0A5348/4E0B5348h"65F6"mm"5206"ss"79D2 -// 36 | yyyy"5E74"m"6708 -// 50 | yyyy"5E74"m"6708 -// 51 | m"6708"d"65E5 -// 52 | yyyy"5E74"m"6708 -// 53 | m"6708"d"65E5 -// 54 | m"6708"d"65E5 -// 55 | 4E0A5348/4E0B5348h"65F6"mm"5206 -// 56 | 4E0A5348/4E0B5348h"65F6"mm"5206"ss"79D2 -// 57 | yyyy"5E74"m"6708 -// 58 | m"6708"d"65E5" +// Index | Symbol +// -------+------------------------------------------- +// 27 | yyyy"5E74"m"6708 +// 28 | m"6708"d"65E5 +// 29 | m"6708"d"65E5 +// 30 | m-d-y +// 31 | yyyy"5E74"m"6708"d"65E5 +// 32 | h"65F6"mm"5206 +// 33 | h"65F6"mm"5206"ss"79D2 +// 34 | 4E0A5348/4E0B5348h"65F6"mm"5206 +// 35 | 4E0A5348/4E0B5348h"65F6"mm"5206"ss"79D2 +// 36 | yyyy"5E74"m"6708 +// 50 | yyyy"5E74"m"6708 +// 51 | m"6708"d"65E5 +// 52 | yyyy"5E74"m"6708 +// 53 | m"6708"d"65E5 +// 54 | m"6708"d"65E5 +// 55 | 4E0A5348/4E0B5348h"65F6"mm"5206 +// 56 | 4E0A5348/4E0B5348h"65F6"mm"5206"ss"79D2 +// 57 | yyyy"5E74"m"6708 +// 58 | m"6708"d"65E5" // // Number format code in ja-jp language: // -// Index | Symbol -// -------+------------------------------------------- -// 27 | [$-411]ge.m.d -// 28 | [$-411]ggge"年"m"月"d"日 -// 29 | [$-411]ggge"年"m"月"d"日 -// 30 | m/d/y -// 31 | yyyy"年"m"月"d"日 -// 32 | h"時"mm"分 -// 33 | h"時"mm"分"ss"秒 -// 34 | yyyy"年"m"月 -// 35 | m"月"d"日 -// 36 | [$-411]ge.m.d -// 50 | [$-411]ge.m.d -// 51 | [$-411]ggge"年"m"月"d"日 -// 52 | yyyy"年"m"月 -// 53 | m"月"d"日 -// 54 | [$-411]ggge"年"m"月"d"日 -// 55 | yyyy"年"m"月 -// 56 | m"月"d"日 -// 57 | [$-411]ge.m.d -// 58 | [$-411]ggge"年"m"月"d"日" +// Index | Symbol +// -------+------------------------------------------- +// 27 | [$-411]ge.m.d +// 28 | [$-411]ggge"年"m"月"d"日 +// 29 | [$-411]ggge"年"m"月"d"日 +// 30 | m/d/y +// 31 | yyyy"年"m"月"d"日 +// 32 | h"時"mm"分 +// 33 | h"時"mm"分"ss"秒 +// 34 | yyyy"年"m"月 +// 35 | m"月"d"日 +// 36 | [$-411]ge.m.d +// 50 | [$-411]ge.m.d +// 51 | [$-411]ggge"年"m"月"d"日 +// 52 | yyyy"年"m"月 +// 53 | m"月"d"日 +// 54 | [$-411]ggge"年"m"月"d"日 +// 55 | yyyy"年"m"月 +// 56 | m"月"d"日 +// 57 | [$-411]ge.m.d +// 58 | [$-411]ggge"年"m"月"d"日" // // Number format code in ko-kr language: // -// Index | Symbol -// -------+------------------------------------------- -// 27 | yyyy"年" mm"月" dd"日 -// 28 | mm-d -// 29 | mm-d -// 30 | mm-dd-y -// 31 | yyyy"년" mm"월" dd"일 -// 32 | h"시" mm"분 -// 33 | h"시" mm"분" ss"초 -// 34 | yyyy-mm-d -// 35 | yyyy-mm-d -// 36 | yyyy"年" mm"月" dd"日 -// 50 | yyyy"年" mm"月" dd"日 -// 51 | mm-d -// 52 | yyyy-mm-d -// 53 | yyyy-mm-d -// 54 | mm-d -// 55 | yyyy-mm-d -// 56 | yyyy-mm-d -// 57 | yyyy"年" mm"月" dd"日 -// 58 | mm-dd +// Index | Symbol +// -------+------------------------------------------- +// 27 | yyyy"年" mm"月" dd"日 +// 28 | mm-d +// 29 | mm-d +// 30 | mm-dd-y +// 31 | yyyy"년" mm"월" dd"일 +// 32 | h"시" mm"분 +// 33 | h"시" mm"분" ss"초 +// 34 | yyyy-mm-d +// 35 | yyyy-mm-d +// 36 | yyyy"年" mm"月" dd"日 +// 50 | yyyy"年" mm"月" dd"日 +// 51 | mm-d +// 52 | yyyy-mm-d +// 53 | yyyy-mm-d +// 54 | mm-d +// 55 | yyyy-mm-d +// 56 | yyyy-mm-d +// 57 | yyyy"年" mm"月" dd"日 +// 58 | mm-dd // // Number format code with unicode values provided for language glyphs where // they occur in ja-jp language: // -// Index | Symbol -// -------+------------------------------------------- -// 27 | [$-411]ge.m.d -// 28 | [$-411]ggge"5E74"m"6708"d"65E5 -// 29 | [$-411]ggge"5E74"m"6708"d"65E5 -// 30 | m/d/y -// 31 | yyyy"5E74"m"6708"d"65E5 -// 32 | h"6642"mm"5206 -// 33 | h"6642"mm"5206"ss"79D2 -// 34 | yyyy"5E74"m"6708 -// 35 | m"6708"d"65E5 -// 36 | [$-411]ge.m.d -// 50 | [$-411]ge.m.d -// 51 | [$-411]ggge"5E74"m"6708"d"65E5 -// 52 | yyyy"5E74"m"6708 -// 53 | m"6708"d"65E5 -// 54 | [$-411]ggge"5E74"m"6708"d"65E5 -// 55 | yyyy"5E74"m"6708 -// 56 | m"6708"d"65E5 -// 57 | [$-411]ge.m.d -// 58 | [$-411]ggge"5E74"m"6708"d"65E5" +// Index | Symbol +// -------+------------------------------------------- +// 27 | [$-411]ge.m.d +// 28 | [$-411]ggge"5E74"m"6708"d"65E5 +// 29 | [$-411]ggge"5E74"m"6708"d"65E5 +// 30 | m/d/y +// 31 | yyyy"5E74"m"6708"d"65E5 +// 32 | h"6642"mm"5206 +// 33 | h"6642"mm"5206"ss"79D2 +// 34 | yyyy"5E74"m"6708 +// 35 | m"6708"d"65E5 +// 36 | [$-411]ge.m.d +// 50 | [$-411]ge.m.d +// 51 | [$-411]ggge"5E74"m"6708"d"65E5 +// 52 | yyyy"5E74"m"6708 +// 53 | m"6708"d"65E5 +// 54 | [$-411]ggge"5E74"m"6708"d"65E5 +// 55 | yyyy"5E74"m"6708 +// 56 | m"6708"d"65E5 +// 57 | [$-411]ge.m.d +// 58 | [$-411]ggge"5E74"m"6708"d"65E5" // // Number format code with unicode values provided for language glyphs where // they occur in ko-kr language: // -// Index | Symbol -// -------+------------------------------------------- -// 27 | yyyy"5E74" mm"6708" dd"65E5 -// 28 | mm-d -// 29 | mm-d -// 30 | mm-dd-y -// 31 | yyyy"B144" mm"C6D4" dd"C77C -// 32 | h"C2DC" mm"BD84 -// 33 | h"C2DC" mm"BD84" ss"CD08 -// 34 | yyyy-mm-d -// 35 | yyyy-mm-d -// 36 | yyyy"5E74" mm"6708" dd"65E5 -// 50 | yyyy"5E74" mm"6708" dd"65E5 -// 51 | mm-d -// 52 | yyyy-mm-d -// 53 | yyyy-mm-d -// 54 | mm-d -// 55 | yyyy-mm-d -// 56 | yyyy-mm-d -// 57 | yyyy"5E74" mm"6708" dd"65E5 -// 58 | mm-dd +// Index | Symbol +// -------+------------------------------------------- +// 27 | yyyy"5E74" mm"6708" dd"65E5 +// 28 | mm-d +// 29 | mm-d +// 30 | mm-dd-y +// 31 | yyyy"B144" mm"C6D4" dd"C77C +// 32 | h"C2DC" mm"BD84 +// 33 | h"C2DC" mm"BD84" ss"CD08 +// 34 | yyyy-mm-d +// 35 | yyyy-mm-d +// 36 | yyyy"5E74" mm"6708" dd"65E5 +// 50 | yyyy"5E74" mm"6708" dd"65E5 +// 51 | mm-d +// 52 | yyyy-mm-d +// 53 | yyyy-mm-d +// 54 | mm-d +// 55 | yyyy-mm-d +// 56 | yyyy-mm-d +// 57 | yyyy"5E74" mm"6708" dd"65E5 +// 58 | mm-dd // // Number format code in th-th language: // -// Index | Symbol -// -------+------------------------------------------- -// 59 | t -// 60 | t0.0 -// 61 | t#,## -// 62 | t#,##0.0 -// 67 | t0 -// 68 | t0.00 -// 69 | t# ?/ -// 70 | t# ??/? -// 71 | ว/ด/ปปป -// 72 | ว-ดดด-ป -// 73 | ว-ดด -// 74 | ดดด-ป -// 75 | ช:น -// 76 | ช:นน:ท -// 77 | ว/ด/ปปปป ช:น -// 78 | นน:ท -// 79 | [ช]:นน:ท -// 80 | นน:ทท. -// 81 | d/m/bb +// Index | Symbol +// -------+------------------------------------------- +// 59 | t +// 60 | t0.0 +// 61 | t#,## +// 62 | t#,##0.0 +// 67 | t0 +// 68 | t0.00 +// 69 | t# ?/ +// 70 | t# ??/? +// 71 | ว/ด/ปปป +// 72 | ว-ดดด-ป +// 73 | ว-ดด +// 74 | ดดด-ป +// 75 | ช:น +// 76 | ช:นน:ท +// 77 | ว/ด/ปปปป ช:น +// 78 | นน:ท +// 79 | [ช]:นน:ท +// 80 | นน:ทท. +// 81 | d/m/bb // // Number format code with unicode values provided for language glyphs where // they occur in th-th language: // -// Index | Symbol -// -------+------------------------------------------- -// 59 | t -// 60 | t0.0 -// 61 | t#,## -// 62 | t#,##0.0 -// 67 | t0 -// 68 | t0.00 -// 69 | t# ?/ -// 70 | t# ??/? -// 71 | 0E27/0E14/0E1B0E1B0E1B0E1 -// 72 | 0E27-0E140E140E14-0E1B0E1 -// 73 | 0E27-0E140E140E1 -// 74 | 0E140E140E14-0E1B0E1 -// 75 | 0E0A:0E190E1 -// 76 | 0E0A:0E190E19:0E170E1 -// 77 | 0E27/0E14/0E1B0E1B0E1B0E1B 0E0A:0E190E1 -// 78 | 0E190E19:0E170E1 -// 79 | [0E0A]:0E190E19:0E170E1 -// 80 | 0E190E19:0E170E17. -// 81 | d/m/bb +// Index | Symbol +// -------+------------------------------------------- +// 59 | t +// 60 | t0.0 +// 61 | t#,## +// 62 | t#,##0.0 +// 67 | t0 +// 68 | t0.00 +// 69 | t# ?/ +// 70 | t# ??/? +// 71 | 0E27/0E14/0E1B0E1B0E1B0E1 +// 72 | 0E27-0E140E140E14-0E1B0E1 +// 73 | 0E27-0E140E140E1 +// 74 | 0E140E140E14-0E1B0E1 +// 75 | 0E0A:0E190E1 +// 76 | 0E0A:0E190E19:0E170E1 +// 77 | 0E27/0E14/0E1B0E1B0E1B0E1B 0E0A:0E190E1 +// 78 | 0E190E19:0E170E1 +// 79 | [0E0A]:0E190E19:0E170E1 +// 80 | 0E190E19:0E170E17. +// 81 | d/m/bb // // Excelize built-in currency formats are shown in the following table, only // support these types in the following table (Index number is used only for // markup and is not used inside an Excel file and you can't get formatted value // by the function GetCellValue) currently: // -// Index | Symbol -// -------+--------------------------------------------------------------- -// 164 | CN¥ -// 165 | $ English (China) -// 166 | $ Cherokee (United States) -// 167 | $ Chinese (Singapore) -// 168 | $ Chinese (Taiwan) -// 169 | $ English (Australia) -// 170 | $ English (Belize) -// 171 | $ English (Canada) -// 172 | $ English (Jamaica) -// 173 | $ English (New Zealand) -// 174 | $ English (Singapore) -// 175 | $ English (Trinidad & Tobago) -// 176 | $ English (U.S. Virgin Islands) -// 177 | $ English (United States) -// 178 | $ French (Canada) -// 179 | $ Hawaiian (United States) -// 180 | $ Malay (Brunei) -// 181 | $ Quechua (Ecuador) -// 182 | $ Spanish (Chile) -// 183 | $ Spanish (Colombia) -// 184 | $ Spanish (Ecuador) -// 185 | $ Spanish (El Salvador) -// 186 | $ Spanish (Mexico) -// 187 | $ Spanish (Puerto Rico) -// 188 | $ Spanish (United States) -// 189 | $ Spanish (Uruguay) -// 190 | £ English (United Kingdom) -// 191 | £ Scottish Gaelic (United Kingdom) -// 192 | £ Welsh (United Kindom) -// 193 | ¥ Chinese (China) -// 194 | ¥ Japanese (Japan) -// 195 | ¥ Sichuan Yi (China) -// 196 | ¥ Tibetan (China) -// 197 | ¥ Uyghur (China) -// 198 | ֏ Armenian (Armenia) -// 199 | ؋ Pashto (Afghanistan) -// 200 | ؋ Persian (Afghanistan) -// 201 | ৳ Bengali (Bangladesh) -// 202 | ៛ Khmer (Cambodia) -// 203 | ₡ Spanish (Costa Rica) -// 204 | ₦ Hausa (Nigeria) -// 205 | ₦ Igbo (Nigeria) -// 206 | ₦ Yoruba (Nigeria) -// 207 | ₩ Korean (South Korea) -// 208 | ₪ Hebrew (Israel) -// 209 | ₫ Vietnamese (Vietnam) -// 210 | € Basque (Spain) -// 211 | € Breton (France) -// 212 | € Catalan (Spain) -// 213 | € Corsican (France) -// 214 | € Dutch (Belgium) -// 215 | € Dutch (Netherlands) -// 216 | € English (Ireland) -// 217 | € Estonian (Estonia) -// 218 | € Euro (€ 123) -// 219 | € Euro (123 €) -// 220 | € Finnish (Finland) -// 221 | € French (Belgium) -// 222 | € French (France) -// 223 | € French (Luxembourg) -// 224 | € French (Monaco) -// 225 | € French (Réunion) -// 226 | € Galician (Spain) -// 227 | € German (Austria) -// 228 | € German (Luxembourg) -// 229 | € Greek (Greece) -// 230 | € Inari Sami (Finland) -// 231 | € Irish (Ireland) -// 232 | € Italian (Italy) -// 233 | € Latin (Italy) -// 234 | € Latin, Serbian (Montenegro) -// 235 | € Larvian (Latvia) -// 236 | € Lithuanian (Lithuania) -// 237 | € Lower Sorbian (Germany) -// 238 | € Luxembourgish (Luxembourg) -// 239 | € Maltese (Malta) -// 240 | € Northern Sami (Finland) -// 241 | € Occitan (France) -// 242 | € Portuguese (Portugal) -// 243 | € Serbian (Montenegro) -// 244 | € Skolt Sami (Finland) -// 245 | € Slovak (Slovakia) -// 246 | € Slovenian (Slovenia) -// 247 | € Spanish (Spain) -// 248 | € Swedish (Finland) -// 249 | € Swiss German (France) -// 250 | € Upper Sorbian (Germany) -// 251 | € Western Frisian (Netherlands) -// 252 | ₭ Lao (Laos) -// 253 | ₮ Mongolian (Mongolia) -// 254 | ₮ Mongolian, Mongolian (Mongolia) -// 255 | ₱ English (Philippines) -// 256 | ₱ Filipino (Philippines) -// 257 | ₴ Ukrainian (Ukraine) -// 258 | ₸ Kazakh (Kazakhstan) -// 259 | ₹ Arabic, Kashmiri (India) -// 260 | ₹ English (India) -// 261 | ₹ Gujarati (India) -// 262 | ₹ Hindi (India) -// 263 | ₹ Kannada (India) -// 264 | ₹ Kashmiri (India) -// 265 | ₹ Konkani (India) -// 266 | ₹ Manipuri (India) -// 267 | ₹ Marathi (India) -// 268 | ₹ Nepali (India) -// 269 | ₹ Oriya (India) -// 270 | ₹ Punjabi (India) -// 271 | ₹ Sanskrit (India) -// 272 | ₹ Sindhi (India) -// 273 | ₹ Tamil (India) -// 274 | ₹ Urdu (India) -// 275 | ₺ Turkish (Turkey) -// 276 | ₼ Azerbaijani (Azerbaijan) -// 277 | ₼ Cyrillic, Azerbaijani (Azerbaijan) -// 278 | ₽ Russian (Russia) -// 279 | ₽ Sakha (Russia) -// 280 | ₾ Georgian (Georgia) -// 281 | B/. Spanish (Panama) -// 282 | Br Oromo (Ethiopia) -// 283 | Br Somali (Ethiopia) -// 284 | Br Tigrinya (Ethiopia) -// 285 | Bs Quechua (Bolivia) -// 286 | Bs Spanish (Bolivia) -// 287 | BS. Spanish (Venezuela) -// 288 | BWP Tswana (Botswana) -// 289 | C$ Spanish (Nicaragua) -// 290 | CA$ Latin, Inuktitut (Canada) -// 291 | CA$ Mohawk (Canada) -// 292 | CA$ Unified Canadian Aboriginal Syllabics, Inuktitut (Canada) -// 293 | CFA French (Mali) -// 294 | CFA French (Senegal) -// 295 | CFA Fulah (Senegal) -// 296 | CFA Wolof (Senegal) -// 297 | CHF French (Switzerland) -// 298 | CHF German (Liechtenstein) -// 299 | CHF German (Switzerland) -// 300 | CHF Italian (Switzerland) -// 301 | CHF Romansh (Switzerland) -// 302 | CLP Mapuche (Chile) -// 303 | CN¥ Mongolian, Mongolian (China) -// 304 | DZD Central Atlas Tamazight (Algeria) -// 305 | FCFA French (Cameroon) -// 306 | Ft Hungarian (Hungary) -// 307 | G French (Haiti) -// 308 | Gs. Spanish (Paraguay) -// 309 | GTQ K'iche' (Guatemala) -// 310 | HK$ Chinese (Hong Kong (China)) -// 311 | HK$ English (Hong Kong (China)) -// 312 | HRK Croatian (Croatia) -// 313 | IDR English (Indonesia) -// 314 | IQD Arbic, Central Kurdish (Iraq) -// 315 | ISK Icelandic (Iceland) -// 316 | K Burmese (Myanmar (Burma)) -// 317 | Kč Czech (Czech Republic) -// 318 | KM Bosnian (Bosnia & Herzegovina) -// 319 | KM Croatian (Bosnia & Herzegovina) -// 320 | KM Latin, Serbian (Bosnia & Herzegovina) -// 321 | kr Faroese (Faroe Islands) -// 322 | kr Northern Sami (Norway) -// 323 | kr Northern Sami (Sweden) -// 324 | kr Norwegian Bokmål (Norway) -// 325 | kr Norwegian Nynorsk (Norway) -// 326 | kr Swedish (Sweden) -// 327 | kr. Danish (Denmark) -// 328 | kr. Kalaallisut (Greenland) -// 329 | Ksh Swahili (kenya) -// 330 | L Romanian (Moldova) -// 331 | L Russian (Moldova) -// 332 | L Spanish (Honduras) -// 333 | Lekë Albanian (Albania) -// 334 | MAD Arabic, Central Atlas Tamazight (Morocco) -// 335 | MAD French (Morocco) -// 336 | MAD Tifinagh, Central Atlas Tamazight (Morocco) -// 337 | MOP$ Chinese (Macau (China)) -// 338 | MVR Divehi (Maldives) -// 339 | Nfk Tigrinya (Eritrea) -// 340 | NGN Bini (Nigeria) -// 341 | NGN Fulah (Nigeria) -// 342 | NGN Ibibio (Nigeria) -// 343 | NGN Kanuri (Nigeria) -// 344 | NOK Lule Sami (Norway) -// 345 | NOK Southern Sami (Norway) -// 346 | NZ$ Maori (New Zealand) -// 347 | PKR Sindhi (Pakistan) -// 348 | PYG Guarani (Paraguay) -// 349 | Q Spanish (Guatemala) -// 350 | R Afrikaans (South Africa) -// 351 | R English (South Africa) -// 352 | R Zulu (South Africa) -// 353 | R$ Portuguese (Brazil) -// 354 | RD$ Spanish (Dominican Republic) -// 355 | RF Kinyarwanda (Rwanda) -// 356 | RM English (Malaysia) -// 357 | RM Malay (Malaysia) -// 358 | RON Romanian (Romania) -// 359 | Rp Indonesoan (Indonesia) -// 360 | Rs Urdu (Pakistan) -// 361 | Rs. Tamil (Sri Lanka) -// 362 | RSD Latin, Serbian (Serbia) -// 363 | RSD Serbian (Serbia) -// 364 | RUB Bashkir (Russia) -// 365 | RUB Tatar (Russia) -// 366 | S/. Quechua (Peru) -// 367 | S/. Spanish (Peru) -// 368 | SEK Lule Sami (Sweden) -// 369 | SEK Southern Sami (Sweden) -// 370 | soʻm Latin, Uzbek (Uzbekistan) -// 371 | soʻm Uzbek (Uzbekistan) -// 372 | SYP Syriac (Syria) -// 373 | THB Thai (Thailand) -// 374 | TMT Turkmen (Turkmenistan) -// 375 | US$ English (Zimbabwe) -// 376 | ZAR Northern Sotho (South Africa) -// 377 | ZAR Southern Sotho (South Africa) -// 378 | ZAR Tsonga (South Africa) -// 379 | ZAR Tswana (south Africa) -// 380 | ZAR Venda (South Africa) -// 381 | ZAR Xhosa (South Africa) -// 382 | zł Polish (Poland) -// 383 | ден Macedonian (Macedonia) -// 384 | KM Cyrillic, Bosnian (Bosnia & Herzegovina) -// 385 | KM Serbian (Bosnia & Herzegovina) -// 386 | лв. Bulgarian (Bulgaria) -// 387 | p. Belarusian (Belarus) -// 388 | сом Kyrgyz (Kyrgyzstan) -// 389 | сом Tajik (Tajikistan) -// 390 | ج.م. Arabic (Egypt) -// 391 | د.أ. Arabic (Jordan) -// 392 | د.أ. Arabic (United Arab Emirates) -// 393 | د.ب. Arabic (Bahrain) -// 394 | د.ت. Arabic (Tunisia) -// 395 | د.ج. Arabic (Algeria) -// 396 | د.ع. Arabic (Iraq) -// 397 | د.ك. Arabic (Kuwait) -// 398 | د.ل. Arabic (Libya) -// 399 | د.م. Arabic (Morocco) -// 400 | ر Punjabi (Pakistan) -// 401 | ر.س. Arabic (Saudi Arabia) -// 402 | ر.ع. Arabic (Oman) -// 403 | ر.ق. Arabic (Qatar) -// 404 | ر.ي. Arabic (Yemen) -// 405 | ریال Persian (Iran) -// 406 | ل.س. Arabic (Syria) -// 407 | ل.ل. Arabic (Lebanon) -// 408 | ብር Amharic (Ethiopia) -// 409 | रू Nepaol (Nepal) -// 410 | රු. Sinhala (Sri Lanka) -// 411 | ADP -// 412 | AED -// 413 | AFA -// 414 | AFN -// 415 | ALL -// 416 | AMD -// 417 | ANG -// 418 | AOA -// 419 | ARS -// 420 | ATS -// 421 | AUD -// 422 | AWG -// 423 | AZM -// 424 | AZN -// 425 | BAM -// 426 | BBD -// 427 | BDT -// 428 | BEF -// 429 | BGL -// 430 | BGN -// 431 | BHD -// 432 | BIF -// 433 | BMD -// 434 | BND -// 435 | BOB -// 436 | BOV -// 437 | BRL -// 438 | BSD -// 439 | BTN -// 440 | BWP -// 441 | BYR -// 442 | BZD -// 443 | CAD -// 444 | CDF -// 445 | CHE -// 446 | CHF -// 447 | CHW -// 448 | CLF -// 449 | CLP -// 450 | CNY -// 451 | COP -// 452 | COU -// 453 | CRC -// 454 | CSD -// 455 | CUC -// 456 | CVE -// 457 | CYP -// 458 | CZK -// 459 | DEM -// 460 | DJF -// 461 | DKK -// 462 | DOP -// 463 | DZD -// 464 | ECS -// 465 | ECV -// 466 | EEK -// 467 | EGP -// 468 | ERN -// 469 | ESP -// 470 | ETB -// 471 | EUR -// 472 | FIM -// 473 | FJD -// 474 | FKP -// 475 | FRF -// 476 | GBP -// 477 | GEL -// 478 | GHC -// 479 | GHS -// 480 | GIP -// 481 | GMD -// 482 | GNF -// 483 | GRD -// 484 | GTQ -// 485 | GYD -// 486 | HKD -// 487 | HNL -// 488 | HRK -// 489 | HTG -// 490 | HUF -// 491 | IDR -// 492 | IEP -// 493 | ILS -// 494 | INR -// 495 | IQD -// 496 | IRR -// 497 | ISK -// 498 | ITL -// 499 | JMD -// 500 | JOD -// 501 | JPY -// 502 | KAF -// 503 | KES -// 504 | KGS -// 505 | KHR -// 506 | KMF -// 507 | KPW -// 508 | KRW -// 509 | KWD -// 510 | KYD -// 511 | KZT -// 512 | LAK -// 513 | LBP -// 514 | LKR -// 515 | LRD -// 516 | LSL -// 517 | LTL -// 518 | LUF -// 519 | LVL -// 520 | LYD -// 521 | MAD -// 522 | MDL -// 523 | MGA -// 524 | MGF -// 525 | MKD -// 526 | MMK -// 527 | MNT -// 528 | MOP -// 529 | MRO -// 530 | MTL -// 531 | MUR -// 532 | MVR -// 533 | MWK -// 534 | MXN -// 535 | MXV -// 536 | MYR -// 537 | MZM -// 538 | MZN -// 539 | NAD -// 540 | NGN -// 541 | NIO -// 542 | NLG -// 543 | NOK -// 544 | NPR -// 545 | NTD -// 546 | NZD -// 547 | OMR -// 548 | PAB -// 549 | PEN -// 550 | PGK -// 551 | PHP -// 552 | PKR -// 553 | PLN -// 554 | PTE -// 555 | PYG -// 556 | QAR -// 557 | ROL -// 558 | RON -// 559 | RSD -// 560 | RUB -// 561 | RUR -// 562 | RWF -// 563 | SAR -// 564 | SBD -// 565 | SCR -// 566 | SDD -// 567 | SDG -// 568 | SDP -// 569 | SEK -// 570 | SGD -// 571 | SHP -// 572 | SIT -// 573 | SKK -// 574 | SLL -// 575 | SOS -// 576 | SPL -// 577 | SRD -// 578 | SRG -// 579 | STD -// 580 | SVC -// 581 | SYP -// 582 | SZL -// 583 | THB -// 584 | TJR -// 585 | TJS -// 586 | TMM -// 587 | TMT -// 588 | TND -// 589 | TOP -// 590 | TRL -// 591 | TRY -// 592 | TTD -// 593 | TWD -// 594 | TZS -// 595 | UAH -// 596 | UGX -// 597 | USD -// 598 | USN -// 599 | USS -// 600 | UYI -// 601 | UYU -// 602 | UZS -// 603 | VEB -// 604 | VEF -// 605 | VND -// 606 | VUV -// 607 | WST -// 608 | XAF -// 609 | XAG -// 610 | XAU -// 611 | XB5 -// 612 | XBA -// 613 | XBB -// 614 | XBC -// 615 | XBD -// 616 | XCD -// 617 | XDR -// 618 | XFO -// 619 | XFU -// 620 | XOF -// 621 | XPD -// 622 | XPF -// 623 | XPT -// 624 | XTS -// 625 | XXX -// 626 | YER -// 627 | YUM -// 628 | ZAR -// 629 | ZMK -// 630 | ZMW -// 631 | ZWD -// 632 | ZWL -// 633 | ZWN -// 634 | ZWR +// Index | Symbol +// -------+--------------------------------------------------------------- +// 164 | CN¥ +// 165 | $ English (China) +// 166 | $ Cherokee (United States) +// 167 | $ Chinese (Singapore) +// 168 | $ Chinese (Taiwan) +// 169 | $ English (Australia) +// 170 | $ English (Belize) +// 171 | $ English (Canada) +// 172 | $ English (Jamaica) +// 173 | $ English (New Zealand) +// 174 | $ English (Singapore) +// 175 | $ English (Trinidad & Tobago) +// 176 | $ English (U.S. Virgin Islands) +// 177 | $ English (United States) +// 178 | $ French (Canada) +// 179 | $ Hawaiian (United States) +// 180 | $ Malay (Brunei) +// 181 | $ Quechua (Ecuador) +// 182 | $ Spanish (Chile) +// 183 | $ Spanish (Colombia) +// 184 | $ Spanish (Ecuador) +// 185 | $ Spanish (El Salvador) +// 186 | $ Spanish (Mexico) +// 187 | $ Spanish (Puerto Rico) +// 188 | $ Spanish (United States) +// 189 | $ Spanish (Uruguay) +// 190 | £ English (United Kingdom) +// 191 | £ Scottish Gaelic (United Kingdom) +// 192 | £ Welsh (United Kindom) +// 193 | ¥ Chinese (China) +// 194 | ¥ Japanese (Japan) +// 195 | ¥ Sichuan Yi (China) +// 196 | ¥ Tibetan (China) +// 197 | ¥ Uyghur (China) +// 198 | ֏ Armenian (Armenia) +// 199 | ؋ Pashto (Afghanistan) +// 200 | ؋ Persian (Afghanistan) +// 201 | ৳ Bengali (Bangladesh) +// 202 | ៛ Khmer (Cambodia) +// 203 | ₡ Spanish (Costa Rica) +// 204 | ₦ Hausa (Nigeria) +// 205 | ₦ Igbo (Nigeria) +// 206 | ₦ Yoruba (Nigeria) +// 207 | ₩ Korean (South Korea) +// 208 | ₪ Hebrew (Israel) +// 209 | ₫ Vietnamese (Vietnam) +// 210 | € Basque (Spain) +// 211 | € Breton (France) +// 212 | € Catalan (Spain) +// 213 | € Corsican (France) +// 214 | € Dutch (Belgium) +// 215 | € Dutch (Netherlands) +// 216 | € English (Ireland) +// 217 | € Estonian (Estonia) +// 218 | € Euro (€ 123) +// 219 | € Euro (123 €) +// 220 | € Finnish (Finland) +// 221 | € French (Belgium) +// 222 | € French (France) +// 223 | € French (Luxembourg) +// 224 | € French (Monaco) +// 225 | € French (Réunion) +// 226 | € Galician (Spain) +// 227 | € German (Austria) +// 228 | € German (Luxembourg) +// 229 | € Greek (Greece) +// 230 | € Inari Sami (Finland) +// 231 | € Irish (Ireland) +// 232 | € Italian (Italy) +// 233 | € Latin (Italy) +// 234 | € Latin, Serbian (Montenegro) +// 235 | € Larvian (Latvia) +// 236 | € Lithuanian (Lithuania) +// 237 | € Lower Sorbian (Germany) +// 238 | € Luxembourgish (Luxembourg) +// 239 | € Maltese (Malta) +// 240 | € Northern Sami (Finland) +// 241 | € Occitan (France) +// 242 | € Portuguese (Portugal) +// 243 | € Serbian (Montenegro) +// 244 | € Skolt Sami (Finland) +// 245 | € Slovak (Slovakia) +// 246 | € Slovenian (Slovenia) +// 247 | € Spanish (Spain) +// 248 | € Swedish (Finland) +// 249 | € Swiss German (France) +// 250 | € Upper Sorbian (Germany) +// 251 | € Western Frisian (Netherlands) +// 252 | ₭ Lao (Laos) +// 253 | ₮ Mongolian (Mongolia) +// 254 | ₮ Mongolian, Mongolian (Mongolia) +// 255 | ₱ English (Philippines) +// 256 | ₱ Filipino (Philippines) +// 257 | ₴ Ukrainian (Ukraine) +// 258 | ₸ Kazakh (Kazakhstan) +// 259 | ₹ Arabic, Kashmiri (India) +// 260 | ₹ English (India) +// 261 | ₹ Gujarati (India) +// 262 | ₹ Hindi (India) +// 263 | ₹ Kannada (India) +// 264 | ₹ Kashmiri (India) +// 265 | ₹ Konkani (India) +// 266 | ₹ Manipuri (India) +// 267 | ₹ Marathi (India) +// 268 | ₹ Nepali (India) +// 269 | ₹ Oriya (India) +// 270 | ₹ Punjabi (India) +// 271 | ₹ Sanskrit (India) +// 272 | ₹ Sindhi (India) +// 273 | ₹ Tamil (India) +// 274 | ₹ Urdu (India) +// 275 | ₺ Turkish (Turkey) +// 276 | ₼ Azerbaijani (Azerbaijan) +// 277 | ₼ Cyrillic, Azerbaijani (Azerbaijan) +// 278 | ₽ Russian (Russia) +// 279 | ₽ Sakha (Russia) +// 280 | ₾ Georgian (Georgia) +// 281 | B/. Spanish (Panama) +// 282 | Br Oromo (Ethiopia) +// 283 | Br Somali (Ethiopia) +// 284 | Br Tigrinya (Ethiopia) +// 285 | Bs Quechua (Bolivia) +// 286 | Bs Spanish (Bolivia) +// 287 | BS. Spanish (Venezuela) +// 288 | BWP Tswana (Botswana) +// 289 | C$ Spanish (Nicaragua) +// 290 | CA$ Latin, Inuktitut (Canada) +// 291 | CA$ Mohawk (Canada) +// 292 | CA$ Unified Canadian Aboriginal Syllabics, Inuktitut (Canada) +// 293 | CFA French (Mali) +// 294 | CFA French (Senegal) +// 295 | CFA Fulah (Senegal) +// 296 | CFA Wolof (Senegal) +// 297 | CHF French (Switzerland) +// 298 | CHF German (Liechtenstein) +// 299 | CHF German (Switzerland) +// 300 | CHF Italian (Switzerland) +// 301 | CHF Romansh (Switzerland) +// 302 | CLP Mapuche (Chile) +// 303 | CN¥ Mongolian, Mongolian (China) +// 304 | DZD Central Atlas Tamazight (Algeria) +// 305 | FCFA French (Cameroon) +// 306 | Ft Hungarian (Hungary) +// 307 | G French (Haiti) +// 308 | Gs. Spanish (Paraguay) +// 309 | GTQ K'iche' (Guatemala) +// 310 | HK$ Chinese (Hong Kong (China)) +// 311 | HK$ English (Hong Kong (China)) +// 312 | HRK Croatian (Croatia) +// 313 | IDR English (Indonesia) +// 314 | IQD Arbic, Central Kurdish (Iraq) +// 315 | ISK Icelandic (Iceland) +// 316 | K Burmese (Myanmar (Burma)) +// 317 | Kč Czech (Czech Republic) +// 318 | KM Bosnian (Bosnia & Herzegovina) +// 319 | KM Croatian (Bosnia & Herzegovina) +// 320 | KM Latin, Serbian (Bosnia & Herzegovina) +// 321 | kr Faroese (Faroe Islands) +// 322 | kr Northern Sami (Norway) +// 323 | kr Northern Sami (Sweden) +// 324 | kr Norwegian Bokmål (Norway) +// 325 | kr Norwegian Nynorsk (Norway) +// 326 | kr Swedish (Sweden) +// 327 | kr. Danish (Denmark) +// 328 | kr. Kalaallisut (Greenland) +// 329 | Ksh Swahili (kenya) +// 330 | L Romanian (Moldova) +// 331 | L Russian (Moldova) +// 332 | L Spanish (Honduras) +// 333 | Lekë Albanian (Albania) +// 334 | MAD Arabic, Central Atlas Tamazight (Morocco) +// 335 | MAD French (Morocco) +// 336 | MAD Tifinagh, Central Atlas Tamazight (Morocco) +// 337 | MOP$ Chinese (Macau (China)) +// 338 | MVR Divehi (Maldives) +// 339 | Nfk Tigrinya (Eritrea) +// 340 | NGN Bini (Nigeria) +// 341 | NGN Fulah (Nigeria) +// 342 | NGN Ibibio (Nigeria) +// 343 | NGN Kanuri (Nigeria) +// 344 | NOK Lule Sami (Norway) +// 345 | NOK Southern Sami (Norway) +// 346 | NZ$ Maori (New Zealand) +// 347 | PKR Sindhi (Pakistan) +// 348 | PYG Guarani (Paraguay) +// 349 | Q Spanish (Guatemala) +// 350 | R Afrikaans (South Africa) +// 351 | R English (South Africa) +// 352 | R Zulu (South Africa) +// 353 | R$ Portuguese (Brazil) +// 354 | RD$ Spanish (Dominican Republic) +// 355 | RF Kinyarwanda (Rwanda) +// 356 | RM English (Malaysia) +// 357 | RM Malay (Malaysia) +// 358 | RON Romanian (Romania) +// 359 | Rp Indonesoan (Indonesia) +// 360 | Rs Urdu (Pakistan) +// 361 | Rs. Tamil (Sri Lanka) +// 362 | RSD Latin, Serbian (Serbia) +// 363 | RSD Serbian (Serbia) +// 364 | RUB Bashkir (Russia) +// 365 | RUB Tatar (Russia) +// 366 | S/. Quechua (Peru) +// 367 | S/. Spanish (Peru) +// 368 | SEK Lule Sami (Sweden) +// 369 | SEK Southern Sami (Sweden) +// 370 | soʻm Latin, Uzbek (Uzbekistan) +// 371 | soʻm Uzbek (Uzbekistan) +// 372 | SYP Syriac (Syria) +// 373 | THB Thai (Thailand) +// 374 | TMT Turkmen (Turkmenistan) +// 375 | US$ English (Zimbabwe) +// 376 | ZAR Northern Sotho (South Africa) +// 377 | ZAR Southern Sotho (South Africa) +// 378 | ZAR Tsonga (South Africa) +// 379 | ZAR Tswana (south Africa) +// 380 | ZAR Venda (South Africa) +// 381 | ZAR Xhosa (South Africa) +// 382 | zł Polish (Poland) +// 383 | ден Macedonian (Macedonia) +// 384 | KM Cyrillic, Bosnian (Bosnia & Herzegovina) +// 385 | KM Serbian (Bosnia & Herzegovina) +// 386 | лв. Bulgarian (Bulgaria) +// 387 | p. Belarusian (Belarus) +// 388 | сом Kyrgyz (Kyrgyzstan) +// 389 | сом Tajik (Tajikistan) +// 390 | ج.م. Arabic (Egypt) +// 391 | د.أ. Arabic (Jordan) +// 392 | د.أ. Arabic (United Arab Emirates) +// 393 | د.ب. Arabic (Bahrain) +// 394 | د.ت. Arabic (Tunisia) +// 395 | د.ج. Arabic (Algeria) +// 396 | د.ع. Arabic (Iraq) +// 397 | د.ك. Arabic (Kuwait) +// 398 | د.ل. Arabic (Libya) +// 399 | د.م. Arabic (Morocco) +// 400 | ر Punjabi (Pakistan) +// 401 | ر.س. Arabic (Saudi Arabia) +// 402 | ر.ع. Arabic (Oman) +// 403 | ر.ق. Arabic (Qatar) +// 404 | ر.ي. Arabic (Yemen) +// 405 | ریال Persian (Iran) +// 406 | ل.س. Arabic (Syria) +// 407 | ل.ل. Arabic (Lebanon) +// 408 | ብር Amharic (Ethiopia) +// 409 | रू Nepaol (Nepal) +// 410 | රු. Sinhala (Sri Lanka) +// 411 | ADP +// 412 | AED +// 413 | AFA +// 414 | AFN +// 415 | ALL +// 416 | AMD +// 417 | ANG +// 418 | AOA +// 419 | ARS +// 420 | ATS +// 421 | AUD +// 422 | AWG +// 423 | AZM +// 424 | AZN +// 425 | BAM +// 426 | BBD +// 427 | BDT +// 428 | BEF +// 429 | BGL +// 430 | BGN +// 431 | BHD +// 432 | BIF +// 433 | BMD +// 434 | BND +// 435 | BOB +// 436 | BOV +// 437 | BRL +// 438 | BSD +// 439 | BTN +// 440 | BWP +// 441 | BYR +// 442 | BZD +// 443 | CAD +// 444 | CDF +// 445 | CHE +// 446 | CHF +// 447 | CHW +// 448 | CLF +// 449 | CLP +// 450 | CNY +// 451 | COP +// 452 | COU +// 453 | CRC +// 454 | CSD +// 455 | CUC +// 456 | CVE +// 457 | CYP +// 458 | CZK +// 459 | DEM +// 460 | DJF +// 461 | DKK +// 462 | DOP +// 463 | DZD +// 464 | ECS +// 465 | ECV +// 466 | EEK +// 467 | EGP +// 468 | ERN +// 469 | ESP +// 470 | ETB +// 471 | EUR +// 472 | FIM +// 473 | FJD +// 474 | FKP +// 475 | FRF +// 476 | GBP +// 477 | GEL +// 478 | GHC +// 479 | GHS +// 480 | GIP +// 481 | GMD +// 482 | GNF +// 483 | GRD +// 484 | GTQ +// 485 | GYD +// 486 | HKD +// 487 | HNL +// 488 | HRK +// 489 | HTG +// 490 | HUF +// 491 | IDR +// 492 | IEP +// 493 | ILS +// 494 | INR +// 495 | IQD +// 496 | IRR +// 497 | ISK +// 498 | ITL +// 499 | JMD +// 500 | JOD +// 501 | JPY +// 502 | KAF +// 503 | KES +// 504 | KGS +// 505 | KHR +// 506 | KMF +// 507 | KPW +// 508 | KRW +// 509 | KWD +// 510 | KYD +// 511 | KZT +// 512 | LAK +// 513 | LBP +// 514 | LKR +// 515 | LRD +// 516 | LSL +// 517 | LTL +// 518 | LUF +// 519 | LVL +// 520 | LYD +// 521 | MAD +// 522 | MDL +// 523 | MGA +// 524 | MGF +// 525 | MKD +// 526 | MMK +// 527 | MNT +// 528 | MOP +// 529 | MRO +// 530 | MTL +// 531 | MUR +// 532 | MVR +// 533 | MWK +// 534 | MXN +// 535 | MXV +// 536 | MYR +// 537 | MZM +// 538 | MZN +// 539 | NAD +// 540 | NGN +// 541 | NIO +// 542 | NLG +// 543 | NOK +// 544 | NPR +// 545 | NTD +// 546 | NZD +// 547 | OMR +// 548 | PAB +// 549 | PEN +// 550 | PGK +// 551 | PHP +// 552 | PKR +// 553 | PLN +// 554 | PTE +// 555 | PYG +// 556 | QAR +// 557 | ROL +// 558 | RON +// 559 | RSD +// 560 | RUB +// 561 | RUR +// 562 | RWF +// 563 | SAR +// 564 | SBD +// 565 | SCR +// 566 | SDD +// 567 | SDG +// 568 | SDP +// 569 | SEK +// 570 | SGD +// 571 | SHP +// 572 | SIT +// 573 | SKK +// 574 | SLL +// 575 | SOS +// 576 | SPL +// 577 | SRD +// 578 | SRG +// 579 | STD +// 580 | SVC +// 581 | SYP +// 582 | SZL +// 583 | THB +// 584 | TJR +// 585 | TJS +// 586 | TMM +// 587 | TMT +// 588 | TND +// 589 | TOP +// 590 | TRL +// 591 | TRY +// 592 | TTD +// 593 | TWD +// 594 | TZS +// 595 | UAH +// 596 | UGX +// 597 | USD +// 598 | USN +// 599 | USS +// 600 | UYI +// 601 | UYU +// 602 | UZS +// 603 | VEB +// 604 | VEF +// 605 | VND +// 606 | VUV +// 607 | WST +// 608 | XAF +// 609 | XAG +// 610 | XAU +// 611 | XB5 +// 612 | XBA +// 613 | XBB +// 614 | XBC +// 615 | XBD +// 616 | XCD +// 617 | XDR +// 618 | XFO +// 619 | XFU +// 620 | XOF +// 621 | XPD +// 622 | XPF +// 623 | XPT +// 624 | XTS +// 625 | XXX +// 626 | YER +// 627 | YUM +// 628 | ZAR +// 629 | ZMK +// 630 | ZMW +// 631 | ZWD +// 632 | ZWL +// 633 | ZWN +// 634 | ZWR // // Excelize support set custom number format for cell. For example, set number // as date type in Uruguay (Spanish) format for Sheet1!A6: // -// f := excelize.NewFile() -// f.SetCellValue("Sheet1", "A6", 42920.5) -// exp := "[$-380A]dddd\\,\\ dd\" de \"mmmm\" de \"yyyy;@" -// style, err := f.NewStyle(&excelize.Style{CustomNumFmt: &exp}) -// err = f.SetCellStyle("Sheet1", "A6", "A6", style) +// f := excelize.NewFile() +// f.SetCellValue("Sheet1", "A6", 42920.5) +// exp := "[$-380A]dddd\\,\\ dd\" de \"mmmm\" de \"yyyy;@" +// style, err := f.NewStyle(&excelize.Style{CustomNumFmt: &exp}) +// err = f.SetCellStyle("Sheet1", "A6", "A6", style) // // Cell Sheet1!A6 in the Excel Application: martes, 04 de Julio de 2017 -// func (f *File) NewStyle(style interface{}) (int, error) { var fs *Style var err error @@ -2476,102 +2475,101 @@ func (f *File) GetCellStyle(sheet, axis string) (int, error) { // // For example create a borders of cell H9 on Sheet1: // -// style, err := f.NewStyle(&excelize.Style{ -// Border: []excelize.Border{ -// {Type: "left", Color: "0000FF", Style: 3}, -// {Type: "top", Color: "00FF00", Style: 4}, -// {Type: "bottom", Color: "FFFF00", Style: 5}, -// {Type: "right", Color: "FF0000", Style: 6}, -// {Type: "diagonalDown", Color: "A020F0", Style: 7}, -// {Type: "diagonalUp", Color: "A020F0", Style: 8}, -// }, -// }) -// if err != nil { -// fmt.Println(err) -// } -// err = f.SetCellStyle("Sheet1", "H9", "H9", style) +// style, err := f.NewStyle(&excelize.Style{ +// Border: []excelize.Border{ +// {Type: "left", Color: "0000FF", Style: 3}, +// {Type: "top", Color: "00FF00", Style: 4}, +// {Type: "bottom", Color: "FFFF00", Style: 5}, +// {Type: "right", Color: "FF0000", Style: 6}, +// {Type: "diagonalDown", Color: "A020F0", Style: 7}, +// {Type: "diagonalUp", Color: "A020F0", Style: 8}, +// }, +// }) +// if err != nil { +// fmt.Println(err) +// } +// err = f.SetCellStyle("Sheet1", "H9", "H9", style) // // Set gradient fill with vertical variants shading styles for cell H9 on // Sheet1: // -// style, err := f.NewStyle(&excelize.Style{ -// Fill: excelize.Fill{Type: "gradient", Color: []string{"#FFFFFF", "#E0EBF5"}, Shading: 1}, -// }) -// if err != nil { -// fmt.Println(err) -// } -// err = f.SetCellStyle("Sheet1", "H9", "H9", style) +// style, err := f.NewStyle(&excelize.Style{ +// Fill: excelize.Fill{Type: "gradient", Color: []string{"#FFFFFF", "#E0EBF5"}, Shading: 1}, +// }) +// if err != nil { +// fmt.Println(err) +// } +// err = f.SetCellStyle("Sheet1", "H9", "H9", style) // // Set solid style pattern fill for cell H9 on Sheet1: // -// style, err := f.NewStyle(&excelize.Style{ -// Fill: excelize.Fill{Type: "pattern", Color: []string{"#E0EBF5"}, Pattern: 1}, -// }) -// if err != nil { -// fmt.Println(err) -// } -// err = f.SetCellStyle("Sheet1", "H9", "H9", style) +// style, err := f.NewStyle(&excelize.Style{ +// Fill: excelize.Fill{Type: "pattern", Color: []string{"#E0EBF5"}, Pattern: 1}, +// }) +// if err != nil { +// fmt.Println(err) +// } +// err = f.SetCellStyle("Sheet1", "H9", "H9", style) // // Set alignment style for cell H9 on Sheet1: // -// style, err := f.NewStyle(&excelize.Style{ -// Alignment: &excelize.Alignment{ -// Horizontal: "center", -// Indent: 1, -// JustifyLastLine: true, -// ReadingOrder: 0, -// RelativeIndent: 1, -// ShrinkToFit: true, -// TextRotation: 45, -// Vertical: "", -// WrapText: true, -// }, -// }) -// if err != nil { -// fmt.Println(err) -// } -// err = f.SetCellStyle("Sheet1", "H9", "H9", style) +// style, err := f.NewStyle(&excelize.Style{ +// Alignment: &excelize.Alignment{ +// Horizontal: "center", +// Indent: 1, +// JustifyLastLine: true, +// ReadingOrder: 0, +// RelativeIndent: 1, +// ShrinkToFit: true, +// TextRotation: 45, +// Vertical: "", +// WrapText: true, +// }, +// }) +// if err != nil { +// fmt.Println(err) +// } +// err = f.SetCellStyle("Sheet1", "H9", "H9", style) // // Dates and times in Excel are represented by real numbers, for example "Apr 7 // 2017 12:00 PM" is represented by the number 42920.5. Set date and time format // for cell H9 on Sheet1: // -// f.SetCellValue("Sheet1", "H9", 42920.5) -// style, err := f.NewStyle(&excelize.Style{NumFmt: 22}) -// if err != nil { -// fmt.Println(err) -// } -// err = f.SetCellStyle("Sheet1", "H9", "H9", style) +// f.SetCellValue("Sheet1", "H9", 42920.5) +// style, err := f.NewStyle(&excelize.Style{NumFmt: 22}) +// if err != nil { +// fmt.Println(err) +// } +// err = f.SetCellStyle("Sheet1", "H9", "H9", style) // // Set font style for cell H9 on Sheet1: // -// style, err := f.NewStyle(&excelize.Style{ -// Font: &excelize.Font{ -// Bold: true, -// Italic: true, -// Family: "Times New Roman", -// Size: 36, -// Color: "#777777", -// }, -// }) -// if err != nil { -// fmt.Println(err) -// } -// err = f.SetCellStyle("Sheet1", "H9", "H9", style) +// style, err := f.NewStyle(&excelize.Style{ +// Font: &excelize.Font{ +// Bold: true, +// Italic: true, +// Family: "Times New Roman", +// Size: 36, +// Color: "#777777", +// }, +// }) +// if err != nil { +// fmt.Println(err) +// } +// err = f.SetCellStyle("Sheet1", "H9", "H9", style) // // Hide and lock for cell H9 on Sheet1: // -// style, err := f.NewStyle(&excelize.Style{ -// Protection: &excelize.Protection{ -// Hidden: true, -// Locked: true, -// }, -// }) -// if err != nil { -// fmt.Println(err) -// } -// err = f.SetCellStyle("Sheet1", "H9", "H9", style) -// +// style, err := f.NewStyle(&excelize.Style{ +// Protection: &excelize.Protection{ +// Hidden: true, +// Locked: true, +// }, +// }) +// if err != nil { +// fmt.Println(err) +// } +// err = f.SetCellStyle("Sheet1", "H9", "H9", style) func (f *File) SetCellStyle(sheet, hCell, vCell string, styleID int) error { hCol, hRow, err := CellNameToCoordinates(hCell) if err != nil { @@ -2622,64 +2620,64 @@ func (f *File) SetCellStyle(sheet, hCell, vCell string, styleID int) error { // The type option is a required parameter and it has no default value. // Allowable type values and their associated parameters are: // -// Type | Parameters -// ---------------+------------------------------------ -// cell | criteria -// | value -// | minimum -// | maximum -// date | criteria -// | value -// | minimum -// | maximum -// time_period | criteria -// text | criteria -// | value -// average | criteria -// duplicate | (none) -// unique | (none) -// top | criteria -// | value -// bottom | criteria -// | value -// blanks | (none) -// no_blanks | (none) -// errors | (none) -// no_errors | (none) -// 2_color_scale | min_type -// | max_type -// | min_value -// | max_value -// | min_color -// | max_color -// 3_color_scale | min_type -// | mid_type -// | max_type -// | min_value -// | mid_value -// | max_value -// | min_color -// | mid_color -// | max_color -// data_bar | min_type -// | max_type -// | min_value -// | max_value -// | bar_color -// formula | criteria +// Type | Parameters +// ---------------+------------------------------------ +// cell | criteria +// | value +// | minimum +// | maximum +// date | criteria +// | value +// | minimum +// | maximum +// time_period | criteria +// text | criteria +// | value +// average | criteria +// duplicate | (none) +// unique | (none) +// top | criteria +// | value +// bottom | criteria +// | value +// blanks | (none) +// no_blanks | (none) +// errors | (none) +// no_errors | (none) +// 2_color_scale | min_type +// | max_type +// | min_value +// | max_value +// | min_color +// | max_color +// 3_color_scale | min_type +// | mid_type +// | max_type +// | min_value +// | mid_value +// | max_value +// | min_color +// | mid_color +// | max_color +// data_bar | min_type +// | max_type +// | min_value +// | max_value +// | bar_color +// formula | criteria // // The criteria parameter is used to set the criteria by which the cell data // will be evaluated. It has no default value. The most common criteria as // applied to {"type"："cell"} are: // -// between | -// not between | -// equal to | == -// not equal to | != -// greater than | > -// less than | < -// greater than or equal to | >= -// less than or equal to | <= +// between | +// not between | +// equal to | == +// not equal to | != +// greater than | > +// less than | < +// greater than or equal to | >= +// less than or equal to | <= // // You can either use Excel's textual description strings, in the first column // above, or the more common symbolic alternatives. @@ -2690,22 +2688,22 @@ func (f *File) SetCellStyle(sheet, hCell, vCell string, styleID int) error { // value: The value is generally used along with the criteria parameter to set // the rule by which the cell data will be evaluated: // -// f.SetConditionalFormat("Sheet1", "D1:D10", fmt.Sprintf(`[{"type":"cell","criteria":">","format":%d,"value":"6"}]`, format)) +// f.SetConditionalFormat("Sheet1", "D1:D10", fmt.Sprintf(`[{"type":"cell","criteria":">","format":%d,"value":"6"}]`, format)) // // The value property can also be an cell reference: // -// f.SetConditionalFormat("Sheet1", "D1:D10", fmt.Sprintf(`[{"type":"cell","criteria":">","format":%d,"value":"$C$1"}]`, format)) +// f.SetConditionalFormat("Sheet1", "D1:D10", fmt.Sprintf(`[{"type":"cell","criteria":">","format":%d,"value":"$C$1"}]`, format)) // // type: format - The format parameter is used to specify the format that will // be applied to the cell when the conditional formatting criterion is met. The // format is created using the NewConditionalStyle() method in the same way as // cell formats: // -// format, err = f.NewConditionalStyle(`{"font":{"color":"#9A0511"},"fill":{"type":"pattern","color":["#FEC7CE"],"pattern":1}}`) -// if err != nil { -// fmt.Println(err) -// } -// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"cell","criteria":">","format":%d,"value":"6"}]`, format)) +// format, err = f.NewConditionalStyle(`{"font":{"color":"#9A0511"},"fill":{"type":"pattern","color":["#FEC7CE"],"pattern":1}}`) +// if err != nil { +// fmt.Println(err) +// } +// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"cell","criteria":">","format":%d,"value":"6"}]`, format)) // // Note: In Excel, a conditional format is superimposed over the existing cell // format and not all cell format properties can be modified. Properties that @@ -2716,20 +2714,20 @@ func (f *File) SetCellStyle(sheet, hCell, vCell string, styleID int) error { // Excel specifies some default formats to be used with conditional formatting. // These can be replicated using the following excelize formats: // -// // Rose format for bad conditional. -// format1, err = f.NewConditionalStyle(`{"font":{"color":"#9A0511"},"fill":{"type":"pattern","color":["#FEC7CE"],"pattern":1}}`) +// // Rose format for bad conditional. +// format1, err = f.NewConditionalStyle(`{"font":{"color":"#9A0511"},"fill":{"type":"pattern","color":["#FEC7CE"],"pattern":1}}`) // -// // Light yellow format for neutral conditional. -// format2, err = f.NewConditionalStyle(`{"font":{"color":"#9B5713"},"fill":{"type":"pattern","color":["#FEEAA0"],"pattern":1}}`) +// // Light yellow format for neutral conditional. +// format2, err = f.NewConditionalStyle(`{"font":{"color":"#9B5713"},"fill":{"type":"pattern","color":["#FEEAA0"],"pattern":1}}`) // -// // Light green format for good conditional. -// format3, err = f.NewConditionalStyle(`{"font":{"color":"#09600B"},"fill":{"type":"pattern","color":["#C7EECF"],"pattern":1}}`) +// // Light green format for good conditional. +// format3, err = f.NewConditionalStyle(`{"font":{"color":"#09600B"},"fill":{"type":"pattern","color":["#C7EECF"],"pattern":1}}`) // // type: minimum - The minimum parameter is used to set the lower limiting value // when the criteria is either "between" or "not between". // -// // Hightlight cells rules: between... -// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"cell","criteria":"between","format":%d,"minimum":"6","maximum":"8"}]`, format)) +// // Hightlight cells rules: between... +// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"cell","criteria":"between","format":%d,"minimum":"6","maximum":"8"}]`, format)) // // type: maximum - The maximum parameter is used to set the upper limiting value // when the criteria is either "between" or "not between". See the previous @@ -2738,36 +2736,36 @@ func (f *File) SetCellStyle(sheet, hCell, vCell string, styleID int) error { // type: average - The average type is used to specify Excel's "Average" style // conditional format: // -// // Top/Bottom rules: Above Average... -// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"average","criteria":"=","format":%d, "above_average": true}]`, format1)) +// // Top/Bottom rules: Above Average... +// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"average","criteria":"=","format":%d, "above_average": true}]`, format1)) // -// // Top/Bottom rules: Below Average... -// f.SetConditionalFormat("Sheet1", "B1:B10", fmt.Sprintf(`[{"type":"average","criteria":"=","format":%d, "above_average": false}]`, format2)) +// // Top/Bottom rules: Below Average... +// f.SetConditionalFormat("Sheet1", "B1:B10", fmt.Sprintf(`[{"type":"average","criteria":"=","format":%d, "above_average": false}]`, format2)) // // type: duplicate - The duplicate type is used to highlight duplicate cells in a range: // -// // Hightlight cells rules: Duplicate Values... -// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"duplicate","criteria":"=","format":%d}]`, format)) +// // Hightlight cells rules: Duplicate Values... +// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"duplicate","criteria":"=","format":%d}]`, format)) // // type: unique - The unique type is used to highlight unique cells in a range: // -// // Hightlight cells rules: Not Equal To... -// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"unique","criteria":"=","format":%d}]`, format)) +// // Hightlight cells rules: Not Equal To... +// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"unique","criteria":"=","format":%d}]`, format)) // // type: top - The top type is used to specify the top n values by number or percentage in a range: // -// // Top/Bottom rules: Top 10. -// f.SetConditionalFormat("Sheet1", "H1:H10", fmt.Sprintf(`[{"type":"top","criteria":"=","format":%d,"value":"6"}]`, format)) +// // Top/Bottom rules: Top 10. +// f.SetConditionalFormat("Sheet1", "H1:H10", fmt.Sprintf(`[{"type":"top","criteria":"=","format":%d,"value":"6"}]`, format)) // // The criteria can be used to indicate that a percentage condition is required: // -// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"top","criteria":"=","format":%d,"value":"6","percent":true}]`, format)) +// f.SetConditionalFormat("Sheet1", "A1:A10", fmt.Sprintf(`[{"type":"top","criteria":"=","format":%d,"value":"6","percent":true}]`, format)) // // type: 2_color_scale - The 2_color_scale type is used to specify Excel's "2 // Color Scale" style conditional format: // -// // Color scales: 2 color. -// f.SetConditionalFormat("Sheet1", "A1:A10", `[{"type":"2_color_scale","criteria":"=","min_type":"min","max_type":"max","min_color":"#F8696B","max_color":"#63BE7B"}]`) +// // Color scales: 2 color. +// f.SetConditionalFormat("Sheet1", "A1:A10", `[{"type":"2_color_scale","criteria":"=","min_type":"min","max_type":"max","min_color":"#F8696B","max_color":"#63BE7B"}]`) // // This conditional type can be modified with min_type, max_type, min_value, // max_value, min_color and max_color, see below. @@ -2775,8 +2773,8 @@ func (f *File) SetCellStyle(sheet, hCell, vCell string, styleID int) error { // type: 3_color_scale - The 3_color_scale type is used to specify Excel's "3 // Color Scale" style conditional format: // -// // Color scales: 3 color. -// f.SetConditionalFormat("Sheet1", "A1:A10", `[{"type":"3_color_scale","criteria":"=","min_type":"min","mid_type":"percentile","max_type":"max","min_color":"#F8696B","mid_color":"#FFEB84","max_color":"#63BE7B"}]`) +// // Color scales: 3 color. +// f.SetConditionalFormat("Sheet1", "A1:A10", `[{"type":"3_color_scale","criteria":"=","min_type":"min","mid_type":"percentile","max_type":"max","min_color":"#F8696B","mid_color":"#FFEB84","max_color":"#63BE7B"}]`) // // This conditional type can be modified with min_type, mid_type, max_type, // min_value, mid_value, max_value, min_color, mid_color and max_color, see @@ -2787,17 +2785,17 @@ func (f *File) SetCellStyle(sheet, hCell, vCell string, styleID int) error { // // min_type - The min_type and max_type properties are available when the conditional formatting type is 2_color_scale, 3_color_scale or data_bar. The mid_type is available for 3_color_scale. The properties are used as follows: // -// // Data Bars: Gradient Fill. -// f.SetConditionalFormat("Sheet1", "K1:K10", `[{"type":"data_bar", "criteria":"=", "min_type":"min","max_type":"max","bar_color":"#638EC6"}]`) +// // Data Bars: Gradient Fill. +// f.SetConditionalFormat("Sheet1", "K1:K10", `[{"type":"data_bar", "criteria":"=", "min_type":"min","max_type":"max","bar_color":"#638EC6"}]`) // // The available min/mid/max types are: // -// min (for min_type only) -// num -// percent -// percentile -// formula -// max (for max_type only) +// min (for min_type only) +// num +// percent +// percentile +// formula +// max (for max_type only) // // mid_type - Used for 3_color_scale. Same as min_type, see above. // @@ -2816,15 +2814,14 @@ func (f *File) SetCellStyle(sheet, hCell, vCell string, styleID int) error { // The mid_color is available for 3_color_scale. The properties are used as // follows: // -// // Color scales: 3 color. -// f.SetConditionalFormat("Sheet1", "B1:B10", `[{"type":"3_color_scale","criteria":"=","min_type":"min","mid_type":"percentile","max_type":"max","min_color":"#F8696B","mid_color":"#FFEB84","max_color":"#63BE7B"}]`) +// // Color scales: 3 color. +// f.SetConditionalFormat("Sheet1", "B1:B10", `[{"type":"3_color_scale","criteria":"=","min_type":"min","mid_type":"percentile","max_type":"max","min_color":"#F8696B","mid_color":"#FFEB84","max_color":"#63BE7B"}]`) // // mid_color - Used for 3_color_scale. Same as min_color, see above. // // max_color - Same as min_color, see above. // // bar_color - Used for data_bar. Same as min_color, see above. -// func (f *File) SetConditionalFormat(sheet, area, formatSet string) error { var format []*formatConditional err := json.Unmarshal([]byte(formatSet), &format) |