Nothing
context("Load Workbook Object")
test_that("Loading readTest.xlsx Sheet 1", {
fl <- system.file("extdata", "readTest.xlsx", package = "openxlsx")
wb <- loadWorkbook(fl)
sheet_data <- wb$worksheets[[2]]$sheet_data
sheet_v <- sheet_data$v
sheet_t <- sheet_data$t
sheet_f <- sheet_data$f
sheet_row <- sheet_data$rows
sheet_col <- sheet_data$cols
## Sheet 2
expected_row <- c(
1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L,
2L, 2L, 2L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 4L, 4L, 4L, 4L,
4L, 4L, 4L, 4L, 4L, 5L, 5L, 5L, 5L, 5L, 5L, 5L, 6L, 6L, 6L, 6L,
6L, 6L, 6L, 7L, 9L, 10L, 10L, 10L, 11L, 12L, 13L, 13L, 13L, 14L,
14L, 14L, 14L, 15L, 15L, 16L, 16L, 16L, 16L, 17L, 17L, 17L, 17L,
18L, 19L, 19L, 20L, 20L, 21L, 22L, 22L, 23L, 23L, 24L, 25L, 25L,
26L, 26L, 26L, 27L, 27L, 28L, 28L, 28L, 29L, 30L, 31L, 31L, 31L,
32L, 33L, 33L, 33L, 34L, 35L
)
expect_equal(sheet_row, expected_row)
expected_col <- c(
1L, 2L, 3L, 4L, 5L, 6L, 7L, 8L, 9L, 1L, 2L, 3L, 4L, 5L, 6L,
7L, 8L, 9L, 1L, 2L, 3L, 4L, 5L, 6L, 7L, 8L, 9L, 1L, 2L, 3L, 4L,
5L, 6L, 7L, 8L, 9L, 1L, 2L, 3L, 4L, 5L, 6L, 7L, 1L, 2L, 3L, 4L,
5L, 6L, 7L, 1L, 1L, 1L, 2L, 3L, 3L, 1L, 4L, 5L, 6L, 1L, 5L, 6L,
8L, 1L, 2L, 2L, 6L, 7L, 8L, 2L, 3L, 5L, 6L, 2L, 2L, 4L, 2L, 3L,
4L, 5L, 6L, 2L, 5L, 5L, 4L, 6L, 2L, 3L, 7L, 1L, 8L, 2L, 3L, 7L,
7L, 4L, 5L, 6L, 7L, 8L, 7L, 8L, 9L, 8L, 1L
)
expect_equal(sheet_col, expected_col)
expected_t <- c(
1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0
)
expect_equal(sheet_t, expected_t)
expected_v <- c(
"0", "1", "2", "3", "4", "5", "6", "7", "8", "1", "2", "3",
"4", "5", "6", "7", "8", "9", "1", "2", "3", "4", "5", "6", "7",
"8", "9", "1", "2", "3", "4", "5", "6", "7", "8", "8", "2", "2",
"3", "4", "4", "5", "6", "1", "1", "2", "2", "2", "3", "3", "1",
"2", "2", "34", "3", "4", "2", "2", "2", "3", "2", "6", "3",
"3", "2", "2", "2", "2", "2", "2", "2", "2", "2", "2", "2", "2",
"2", "2", "2", "2", "2", "2", "2", "2", "2", "2", "2", "2", "2",
"2", "2", "2", "2", "2", "2", "2", "2", "2", "2", "2", "2", "2",
"2", "2", "2", "35"
)
expect_equal(sheet_v, expected_v)
## Sheet 3
expected_col_widths <- structure(c("41.430625", "11.29", "11.0009375", "8.71578125"),
.Names = c("3", "4", "5", "6")
)
attr(expected_col_widths, "hidden") <- rep("0", 4)
expect_equal(wb$colWidths[[3]], expected_col_widths)
})
test_that("Loading readTest.xlsx Sheet 1", {
fl <- system.file("extdata", "readTest.xlsx", package = "openxlsx")
wb <- loadWorkbook(fl)
sheet_data <- wb$worksheets[[1]]$sheet_data
sheet_v <- sheet_data$v
sheet_t <- sheet_data$t
sheet_f <- sheet_data$f
sheet_row <- sheet_data$rows
sheet_col <- sheet_data$cols
## sheet 1
expected_row <- c(
1L, 1L, 1L, 1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 3L,
3L, 3L, 3L, 3L, 4L, 4L, 4L, 4L, 4L, 4L, 5L, 5L, 5L, 5L, 6L, 6L,
6L, 6L, 6L, 7L, 7L, 7L, 7L, 7L, 8L, 9L, 9L, 9L, 9L, 9L, 10L,
10L, 10L, 10L, 10L, 11L, 11L, 11L
)
expect_equal(sheet_row, expected_row)
expected_col <- c(
1L, 2L, 4L, 5L, 6L, 7L, 8L, 1L, 2L, 4L, 5L, 6L, 7L, 8L, 1L,
4L, 5L, 6L, 8L, 1L, 2L, 4L, 5L, 6L, 8L, 1L, 2L, 5L, 6L, 1L, 2L,
4L, 5L, 6L, 1L, 2L, 4L, 5L, 6L, 6L, 1L, 2L, 4L, 5L, 6L, 1L, 2L,
4L, 5L, 6L, 2L, 4L, 6L
)
expect_equal(sheet_col, expected_col)
expected_t <- c(
1, 1, 1, 1, 1, 1, 1, 2, 0, 0, 1, 0,
3, 4, 2, 4, 1, 0, 4, 2, 0, 0, 1, 0,
4, 2, 0, 4, NA, 2, 0, 0, 1, NA, 2, 0, 0,
1, 0, 0, 2, 0, 0, 1, 0, 2, 0, 0, 1, 0,
0, 0, 0
)
expect_equal(sheet_t, expected_t)
expected_v <- c(
"2096", "2097", "2098", "2099", "2107", "2108", "2109", "1",
"1", "1", "2100", "42042", "3209324 This", "#DIV/0!", "1", "#NUM!",
"2101", "42041", "#N/A", "1", "2", "1.34", "2102", "42040", "#NUM!",
"0", "2", "#NUM!", NA, "0", "3", "1.56", "2103", NA, "0", "1",
"1.7", "2104", "42037", "42036", "0", "2", "23", "2105", "42035",
"0", "3", "67.3", "2106", "42034", "1", "123", "42033"
)
expect_equal(sheet_v, expected_v)
expected_f <- c(
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "<f>\"3209324\" & \" This\"</f>",
"<f>1/0</f>", NA, NA, NA, NA, "<f>#N/A</f>", NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
)
expect_equal(sheet_f, expected_f)
## Column Widths
expected_col_widths <- structure("10.8603125", .Names = "6")
attr(expected_col_widths, "hidden") <- "0"
expect_equal(wb$colWidths[[1]], expected_col_widths)
expected_shared_strings <- structure(c(
"<si><t>v1</t></si>", "<si><t>v2</t></si>", "<si><t>v3</t></si>",
"<si><t>v4</t></si>", "<si><t>v5</t></si>", "<si><t>v6</t></si>",
"<si><t>v7</t></si>", "<si><t>v8</t></si>", "<si><t>v9</t></si>",
"<si><t>bool</t></si>", "<si><t>Date</t></si>", "<si><t>value</t></si>",
"<si><t>word</t></si>", "<si><t>N-Z-P-S-Y</t></si>", "<si><t>C-G-D-X-H</t></si>",
"<si><t>B-K-A-O-W</t></si>", "<si><t>H-P-G-O-K</t></si>", "<si><t>F-P-C-L-T</t></si>",
"<si><t>A-N-Q-P-V</t></si>", "<si><t>Y-E-B-K-O</t></si>", "<si><t>V-S-N-T-R</t></si>",
"<si><t>F-K-Z-U-S</t></si>", "<si><t>O-E-Z-T-G</t></si>", "<si><t>Q-X-F-L-N</t></si>",
"<si><t>E-D-Y-Z-N</t></si>", "<si><t>W-F-L-C-I</t></si>", "<si><t>P-S-W-Y-E</t></si>",
"<si><t>P-H-N-Q-Z</t></si>", "<si><t>S-O-L-W-J</t></si>", "<si><t>J-E-F-Q-K</t></si>",
"<si><t>D-N-O-P-Z</t></si>", "<si><t>H-Z-K-S-U</t></si>", "<si><t>B-P-A-Y-R</t></si>",
"<si><t>Z-I-X-J-V</t></si>", "<si><t>Y-S-I-M-X</t></si>", "<si><t>V-A-C-R-O</t></si>",
"<si><t>O-V-S-C-Q</t></si>", "<si><t>A-K-S-V-W</t></si>", "<si><t>B-G-U-S-J</t></si>",
"<si><t>Z-E-J-V-T</t></si>", "<si><t>P-F-C-N-T</t></si>", "<si><t>L-T-Z-D-V</t></si>",
"<si><t>K-Q-Y-N-O</t></si>", "<si><t>U-S-Z-O-E</t></si>", "<si><t>Y-F-Z-C-P</t></si>",
"<si><t>P-Y-M-I-K</t></si>", "<si><t>D-Y-A-L-T</t></si>", "<si><t>W-I-F-A-B</t></si>",
"<si><t>I-H-S-W-K</t></si>", "<si><t>U-D-J-F-K</t></si>", "<si><t>B-K-G-J-V</t></si>",
"<si><t>Y-J-E-N-B</t></si>", "<si><t>X-L-V-S-U</t></si>", "<si><t>A-I-B-S-P</t></si>",
"<si><t>U-L-D-O-M</t></si>", "<si><t>M-D-V-R-X</t></si>", "<si><t>O-Q-K-S-B</t></si>",
"<si><t>O-R-X-C-W</t></si>", "<si><t>O-F-M-A-X</t></si>", "<si><t>J-K-V-E-X</t></si>",
"<si><t>W-B-S-O-A</t></si>", "<si><t>R-N-D-G-S</t></si>", "<si><t>W-J-K-M-R</t></si>",
"<si><t>K-I-H-F-M</t></si>", "<si><t>U-F-X-P-A</t></si>", "<si><t>M-R-C-H-L</t></si>",
"<si><t>H-A-E-X-J</t></si>", "<si><t>C-B-K-L-S</t></si>", "<si><t>V-A-I-S-L</t></si>",
"<si><t>B-L-N-J-G</t></si>", "<si><t>J-X-A-D-O</t></si>", "<si><t>I-S-W-P-U</t></si>",
"<si><t>D-R-M-G-C</t></si>", "<si><t>M-V-U-D-W</t></si>", "<si><t>U-S-A-Z-B</t></si>",
"<si><t>T-E-N-F-P</t></si>", "<si><t>K-E-S-Z-Y</t></si>", "<si><t>D-J-O-T-A</t></si>",
"<si><t>F-U-Y-T-R</t></si>", "<si><t>Q-U-N-P-J</t></si>", "<si><t>D-C-V-A-X</t></si>",
"<si><t>S-B-F-E-V</t></si>", "<si><t>U-R-P-H-A</t></si>", "<si><t>R-C-Z-J-B</t></si>",
"<si><t>L-B-M-F-I</t></si>", "<si><t>D-Y-B-S-Q</t></si>", "<si><t>X-Y-D-W-P</t></si>",
"<si><t>Z-L-I-V-R</t></si>", "<si><t>Z-W-T-M-B</t></si>", "<si><t>Z-U-S-E-G</t></si>",
"<si><t>V-I-M-C-O</t></si>", "<si><t>E-K-D-R-Z</t></si>", "<si><t>Z-F-H-Y-D</t></si>",
"<si><t>O-I-X-M-A</t></si>", "<si><t>F-K-U-G-T</t></si>", "<si><t>I-P-X-J-M</t></si>",
"<si><t>F-N-Z-E-C</t></si>", "<si><t>F-A-M-X-E</t></si>", "<si><t>R-V-C-O-P</t></si>",
"<si><t>X-Y-C-V-H</t></si>", "<si><t>K-G-T-Y-I</t></si>", "<si><t>N-M-E-D-F</t></si>",
"<si><t>M-K-N-U-W</t></si>", "<si><t>L-K-J-A-B</t></si>", "<si><t>S-M-T-D-A</t></si>",
"<si><t>W-D-G-F-U</t></si>", "<si><t>X-R-Z-F-E</t></si>", "<si><t>H-L-N-G-P</t></si>",
"<si><t>Z-X-W-M-R</t></si>", "<si><t>E-F-G-J-V</t></si>", "<si><t>X-I-M-Z-V</t></si>",
"<si><t>T-A-O-L-Q</t></si>", "<si><t>F-T-X-N-B</t></si>", "<si><t>O-G-D-P-A</t></si>",
"<si><t>B-K-Z-V-M</t></si>", "<si><t>M-J-O-S-X</t></si>", "<si><t>O-D-M-S-G</t></si>",
"<si><t>W-O-V-A-D</t></si>", "<si><t>I-D-W-T-H</t></si>", "<si><t>E-C-I-A-L</t></si>",
"<si><t>P-I-W-U-T</t></si>", "<si><t>Y-P-U-L-C</t></si>", "<si><t>Q-N-A-B-E</t></si>",
"<si><t>C-F-X-Y-H</t></si>", "<si><t>Q-P-G-I-J</t></si>", "<si><t>A-Q-J-W-F</t></si>",
"<si><t>G-N-R-U-D</t></si>", "<si><t>G-L-I-F-V</t></si>", "<si><t>Y-R-P-K-X</t></si>",
"<si><t>V-W-B-G-S</t></si>", "<si><t>E-Q-D-N-F</t></si>", "<si><t>E-R-U-D-O</t></si>",
"<si><t>O-E-G-X-L</t></si>", "<si><t>D-Q-G-A-K</t></si>", "<si><t>U-Z-N-C-V</t></si>",
"<si><t>O-K-T-W-X</t></si>", "<si><t>L-W-G-K-Q</t></si>", "<si><t>I-F-O-X-Q</t></si>",
"<si><t>J-B-V-W-T</t></si>", "<si><t>U-H-I-P-Q</t></si>", "<si><t>R-W-M-S-U</t></si>",
"<si><t>F-U-M-W-H</t></si>", "<si><t>F-A-Q-U-K</t></si>", "<si><t>Q-R-D-K-I</t></si>",
"<si><t>L-P-K-V-S</t></si>", "<si><t>G-I-B-U-Q</t></si>", "<si><t>Z-W-L-G-E</t></si>",
"<si><t>Q-C-I-B-A</t></si>", "<si><t>J-N-Y-W-D</t></si>", "<si><t>T-Y-G-W-S</t></si>",
"<si><t>L-M-A-G-K</t></si>", "<si><t>O-D-S-T-K</t></si>", "<si><t>O-G-L-T-Z</t></si>",
"<si><t>N-Q-E-B-F</t></si>", "<si><t>B-F-W-A-X</t></si>", "<si><t>U-G-Q-B-M</t></si>",
"<si><t>B-O-V-U-A</t></si>", "<si><t>R-K-X-H-A</t></si>", "<si><t>B-P-Q-T-R</t></si>",
"<si><t>I-P-Z-L-V</t></si>", "<si><t>C-T-L-W-D</t></si>", "<si><t>L-Q-D-M-U</t></si>",
"<si><t>N-P-H-A-G</t></si>", "<si><t>F-O-P-G-M</t></si>", "<si><t>N-M-Z-W-L</t></si>",
"<si><t>G-V-K-Z-T</t></si>", "<si><t>F-J-T-C-U</t></si>", "<si><t>J-P-R-A-C</t></si>",
"<si><t>Z-X-V-C-W</t></si>", "<si><t>B-Z-K-I-Q</t></si>", "<si><t>E-N-L-I-Y</t></si>",
"<si><t>C-D-P-R-B</t></si>", "<si><t>I-W-X-P-V</t></si>", "<si><t>T-M-P-I-O</t></si>",
"<si><t>W-Y-D-J-K</t></si>", "<si><t>A-O-C-L-B</t></si>", "<si><t>S-R-O-Y-C</t></si>",
"<si><t>A-O-Y-N-W</t></si>", "<si><t>P-C-O-D-Y</t></si>", "<si><t>E-S-A-L-Y</t></si>",
"<si><t>E-O-Q-W-C</t></si>", "<si><t>U-O-A-X-Q</t></si>", "<si><t>W-E-N-Y-D</t></si>",
"<si><t>A-W-J-Z-X</t></si>", "<si><t>P-L-R-U-K</t></si>", "<si><t>V-J-E-K-Z</t></si>",
"<si><t>V-A-M-G-D</t></si>", "<si><t>N-C-F-M-G</t></si>", "<si><t>H-W-N-K-R</t></si>",
"<si><t>G-T-A-F-O</t></si>", "<si><t>K-F-V-G-S</t></si>", "<si><t>N-V-H-G-I</t></si>",
"<si><t>F-Y-T-S-G</t></si>", "<si><t>A-H-O-C-V</t></si>", "<si><t>Q-W-J-S-C</t></si>",
"<si><t>W-G-I-X-E</t></si>", "<si><t>D-B-V-A-N</t></si>", "<si><t>P-N-L-Y-Q</t></si>",
"<si><t>O-I-R-Q-U</t></si>", "<si><t>D-R-W-E-O</t></si>", "<si><t>W-X-U-V-P</t></si>",
"<si><t>X-Y-D-A-W</t></si>", "<si><t>M-J-B-S-G</t></si>", "<si><t>K-R-G-N-Y</t></si>",
"<si><t>O-B-K-L-M</t></si>", "<si><t>G-N-Y-X-D</t></si>", "<si><t>K-F-A-B-T</t></si>",
"<si><t>S-Z-R-L-A</t></si>", "<si><t>K-Y-W-X-A</t></si>", "<si><t>O-Q-X-I-D</t></si>",
"<si><t>I-L-R-M-X</t></si>", "<si><t>S-D-V-U-N</t></si>", "<si><t>B-W-F-A-T</t></si>",
"<si><t>A-W-X-R-J</t></si>", "<si><t>D-H-G-X-L</t></si>", "<si><t>E-C-V-U-T</t></si>",
"<si><t>D-W-P-Z-F</t></si>", "<si><t>V-O-M-P-R</t></si>", "<si><t>P-L-B-X-N</t></si>",
"<si><t>Z-U-F-D-V</t></si>", "<si><t>M-K-Z-S-Y</t></si>", "<si><t>X-P-N-T-D</t></si>",
"<si><t>U-Q-D-T-S</t></si>", "<si><t>N-I-X-S-O</t></si>", "<si><t>S-C-K-F-D</t></si>",
"<si><t>N-V-I-R-D</t></si>", "<si><t>Z-X-Y-B-P</t></si>", "<si><t>U-W-R-D-V</t></si>",
"<si><t>G-V-I-N-K</t></si>", "<si><t>D-Y-N-T-J</t></si>", "<si><t>P-K-F-U-W</t></si>",
"<si><t>U-I-P-D-Q</t></si>", "<si><t>R-T-Q-N-Z</t></si>", "<si><t>Z-R-D-V-O</t></si>",
"<si><t>Z-S-F-T-D</t></si>", "<si><t>X-K-Z-B-W</t></si>", "<si><t>U-F-Z-S-Y</t></si>",
"<si><t>X-I-T-Z-K</t></si>", "<si><t>A-X-H-N-Z</t></si>", "<si><t>R-U-Q-W-J</t></si>",
"<si><t>C-H-P-V-Y</t></si>", "<si><t>R-O-A-T-E</t></si>", "<si><t>L-F-B-X-A</t></si>",
"<si><t>Z-X-E-C-G</t></si>", "<si><t>R-B-C-Q-W</t></si>", "<si><t>A-O-Z-U-B</t></si>",
"<si><t>R-W-P-S-H</t></si>", "<si><t>R-Y-B-A-W</t></si>", "<si><t>K-X-U-I-M</t></si>",
"<si><t>O-X-F-P-A</t></si>", "<si><t>U-Y-P-D-M</t></si>", "<si><t>A-D-K-R-M</t></si>",
"<si><t>R-U-D-T-M</t></si>", "<si><t>H-Q-Y-K-J</t></si>", "<si><t>T-B-H-N-U</t></si>",
"<si><t>P-I-V-X-W</t></si>", "<si><t>S-H-X-C-U</t></si>", "<si><t>I-O-Y-G-W</t></si>",
"<si><t>A-U-Z-J-R</t></si>", "<si><t>Q-U-H-M-A</t></si>", "<si><t>B-W-M-I-C</t></si>",
"<si><t>P-X-Z-Y-N</t></si>", "<si><t>Y-J-W-N-B</t></si>", "<si><t>V-Y-U-S-B</t></si>",
"<si><t>K-W-S-Q-M</t></si>", "<si><t>I-K-X-H-S</t></si>", "<si><t>F-L-M-Q-T</t></si>",
"<si><t>S-Z-O-K-L</t></si>", "<si><t>O-P-N-G-E</t></si>", "<si><t>P-H-R-Q-T</t></si>",
"<si><t>M-L-A-D-T</t></si>", "<si><t>D-S-X-V-H</t></si>", "<si><t>F-C-O-A-B</t></si>",
"<si><t>P-I-N-O-H</t></si>", "<si><t>H-X-Y-I-C</t></si>", "<si><t>S-I-R-P-Q</t></si>",
"<si><t>P-M-F-H-Y</t></si>", "<si><t>S-R-O-T-Q</t></si>", "<si><t>X-H-O-B-R</t></si>",
"<si><t>W-P-A-Q-V</t></si>", "<si><t>E-L-Q-G-Y</t></si>", "<si><t>I-S-T-W-C</t></si>",
"<si><t>B-M-R-G-Y</t></si>", "<si><t>S-J-A-K-Q</t></si>", "<si><t>E-P-B-G-J</t></si>",
"<si><t>R-Y-E-L-D</t></si>", "<si><t>A-R-C-N-S</t></si>", "<si><t>Y-H-B-M-I</t></si>",
"<si><t>T-Q-C-K-N</t></si>", "<si><t>L-T-Z-V-C</t></si>", "<si><t>Q-L-N-J-K</t></si>",
"<si><t>T-E-J-M-Y</t></si>", "<si><t>E-M-F-R-C</t></si>", "<si><t>M-A-Y-D-I</t></si>",
"<si><t>G-M-Y-F-Q</t></si>", "<si><t>A-X-B-E-N</t></si>", "<si><t>F-Y-E-H-L</t></si>",
"<si><t>S-Z-R-M-O</t></si>", "<si><t>U-V-W-S-I</t></si>", "<si><t>D-S-E-L-K</t></si>",
"<si><t>B-C-X-V-F</t></si>", "<si><t>Q-V-L-F-H</t></si>", "<si><t>H-Z-I-J-P</t></si>",
"<si><t>W-U-O-M-D</t></si>", "<si><t>A-Y-T-O-X</t></si>", "<si><t>Y-C-Z-V-D</t></si>",
"<si><t>E-L-O-X-Y</t></si>", "<si><t>D-U-K-X-A</t></si>", "<si><t>S-W-K-N-E</t></si>",
"<si><t>D-F-T-E-Y</t></si>", "<si><t>J-T-B-C-L</t></si>", "<si><t>E-T-Z-V-F</t></si>",
"<si><t>Q-D-U-P-E</t></si>", "<si><t>M-Q-X-T-J</t></si>", "<si><t>A-M-I-K-P</t></si>",
"<si><t>J-T-B-E-R</t></si>", "<si><t>L-X-J-O-F</t></si>", "<si><t>X-B-V-W-P</t></si>",
"<si><t>Y-N-H-G-Z</t></si>", "<si><t>M-F-K-S-P</t></si>", "<si><t>K-B-V-Z-L</t></si>",
"<si><t>T-L-Y-G-A</t></si>", "<si><t>N-U-X-C-D</t></si>", "<si><t>W-B-O-X-Z</t></si>",
"<si><t>U-Y-J-F-A</t></si>", "<si><t>T-V-J-I-S</t></si>", "<si><t>T-L-W-X-Z</t></si>",
"<si><t>V-K-X-C-N</t></si>", "<si><t>G-C-I-S-Z</t></si>", "<si><t>C-T-K-S-Z</t></si>",
"<si><t>F-I-D-N-E</t></si>", "<si><t>E-C-M-Y-J</t></si>", "<si><t>N-C-Y-S-I</t></si>",
"<si><t>B-N-I-L-D</t></si>", "<si><t>Y-F-T-M-V</t></si>", "<si><t>R-A-E-O-M</t></si>",
"<si><t>M-G-P-W-X</t></si>", "<si><t>H-B-C-D-R</t></si>", "<si><t>A-J-N-C-H</t></si>",
"<si><t>R-O-F-D-N</t></si>", "<si><t>H-E-R-T-K</t></si>", "<si><t>M-U-S-V-A</t></si>",
"<si><t>L-V-F-A-H</t></si>", "<si><t>E-Q-N-Y-C</t></si>", "<si><t>T-N-L-X-S</t></si>",
"<si><t>C-F-X-A-N</t></si>", "<si><t>M-X-Y-C-Z</t></si>", "<si><t>A-N-F-B-K</t></si>",
"<si><t>J-Q-R-Z-D</t></si>", "<si><t>Q-P-Y-G-N</t></si>", "<si><t>D-Y-O-R-J</t></si>",
"<si><t>K-R-Y-N-O</t></si>", "<si><t>A-H-K-J-B</t></si>", "<si><t>O-G-J-A-S</t></si>",
"<si><t>T-N-K-X-S</t></si>", "<si><t>V-P-X-Y-F</t></si>", "<si><t>R-P-V-G-T</t></si>",
"<si><t>O-B-F-E-D</t></si>", "<si><t>Z-P-I-T-F</t></si>", "<si><t>T-S-D-X-G</t></si>",
"<si><t>Y-J-P-Z-U</t></si>", "<si><t>H-W-Y-K-J</t></si>", "<si><t>H-Z-C-F-Q</t></si>",
"<si><t>D-I-B-N-X</t></si>", "<si><t>K-B-U-H-E</t></si>", "<si><t>H-Y-U-Q-A</t></si>",
"<si><t>N-Q-G-T-I</t></si>", "<si><t>J-B-V-E-G</t></si>", "<si><t>M-F-O-E-H</t></si>",
"<si><t>B-P-K-M-I</t></si>", "<si><t>T-Z-B-Q-Y</t></si>", "<si><t>X-Y-T-P-O</t></si>",
"<si><t>E-K-I-W-C</t></si>", "<si><t>C-M-R-S-Y</t></si>", "<si><t>F-Y-M-W-L</t></si>",
"<si><t>A-S-E-U-J</t></si>", "<si><t>I-P-W-N-G</t></si>", "<si><t>V-G-R-E-T</t></si>",
"<si><t>H-O-W-G-Y</t></si>", "<si><t>O-H-B-C-P</t></si>", "<si><t>C-Y-D-Q-X</t></si>",
"<si><t>X-Y-I-Z-U</t></si>", "<si><t>R-I-Q-Y-P</t></si>", "<si><t>E-M-L-D-Y</t></si>",
"<si><t>B-G-P-Y-T</t></si>", "<si><t>Z-H-X-D-V</t></si>", "<si><t>S-B-R-J-F</t></si>",
"<si><t>O-T-X-P-W</t></si>", "<si><t>Y-C-T-M-E</t></si>", "<si><t>J-A-D-O-P</t></si>",
"<si><t>B-W-Q-D-I</t></si>", "<si><t>Y-T-X-K-Q</t></si>", "<si><t>F-D-P-X-J</t></si>",
"<si><t>Z-G-Y-O-N</t></si>", "<si><t>J-N-Z-Q-P</t></si>", "<si><t>W-C-E-I-U</t></si>",
"<si><t>L-R-K-F-H</t></si>", "<si><t>X-I-G-B-O</t></si>", "<si><t>M-C-Q-Y-Z</t></si>",
"<si><t>S-T-W-J-E</t></si>", "<si><t>G-O-N-Y-Q</t></si>", "<si><t>O-Q-R-Z-B</t></si>",
"<si><t>X-G-E-C-I</t></si>", "<si><t>P-B-D-F-Q</t></si>", "<si><t>Q-H-D-I-V</t></si>",
"<si><t>H-I-J-D-Q</t></si>", "<si><t>C-B-S-I-G</t></si>", "<si><t>M-A-F-D-B</t></si>",
"<si><t>G-Z-R-U-K</t></si>", "<si><t>N-U-L-Q-R</t></si>", "<si><t>C-A-K-M-T</t></si>",
"<si><t>F-S-R-B-K</t></si>", "<si><t>O-D-X-S-W</t></si>", "<si><t>H-J-N-P-C</t></si>",
"<si><t>N-G-Y-L-J</t></si>", "<si><t>D-X-K-O-E</t></si>", "<si><t>F-E-H-D-L</t></si>",
"<si><t>E-M-D-P-Z</t></si>", "<si><t>Q-K-I-J-V</t></si>", "<si><t>D-O-N-M-X</t></si>",
"<si><t>C-P-N-E-K</t></si>", "<si><t>L-H-T-U-P</t></si>", "<si><t>M-T-Z-P-H</t></si>",
"<si><t>B-T-L-Z-G</t></si>", "<si><t>Z-V-R-C-I</t></si>", "<si><t>J-M-R-D-G</t></si>",
"<si><t>I-V-L-Q-T</t></si>", "<si><t>O-V-X-A-M</t></si>", "<si><t>V-L-N-A-T</t></si>",
"<si><t>M-B-R-U-O</t></si>", "<si><t>O-B-Q-F-X</t></si>", "<si><t>H-O-E-K-G</t></si>",
"<si><t>S-H-G-B-D</t></si>", "<si><t>N-Z-C-L-D</t></si>", "<si><t>M-F-J-H-K</t></si>",
"<si><t>A-O-D-W-B</t></si>", "<si><t>I-X-G-K-W</t></si>", "<si><t>B-S-O-K-Q</t></si>",
"<si><t>X-T-Z-I-D</t></si>", "<si><t>N-D-G-B-L</t></si>", "<si><t>Z-O-U-I-X</t></si>",
"<si><t>W-B-A-R-H</t></si>", "<si><t>S-G-Q-J-F</t></si>", "<si><t>M-B-J-F-A</t></si>",
"<si><t>M-B-X-A-P</t></si>", "<si><t>F-M-S-Y-V</t></si>", "<si><t>T-K-B-G-C</t></si>",
"<si><t>H-V-C-G-X</t></si>", "<si><t>V-A-S-I-T</t></si>", "<si><t>Z-X-G-U-S</t></si>",
"<si><t>U-J-Y-M-H</t></si>", "<si><t>D-Y-H-X-S</t></si>", "<si><t>T-Q-X-I-E</t></si>",
"<si><t>S-V-K-M-T</t></si>", "<si><t>S-Z-P-O-Y</t></si>", "<si><t>V-Y-Q-L-F</t></si>",
"<si><t>A-E-R-V-G</t></si>", "<si><t>E-C-M-G-O</t></si>", "<si><t>T-B-U-M-V</t></si>",
"<si><t>M-R-V-A-E</t></si>", "<si><t>C-A-R-W-N</t></si>", "<si><t>Y-U-D-Z-X</t></si>",
"<si><t>Y-G-Z-C-Q</t></si>", "<si><t>T-X-R-A-D</t></si>", "<si><t>S-A-U-R-K</t></si>",
"<si><t>E-A-D-R-V</t></si>", "<si><t>P-R-T-W-F</t></si>", "<si><t>A-Z-Y-O-N</t></si>",
"<si><t>O-P-W-A-I</t></si>", "<si><t>H-V-U-R-F</t></si>", "<si><t>W-D-G-P-I</t></si>",
"<si><t>M-Z-Q-C-I</t></si>", "<si><t>Y-S-H-W-I</t></si>", "<si><t>F-J-C-N-S</t></si>",
"<si><t>H-C-Z-Y-K</t></si>", "<si><t>W-J-K-Z-I</t></si>", "<si><t>Q-T-G-C-X</t></si>",
"<si><t>S-Q-T-O-Y</t></si>", "<si><t>Z-G-T-W-X</t></si>", "<si><t>X-M-J-R-W</t></si>",
"<si><t>S-Y-N-F-H</t></si>", "<si><t>C-F-V-G-A</t></si>", "<si><t>W-R-J-I-B</t></si>",
"<si><t>I-V-B-A-M</t></si>", "<si><t>R-C-D-L-U</t></si>", "<si><t>S-T-B-A-N</t></si>",
"<si><t>F-W-J-M-A</t></si>", "<si><t>J-I-R-E-H</t></si>", "<si><t>Q-D-O-E-R</t></si>",
"<si><t>R-B-M-O-J</t></si>", "<si><t>B-X-G-V-U</t></si>", "<si><t>R-J-L-Y-M</t></si>",
"<si><t>R-F-A-X-J</t></si>", "<si><t>N-I-J-V-Q</t></si>", "<si><t>J-O-D-Q-Z</t></si>",
"<si><t>K-I-F-D-H</t></si>", "<si><t>N-H-Q-Z-M</t></si>", "<si><t>I-K-R-Z-X</t></si>",
"<si><t>O-D-U-T-I</t></si>", "<si><t>K-G-S-L-Y</t></si>", "<si><t>X-D-O-K-A</t></si>",
"<si><t>C-X-I-P-J</t></si>", "<si><t>X-A-Y-V-T</t></si>", "<si><t>I-V-T-J-O</t></si>",
"<si><t>X-D-M-H-U</t></si>", "<si><t>M-L-R-Y-J</t></si>", "<si><t>N-L-I-R-B</t></si>",
"<si><t>A-J-Z-O-Q</t></si>", "<si><t>G-Y-I-S-E</t></si>", "<si><t>N-F-X-Z-T</t></si>",
"<si><t>U-G-C-F-K</t></si>", "<si><t>R-N-W-S-M</t></si>", "<si><t>A-O-T-N-U</t></si>",
"<si><t>W-O-P-G-V</t></si>", "<si><t>D-W-E-H-O</t></si>", "<si><t>B-D-S-E-Z</t></si>",
"<si><t>C-L-V-M-I</t></si>", "<si><t>Y-N-C-W-B</t></si>", "<si><t>C-Q-L-P-W</t></si>",
"<si><t>X-H-L-B-M</t></si>", "<si><t>H-V-D-K-Q</t></si>", "<si><t>O-S-C-U-H</t></si>",
"<si><t>V-I-J-K-A</t></si>", "<si><t>D-M-B-I-F</t></si>", "<si><t>O-H-N-J-V</t></si>",
"<si><t>R-L-Q-J-Y</t></si>", "<si><t>Q-P-B-S-X</t></si>", "<si><t>J-K-V-H-F</t></si>",
"<si><t>A-T-L-Q-B</t></si>", "<si><t>E-D-S-B-G</t></si>", "<si><t>K-T-X-J-Q</t></si>",
"<si><t>W-L-U-B-H</t></si>", "<si><t>T-Y-Z-G-V</t></si>", "<si><t>G-S-C-X-P</t></si>",
"<si><t>D-C-M-Z-Y</t></si>", "<si><t>V-G-F-D-E</t></si>", "<si><t>Q-F-X-O-U</t></si>",
"<si><t>E-V-L-F-G</t></si>", "<si><t>M-T-V-U-Y</t></si>", "<si><t>Z-X-S-U-E</t></si>",
"<si><t>J-I-F-E-R</t></si>", "<si><t>C-V-J-R-W</t></si>", "<si><t>W-R-V-U-K</t></si>",
"<si><t>M-A-S-U-Q</t></si>", "<si><t>J-K-O-F-I</t></si>", "<si><t>I-Y-G-U-Z</t></si>",
"<si><t>B-Y-V-D-R</t></si>", "<si><t>M-G-Q-N-J</t></si>", "<si><t>A-F-N-K-M</t></si>",
"<si><t>R-B-D-Q-P</t></si>", "<si><t>H-T-N-U-L</t></si>", "<si><t>J-W-E-A-B</t></si>",
"<si><t>N-M-K-R-O</t></si>", "<si><t>H-Q-A-N-E</t></si>", "<si><t>U-B-Y-L-Q</t></si>",
"<si><t>J-E-N-T-Q</t></si>", "<si><t>D-N-L-R-E</t></si>", "<si><t>K-S-O-L-Z</t></si>",
"<si><t>Z-D-Y-A-N</t></si>", "<si><t>D-Q-B-X-Z</t></si>", "<si><t>J-E-F-O-Q</t></si>",
"<si><t>U-E-Q-T-R</t></si>", "<si><t>U-H-F-N-L</t></si>", "<si><t>C-T-I-V-X</t></si>",
"<si><t>V-L-Q-O-K</t></si>", "<si><t>G-Q-D-P-V</t></si>", "<si><t>D-T-V-G-S</t></si>",
"<si><t>I-G-H-Z-L</t></si>", "<si><t>A-E-I-Y-B</t></si>", "<si><t>S-V-N-B-R</t></si>",
"<si><t>M-P-J-Y-N</t></si>", "<si><t>D-T-W-Q-Z</t></si>", "<si><t>U-V-F-A-S</t></si>",
"<si><t>M-B-T-Y-Q</t></si>", "<si><t>F-I-C-D-X</t></si>", "<si><t>G-X-O-K-J</t></si>",
"<si><t>J-M-I-E-D</t></si>", "<si><t>C-B-S-F-A</t></si>", "<si><t>A-Y-O-Z-P</t></si>",
"<si><t>R-T-H-L-S</t></si>", "<si><t>P-X-B-S-O</t></si>", "<si><t>B-I-C-P-T</t></si>",
"<si><t>F-K-H-Z-N</t></si>", "<si><t>R-D-Y-T-P</t></si>", "<si><t>S-U-P-G-R</t></si>",
"<si><t>M-K-R-Q-V</t></si>", "<si><t>Z-E-O-U-T</t></si>", "<si><t>M-W-Y-X-C</t></si>",
"<si><t>Q-J-U-T-B</t></si>", "<si><t>L-H-S-J-U</t></si>", "<si><t>P-M-X-R-N</t></si>",
"<si><t>S-Y-T-G-W</t></si>", "<si><t>W-P-N-V-O</t></si>", "<si><t>E-U-I-L-M</t></si>",
"<si><t>V-S-K-J-R</t></si>", "<si><t>P-E-T-C-X</t></si>", "<si><t>E-V-C-S-Y</t></si>",
"<si><t>M-S-F-T-Q</t></si>", "<si><t>L-D-P-K-T</t></si>", "<si><t>D-Z-U-Q-P</t></si>",
"<si><t>D-H-L-W-N</t></si>", "<si><t>V-U-Q-I-A</t></si>", "<si><t>L-D-G-H-V</t></si>",
"<si><t>G-I-U-Q-E</t></si>", "<si><t>G-E-D-R-H</t></si>", "<si><t>N-T-L-K-H</t></si>",
"<si><t>J-U-K-F-V</t></si>", "<si><t>G-J-Y-K-W</t></si>", "<si><t>E-A-I-G-Q</t></si>",
"<si><t>S-U-H-R-T</t></si>", "<si><t>L-S-W-H-C</t></si>", "<si><t>P-V-I-Y-O</t></si>",
"<si><t>E-L-K-X-N</t></si>", "<si><t>Y-B-S-T-N</t></si>", "<si><t>N-U-V-E-Z</t></si>",
"<si><t>B-V-K-M-O</t></si>", "<si><t>L-V-H-A-K</t></si>", "<si><t>M-U-T-J-K</t></si>",
"<si><t>V-J-T-F-R</t></si>", "<si><t>T-Y-E-U-W</t></si>", "<si><t>C-D-B-A-L</t></si>",
"<si><t>K-E-U-S-A</t></si>", "<si><t>D-H-R-X-Z</t></si>", "<si><t>M-B-Z-G-C</t></si>",
"<si><t>P-E-T-S-Y</t></si>", "<si><t>M-G-O-J-F</t></si>", "<si><t>C-Y-E-P-X</t></si>",
"<si><t>R-V-D-C-N</t></si>", "<si><t>S-Y-A-K-Z</t></si>", "<si><t>K-S-G-T-D</t></si>",
"<si><t>D-F-G-U-K</t></si>", "<si><t>F-B-P-T-M</t></si>", "<si><t>P-G-O-D-W</t></si>",
"<si><t>U-L-I-R-J</t></si>", "<si><t>F-Q-N-X-J</t></si>", "<si><t>D-Q-F-V-B</t></si>",
"<si><t>R-P-E-Z-H</t></si>", "<si><t>A-H-X-M-L</t></si>", "<si><t>I-H-F-G-W</t></si>",
"<si><t>V-C-M-H-Y</t></si>", "<si><t>V-H-L-Y-F</t></si>", "<si><t>H-I-L-P-V</t></si>",
"<si><t>L-Q-W-K-A</t></si>", "<si><t>D-W-J-R-L</t></si>", "<si><t>W-E-V-J-L</t></si>",
"<si><t>F-Z-X-U-H</t></si>", "<si><t>K-U-Q-I-R</t></si>", "<si><t>S-D-N-E-V</t></si>",
"<si><t>G-T-E-L-Y</t></si>", "<si><t>S-P-E-B-D</t></si>", "<si><t>U-N-L-S-O</t></si>",
"<si><t>Z-G-W-I-X</t></si>", "<si><t>M-C-X-S-E</t></si>", "<si><t>P-C-S-X-Y</t></si>",
"<si><t>B-Z-K-R-H</t></si>", "<si><t>D-J-W-Y-U</t></si>", "<si><t>J-O-Q-F-P</t></si>",
"<si><t>I-A-V-G-Y</t></si>", "<si><t>U-B-V-G-N</t></si>", "<si><t>W-H-Q-M-E</t></si>",
"<si><t>J-R-O-D-F</t></si>", "<si><t>W-M-C-O-P</t></si>", "<si><t>R-I-F-M-Q</t></si>",
"<si><t>Q-L-D-W-X</t></si>", "<si><t>M-A-Q-P-F</t></si>", "<si><t>O-J-T-L-A</t></si>",
"<si><t>X-S-I-P-G</t></si>", "<si><t>G-W-D-Y-F</t></si>", "<si><t>T-B-M-N-J</t></si>",
"<si><t>Q-W-N-Z-C</t></si>", "<si><t>M-F-C-O-H</t></si>", "<si><t>Z-N-Q-X-P</t></si>",
"<si><t>Q-G-A-Y-C</t></si>", "<si><t>R-F-G-P-E</t></si>", "<si><t>X-J-F-R-C</t></si>",
"<si><t>J-S-Q-E-L</t></si>", "<si><t>O-K-P-F-D</t></si>", "<si><t>R-J-W-G-T</t></si>",
"<si><t>Y-P-J-N-D</t></si>", "<si><t>N-S-F-Y-T</t></si>", "<si><t>M-L-N-H-U</t></si>",
"<si><t>V-A-H-G-Q</t></si>", "<si><t>H-L-W-K-P</t></si>", "<si><t>U-P-G-V-O</t></si>",
"<si><t>V-N-P-I-Y</t></si>", "<si><t>A-O-E-F-L</t></si>", "<si><t>W-F-Q-J-G</t></si>",
"<si><t>B-A-L-V-Q</t></si>", "<si><t>Y-J-F-V-S</t></si>", "<si><t>O-F-E-J-A</t></si>",
"<si><t>X-O-F-M-B</t></si>", "<si><t>B-M-L-H-W</t></si>", "<si><t>Z-X-F-T-B</t></si>",
"<si><t>W-X-E-M-A</t></si>", "<si><t>F-J-V-W-L</t></si>", "<si><t>P-C-U-R-O</t></si>",
"<si><t>S-K-F-D-V</t></si>", "<si><t>K-F-Z-Q-C</t></si>", "<si><t>J-S-R-M-Q</t></si>",
"<si><t>E-H-L-Q-N</t></si>", "<si><t>W-F-M-E-X</t></si>", "<si><t>P-R-E-N-A</t></si>",
"<si><t>D-F-G-N-Y</t></si>", "<si><t>I-S-O-V-T</t></si>", "<si><t>R-I-C-N-L</t></si>",
"<si><t>I-T-C-Y-P</t></si>", "<si><t>R-W-I-K-X</t></si>", "<si><t>P-B-J-X-G</t></si>",
"<si><t>D-W-F-N-E</t></si>", "<si><t>M-G-C-B-K</t></si>", "<si><t>E-T-H-F-W</t></si>",
"<si><t>A-E-L-F-Z</t></si>", "<si><t>Z-V-W-S-R</t></si>", "<si><t>O-T-L-D-Q</t></si>",
"<si><t>S-E-M-Z-O</t></si>", "<si><t>N-R-Y-A-U</t></si>", "<si><t>Y-D-M-A-R</t></si>",
"<si><t>S-M-P-N-K</t></si>", "<si><t>C-T-B-L-Z</t></si>", "<si><t>X-A-L-I-V</t></si>",
"<si><t>B-V-M-G-S</t></si>", "<si><t>N-R-K-Q-D</t></si>", "<si><t>F-O-L-X-Y</t></si>",
"<si><t>Y-T-F-A-S</t></si>", "<si><t>X-G-O-U-A</t></si>", "<si><t>Z-F-I-B-T</t></si>",
"<si><t>V-H-B-N-W</t></si>", "<si><t>V-K-B-W-S</t></si>", "<si><t>V-C-T-L-G</t></si>",
"<si><t>X-N-L-Y-Q</t></si>", "<si><t>N-D-L-I-Z</t></si>", "<si><t>L-K-G-N-E</t></si>",
"<si><t>D-L-M-K-Z</t></si>", "<si><t>E-I-P-Z-U</t></si>", "<si><t>H-X-B-C-D</t></si>",
"<si><t>B-H-D-C-V</t></si>", "<si><t>F-O-L-D-R</t></si>", "<si><t>B-Z-J-Y-V</t></si>",
"<si><t>E-C-R-B-S</t></si>", "<si><t>E-X-V-B-S</t></si>", "<si><t>P-K-I-W-G</t></si>",
"<si><t>A-I-F-V-O</t></si>", "<si><t>D-F-R-I-E</t></si>", "<si><t>X-L-I-N-O</t></si>",
"<si><t>P-Y-Q-C-S</t></si>", "<si><t>C-P-A-X-L</t></si>", "<si><t>W-O-U-A-X</t></si>",
"<si><t>H-M-R-E-B</t></si>", "<si><t>K-Y-P-G-A</t></si>", "<si><t>O-E-V-D-C</t></si>",
"<si><t>Z-A-K-M-W</t></si>", "<si><t>S-F-M-Z-E</t></si>", "<si><t>X-U-I-C-J</t></si>",
"<si><t>C-V-T-B-N</t></si>", "<si><t>Z-Q-Y-V-G</t></si>", "<si><t>T-W-G-Q-D</t></si>",
"<si><t>K-Y-L-R-F</t></si>", "<si><t>W-O-S-E-A</t></si>", "<si><t>V-T-Q-F-G</t></si>",
"<si><t>G-V-J-M-U</t></si>", "<si><t>P-R-A-N-C</t></si>", "<si><t>I-R-A-F-T</t></si>",
"<si><t>X-Z-U-W-N</t></si>", "<si><t>A-G-R-D-Y</t></si>", "<si><t>J-U-T-A-Q</t></si>",
"<si><t>K-Y-T-H-U</t></si>", "<si><t>P-Q-L-Z-G</t></si>", "<si><t>N-K-Y-X-W</t></si>",
"<si><t>A-T-M-R-Z</t></si>", "<si><t>M-B-P-C-L</t></si>", "<si><t>M-Q-K-N-R</t></si>",
"<si><t>I-W-H-G-R</t></si>", "<si><t>I-F-D-Q-A</t></si>", "<si><t>V-G-F-C-X</t></si>",
"<si><t>H-Q-F-D-T</t></si>", "<si><t>N-R-T-Q-G</t></si>", "<si><t>X-V-P-B-G</t></si>",
"<si><t>V-H-B-N-X</t></si>", "<si><t>G-Q-T-J-Y</t></si>", "<si><t>P-F-A-N-H</t></si>",
"<si><t>C-D-I-W-K</t></si>", "<si><t>T-R-J-B-P</t></si>", "<si><t>E-P-X-L-S</t></si>",
"<si><t>O-K-B-L-M</t></si>", "<si><t>Z-T-B-R-V</t></si>", "<si><t>V-N-Y-Z-U</t></si>",
"<si><t>E-W-V-F-O</t></si>", "<si><t>D-S-A-Z-J</t></si>", "<si><t>R-O-W-A-Y</t></si>",
"<si><t>V-L-K-J-Q</t></si>", "<si><t>Q-T-J-S-Z</t></si>", "<si><t>M-G-L-Y-D</t></si>",
"<si><t>G-U-W-I-C</t></si>", "<si><t>G-O-D-T-I</t></si>", "<si><t>R-L-Z-P-V</t></si>",
"<si><t>W-G-M-T-I</t></si>", "<si><t>S-F-H-Z-J</t></si>", "<si><t>Z-L-O-V-N</t></si>",
"<si><t>G-D-A-U-H</t></si>", "<si><t>Y-K-V-R-E</t></si>", "<si><t>Y-O-L-R-I</t></si>",
"<si><t>X-V-Z-I-B</t></si>", "<si><t>N-Z-S-D-O</t></si>", "<si><t>N-X-Z-J-M</t></si>",
"<si><t>S-X-A-H-C</t></si>", "<si><t>V-T-R-F-H</t></si>", "<si><t>K-E-Q-B-J</t></si>",
"<si><t>V-R-J-U-G</t></si>", "<si><t>Q-K-B-P-Z</t></si>", "<si><t>Y-I-S-X-K</t></si>",
"<si><t>U-O-R-Q-J</t></si>", "<si><t>Q-T-X-F-D</t></si>", "<si><t>P-O-F-B-J</t></si>",
"<si><t>C-M-K-L-F</t></si>", "<si><t>N-W-Y-A-V</t></si>", "<si><t>E-H-I-G-U</t></si>",
"<si><t>L-J-X-A-C</t></si>", "<si><t>Q-K-U-D-B</t></si>", "<si><t>A-S-R-D-T</t></si>",
"<si><t>S-Z-E-Y-U</t></si>", "<si><t>A-K-R-S-G</t></si>", "<si><t>S-F-R-J-Q</t></si>",
"<si><t>A-Y-J-F-U</t></si>", "<si><t>L-I-J-R-H</t></si>", "<si><t>K-C-V-Q-F</t></si>",
"<si><t>H-U-A-T-D</t></si>", "<si><t>E-W-L-I-C</t></si>", "<si><t>Y-P-R-F-V</t></si>",
"<si><t>L-M-P-Z-U</t></si>", "<si><t>T-Q-U-P-V</t></si>", "<si><t>Q-W-T-M-K</t></si>",
"<si><t>P-D-G-Y-K</t></si>", "<si><t>F-I-K-C-P</t></si>", "<si><t>I-T-Y-K-L</t></si>",
"<si><t>H-T-K-I-R</t></si>", "<si><t>H-K-B-M-F</t></si>", "<si><t>J-P-D-Z-Q</t></si>",
"<si><t>D-M-K-C-V</t></si>", "<si><t>E-K-Y-F-R</t></si>", "<si><t>P-L-H-A-J</t></si>",
"<si><t>R-C-Z-V-T</t></si>", "<si><t>I-W-G-A-T</t></si>", "<si><t>Y-N-X-K-R</t></si>",
"<si><t>M-N-E-C-Q</t></si>", "<si><t>J-B-W-R-X</t></si>", "<si><t>R-M-D-T-F</t></si>",
"<si><t>R-V-L-Y-G</t></si>", "<si><t>M-V-E-Z-Q</t></si>", "<si><t>S-H-Q-X-G</t></si>",
"<si><t>H-P-Y-Q-G</t></si>", "<si><t>F-N-K-T-W</t></si>", "<si><t>I-B-Z-P-F</t></si>",
"<si><t>G-P-N-S-F</t></si>", "<si><t>B-Y-S-N-A</t></si>", "<si><t>P-I-Z-A-S</t></si>",
"<si><t>X-I-K-B-Y</t></si>", "<si><t>B-Q-F-W-M</t></si>", "<si><t>Y-E-J-P-M</t></si>",
"<si><t>V-E-T-G-O</t></si>", "<si><t>M-N-L-K-I</t></si>", "<si><t>N-D-W-B-V</t></si>",
"<si><t>F-P-S-M-X</t></si>", "<si><t>K-H-Q-M-F</t></si>", "<si><t>Z-B-O-I-L</t></si>",
"<si><t>L-F-D-S-E</t></si>", "<si><t>W-Y-P-B-A</t></si>", "<si><t>L-P-S-V-U</t></si>",
"<si><t>D-G-L-J-P</t></si>", "<si><t>K-U-F-Y-E</t></si>", "<si><t>J-G-R-M-N</t></si>",
"<si><t>J-U-P-H-O</t></si>", "<si><t>O-U-N-M-W</t></si>", "<si><t>X-V-J-K-E</t></si>",
"<si><t>C-W-G-L-K</t></si>", "<si><t>D-H-A-O-K</t></si>", "<si><t>H-G-C-X-P</t></si>",
"<si><t>B-C-I-J-D</t></si>", "<si><t>N-L-T-D-S</t></si>", "<si><t>X-D-C-A-T</t></si>",
"<si><t>Z-D-U-N-E</t></si>", "<si><t>P-W-A-I-L</t></si>", "<si><t>N-U-G-H-C</t></si>",
"<si><t>F-Q-E-V-T</t></si>", "<si><t>X-O-M-S-U</t></si>", "<si><t>Z-V-S-Q-R</t></si>",
"<si><t>K-Z-U-D-L</t></si>", "<si><t>A-O-Z-C-T</t></si>", "<si><t>S-K-U-T-Q</t></si>",
"<si><t>V-Q-I-B-Z</t></si>", "<si><t>A-K-Z-N-Y</t></si>", "<si><t>T-G-V-Y-O</t></si>",
"<si><t>G-K-R-A-J</t></si>", "<si><t>Y-J-F-T-U</t></si>", "<si><t>E-P-K-G-F</t></si>",
"<si><t>U-P-X-L-V</t></si>", "<si><t>H-C-S-M-I</t></si>", "<si><t>K-D-X-W-N</t></si>",
"<si><t>F-E-P-V-R</t></si>", "<si><t>C-P-V-W-L</t></si>", "<si><t>I-S-M-E-B</t></si>",
"<si><t>D-E-L-C-O</t></si>", "<si><t>A-D-V-U-W</t></si>", "<si><t>D-I-N-M-Z</t></si>",
"<si><t>O-Z-K-S-N</t></si>", "<si><t>F-J-W-L-S</t></si>", "<si><t>H-C-V-W-I</t></si>",
"<si><t>B-A-L-V-Y</t></si>", "<si><t>N-K-Z-W-X</t></si>", "<si><t>Z-C-X-K-A</t></si>",
"<si><t>S-X-H-G-Y</t></si>", "<si><t>L-G-M-V-Q</t></si>", "<si><t>Z-L-G-Y-Q</t></si>",
"<si><t>J-W-E-A-D</t></si>", "<si><t>G-S-A-M-U</t></si>", "<si><t>F-M-D-K-O</t></si>",
"<si><t>B-O-G-R-K</t></si>", "<si><t>V-S-U-Q-B</t></si>", "<si><t>R-X-O-N-F</t></si>",
"<si><t>Y-N-M-H-I</t></si>", "<si><t>T-J-W-Q-L</t></si>", "<si><t>R-W-P-B-H</t></si>",
"<si><t>D-A-I-P-E</t></si>", "<si><t>D-P-Q-T-N</t></si>", "<si><t>Y-K-Q-U-X</t></si>",
"<si><t>A-Y-M-C-R</t></si>", "<si><t>M-O-I-L-B</t></si>", "<si><t>Y-O-K-J-F</t></si>",
"<si><t>O-C-J-X-H</t></si>", "<si><t>W-J-X-L-Z</t></si>", "<si><t>F-P-H-A-L</t></si>",
"<si><t>M-T-F-U-P</t></si>", "<si><t>W-H-F-C-X</t></si>", "<si><t>R-C-D-Z-L</t></si>",
"<si><t>Y-B-A-I-L</t></si>", "<si><t>S-I-Y-W-P</t></si>", "<si><t>K-D-X-G-Z</t></si>",
"<si><t>O-W-Q-M-G</t></si>", "<si><t>M-T-V-L-G</t></si>", "<si><t>F-Z-Y-J-L</t></si>",
"<si><t>V-L-A-S-N</t></si>", "<si><t>I-P-A-S-N</t></si>", "<si><t>G-T-Q-D-F</t></si>",
"<si><t>G-R-L-W-V</t></si>", "<si><t>I-R-Z-V-P</t></si>", "<si><t>M-L-B-A-I</t></si>",
"<si><t>D-K-Z-F-M</t></si>", "<si><t>M-O-G-X-V</t></si>", "<si><t>Y-V-D-Z-W</t></si>",
"<si><t>M-S-O-G-T</t></si>", "<si><t>Z-F-M-U-X</t></si>", "<si><t>V-N-Z-P-I</t></si>",
"<si><t>N-D-F-U-J</t></si>", "<si><t>G-O-U-E-S</t></si>", "<si><t>Z-C-G-W-B</t></si>",
"<si><t>O-T-E-N-V</t></si>", "<si><t>W-P-H-C-V</t></si>", "<si><t>X-R-D-P-G</t></si>",
"<si><t>Y-C-E-F-T</t></si>", "<si><t>V-O-G-K-I</t></si>", "<si><t>S-I-W-M-L</t></si>",
"<si><t>M-H-C-O-A</t></si>", "<si><t>Q-C-N-Z-D</t></si>", "<si><t>A-N-L-S-T</t></si>",
"<si><t>X-W-I-L-K</t></si>", "<si><t>A-Y-V-S-K</t></si>", "<si><t>D-W-F-L-K</t></si>",
"<si><t>U-Z-I-R-Q</t></si>", "<si><t>V-W-B-A-T</t></si>", "<si><t>I-U-R-E-W</t></si>",
"<si><t>N-W-U-Q-O</t></si>", "<si><t>F-H-L-N-O</t></si>", "<si><t>D-I-T-J-H</t></si>",
"<si><t>W-K-Q-D-T</t></si>", "<si><t>A-O-R-I-U</t></si>", "<si><t>M-E-V-A-F</t></si>",
"<si><t>U-J-M-X-S</t></si>", "<si><t>O-E-R-K-H</t></si>", "<si><t>A-V-Z-T-D</t></si>",
"<si><t>C-Z-B-D-L</t></si>", "<si><t>D-J-T-Q-G</t></si>", "<si><t>A-O-C-I-Z</t></si>",
"<si><t>J-L-A-Y-C</t></si>", "<si><t>P-O-H-E-V</t></si>", "<si><t>A-M-Z-I-R</t></si>",
"<si><t>W-C-R-H-V</t></si>", "<si><t>Z-G-I-V-N</t></si>", "<si><t>K-M-W-T-Q</t></si>",
"<si><t>O-I-F-D-N</t></si>", "<si><t>X-D-A-V-T</t></si>", "<si><t>T-S-M-B-D</t></si>",
"<si><t>F-C-D-U-Q</t></si>", "<si><t>B-H-M-Q-G</t></si>", "<si><t>M-K-I-W-B</t></si>",
"<si><t>R-M-Q-W-P</t></si>", "<si><t>N-Z-L-F-G</t></si>", "<si><t>I-P-J-B-W</t></si>",
"<si><t>O-Y-W-U-V</t></si>", "<si><t>C-V-Z-B-O</t></si>", "<si><t>O-Q-S-F-X</t></si>",
"<si><t>B-G-F-M-W</t></si>", "<si><t>N-X-R-P-S</t></si>", "<si><t>L-T-A-H-R</t></si>",
"<si><t>G-O-E-L-X</t></si>", "<si><t>R-I-U-X-Y</t></si>", "<si><t>Q-O-Z-F-V</t></si>",
"<si><t>O-P-J-C-M</t></si>", "<si><t>D-W-G-S-L</t></si>", "<si><t>T-K-W-L-O</t></si>",
"<si><t>E-I-O-K-D</t></si>", "<si><t>K-E-A-I-S</t></si>", "<si><t>M-I-W-F-K</t></si>",
"<si><t>S-W-G-T-N</t></si>", "<si><t>P-L-J-D-A</t></si>", "<si><t>O-M-T-J-P</t></si>",
"<si><t>C-R-Z-L-G</t></si>", "<si><t>F-S-D-V-K</t></si>", "<si><t>N-J-H-V-I</t></si>",
"<si><t>D-I-A-F-J</t></si>", "<si><t>U-R-T-V-X</t></si>", "<si><t>J-N-T-R-S</t></si>",
"<si><t>K-V-Z-T-Q</t></si>", "<si><t>J-L-C-R-M</t></si>", "<si><t>Z-A-R-L-E</t></si>",
"<si><t>Y-L-W-I-S</t></si>", "<si><t>B-W-E-N-U</t></si>", "<si><t>B-S-W-J-F</t></si>",
"<si><t>D-G-I-P-S</t></si>", "<si><t>D-Q-M-E-R</t></si>", "<si><t>K-T-R-A-D</t></si>",
"<si><t>P-Q-L-E-U</t></si>", "<si><t>U-D-W-A-O</t></si>", "<si><t>Q-R-P-D-Y</t></si>",
"<si><t>C-X-V-S-I</t></si>", "<si><t>F-E-U-I-K</t></si>", "<si><t>H-Z-T-L-P</t></si>",
"<si><t>P-I-U-B-O</t></si>", "<si><t>S-Q-G-W-K</t></si>", "<si><t>K-V-S-U-L</t></si>",
"<si><t>F-N-Q-O-P</t></si>", "<si><t>M-Q-F-C-L</t></si>", "<si><t>V-X-G-C-A</t></si>",
"<si><t>N-S-E-C-V</t></si>", "<si><t>R-K-J-A-X</t></si>", "<si><t>D-L-H-W-S</t></si>",
"<si><t>Z-C-Y-L-G</t></si>", "<si><t>M-D-W-F-U</t></si>", "<si><t>R-A-U-S-F</t></si>",
"<si><t>Y-W-H-V-Q</t></si>", "<si><t>B-K-G-J-W</t></si>", "<si><t>B-V-H-E-C</t></si>",
"<si><t>D-J-X-S-H</t></si>", "<si><t>W-C-H-Z-Q</t></si>", "<si><t>X-B-A-I-U</t></si>",
"<si><t>D-A-J-C-F</t></si>", "<si><t>B-P-U-S-W</t></si>", "<si><t>A-D-R-Z-K</t></si>",
"<si><t>S-H-P-A-Z</t></si>", "<si><t>J-O-U-P-S</t></si>", "<si><t>W-C-H-P-T</t></si>",
"<si><t>C-U-Z-O-W</t></si>", "<si><t>P-E-H-M-S</t></si>", "<si><t>B-W-L-Y-N</t></si>",
"<si><t>N-S-F-R-Y</t></si>", "<si><t>W-R-K-A-N</t></si>", "<si><t>G-X-V-D-E</t></si>",
"<si><t>I-G-D-P-T</t></si>", "<si><t>W-N-J-R-L</t></si>", "<si><t>P-Q-H-A-V</t></si>",
"<si><t>U-Q-R-P-W</t></si>", "<si><t>I-H-Q-X-U</t></si>", "<si><t>W-K-R-M-N</t></si>",
"<si><t>U-H-Q-B-Y</t></si>", "<si><t>X-P-D-V-W</t></si>", "<si><t>E-K-F-R-C</t></si>",
"<si><t>T-E-B-N-L</t></si>", "<si><t>I-S-K-Q-H</t></si>", "<si><t>Y-Z-V-Q-L</t></si>",
"<si><t>W-L-U-P-I</t></si>", "<si><t>Y-P-F-H-O</t></si>", "<si><t>M-C-Y-T-I</t></si>",
"<si><t>Q-A-V-Z-O</t></si>", "<si><t>I-H-U-K-F</t></si>", "<si><t>Q-Z-C-W-Y</t></si>",
"<si><t>U-M-Q-C-R</t></si>", "<si><t>U-H-S-M-W</t></si>", "<si><t>R-C-M-Y-G</t></si>",
"<si><t>R-C-J-A-V</t></si>", "<si><t>X-B-Z-C-Y</t></si>", "<si><t>P-C-O-J-I</t></si>",
"<si><t>E-C-O-W-R</t></si>", "<si><t>E-T-Y-X-F</t></si>", "<si><t>Q-M-C-K-S</t></si>",
"<si><t>H-I-O-J-K</t></si>", "<si><t>R-P-N-J-V</t></si>", "<si><t>H-Y-P-N-V</t></si>",
"<si><t>R-J-I-L-S</t></si>", "<si><t>N-K-T-Z-O</t></si>", "<si><t>H-B-K-A-P</t></si>",
"<si><t>P-G-J-A-B</t></si>", "<si><t>L-S-O-I-Y</t></si>", "<si><t>L-U-R-Z-D</t></si>",
"<si><t>F-I-K-Q-B</t></si>", "<si><t>Q-K-X-B-M</t></si>", "<si><t>A-C-L-B-I</t></si>",
"<si><t>J-E-O-D-K</t></si>", "<si><t>Y-W-V-G-D</t></si>", "<si><t>S-N-T-H-Q</t></si>",
"<si><t>K-M-D-R-H</t></si>", "<si><t>B-U-N-A-T</t></si>", "<si><t>A-J-F-O-C</t></si>",
"<si><t>J-L-V-R-D</t></si>", "<si><t>X-A-Q-J-R</t></si>", "<si><t>I-V-E-W-Z</t></si>",
"<si><t>Q-G-K-P-X</t></si>", "<si><t>O-H-K-J-D</t></si>", "<si><t>N-K-I-J-B</t></si>",
"<si><t>Y-R-N-G-C</t></si>", "<si><t>K-L-E-B-S</t></si>", "<si><t>O-P-T-D-G</t></si>",
"<si><t>O-R-E-J-V</t></si>", "<si><t>X-V-B-Z-U</t></si>", "<si><t>Y-H-I-O-C</t></si>",
"<si><t>B-O-Y-M-P</t></si>", "<si><t>J-Z-R-Q-P</t></si>", "<si><t>A-E-K-M-D</t></si>",
"<si><t>D-X-L-F-U</t></si>", "<si><t>J-X-U-A-Z</t></si>", "<si><t>Y-R-G-X-Q</t></si>",
"<si><t>Y-R-P-W-C</t></si>", "<si><t>K-Q-C-Y-L</t></si>", "<si><t>K-H-L-V-U</t></si>",
"<si><t>P-A-N-I-C</t></si>", "<si><t>M-D-Y-F-A</t></si>", "<si><t>H-V-D-F-U</t></si>",
"<si><t>Z-D-P-U-J</t></si>", "<si><t>O-E-I-Z-Q</t></si>", "<si><t>L-Q-A-O-I</t></si>",
"<si><t>L-V-C-K-N</t></si>", "<si><t>E-Z-R-Q-K</t></si>", "<si><t>N-T-V-U-D</t></si>",
"<si><t>U-B-O-H-Z</t></si>", "<si><t>F-X-D-H-U</t></si>", "<si><t>T-W-R-O-G</t></si>",
"<si><t>G-A-O-Z-L</t></si>", "<si><t>Z-C-B-G-P</t></si>", "<si><t>O-I-B-S-N</t></si>",
"<si><t>Z-R-I-O-Y</t></si>", "<si><t>K-B-L-C-Z</t></si>", "<si><t>Z-B-T-F-D</t></si>",
"<si><t>B-H-P-J-C</t></si>", "<si><t>A-T-L-N-M</t></si>", "<si><t>O-P-W-M-S</t></si>",
"<si><t>Q-I-L-G-J</t></si>", "<si><t>O-D-Q-J-M</t></si>", "<si><t>P-B-F-Z-V</t></si>",
"<si><t>Q-H-J-I-C</t></si>", "<si><t>K-V-W-Z-D</t></si>", "<si><t>Y-A-R-Z-Q</t></si>",
"<si><t>M-U-H-Q-N</t></si>", "<si><t>O-D-K-J-Z</t></si>", "<si><t>I-C-Z-J-H</t></si>",
"<si><t>E-K-R-G-M</t></si>", "<si><t>D-B-G-Y-K</t></si>", "<si><t>U-Q-B-C-L</t></si>",
"<si><t>Y-Q-M-W-L</t></si>", "<si><t>A-Z-J-B-S</t></si>", "<si><t>C-W-K-O-X</t></si>",
"<si><t>G-E-V-B-R</t></si>", "<si><t>L-N-Q-T-H</t></si>", "<si><t>H-E-X-A-J</t></si>",
"<si><t>U-O-Z-S-B</t></si>", "<si><t>P-G-W-K-D</t></si>", "<si><t>J-W-L-C-A</t></si>",
"<si><t>L-C-E-V-Z</t></si>", "<si><t>T-K-Y-Q-P</t></si>", "<si><t>Z-J-Q-U-V</t></si>",
"<si><t>V-C-P-K-X</t></si>", "<si><t>U-X-A-H-E</t></si>", "<si><t>I-J-E-Z-W</t></si>",
"<si><t>O-M-W-F-S</t></si>", "<si><t>N-K-Y-P-M</t></si>", "<si><t>C-G-K-L-R</t></si>",
"<si><t>M-T-V-A-E</t></si>", "<si><t>D-V-H-Q-F</t></si>", "<si><t>M-N-P-W-L</t></si>",
"<si><t>G-E-F-T-M</t></si>", "<si><t>G-X-D-Q-O</t></si>", "<si><t>X-G-W-E-Z</t></si>",
"<si><t>U-C-B-P-Z</t></si>", "<si><t>F-K-Z-W-H</t></si>", "<si><t>P-C-D-F-L</t></si>",
"<si><t>N-V-G-R-T</t></si>", "<si><t>I-N-B-J-T</t></si>", "<si><t>B-T-A-M-L</t></si>",
"<si><t>Q-D-N-Y-I</t></si>", "<si><t>B-I-K-X-A</t></si>", "<si><t>C-U-F-S-K</t></si>",
"<si><t>W-X-G-P-L</t></si>", "<si><t>H-A-P-L-C</t></si>", "<si><t>W-T-K-P-F</t></si>",
"<si><t>G-B-U-T-K</t></si>", "<si><t>U-S-Q-Y-Z</t></si>", "<si><t>G-C-E-Z-W</t></si>",
"<si><t>Z-Y-Q-B-M</t></si>", "<si><t>D-Y-N-C-E</t></si>", "<si><t>E-J-Q-K-I</t></si>",
"<si><t>P-R-O-B-V</t></si>", "<si><t>D-E-A-S-U</t></si>", "<si><t>I-A-M-E-L</t></si>",
"<si><t>M-K-U-F-Y</t></si>", "<si><t>L-Q-H-S-O</t></si>", "<si><t>Z-F-V-T-P</t></si>",
"<si><t>V-N-M-R-J</t></si>", "<si><t>Q-E-P-K-O</t></si>", "<si><t>O-H-J-U-K</t></si>",
"<si><t>U-Z-Q-O-F</t></si>", "<si><t>R-X-K-O-C</t></si>", "<si><t>L-R-K-C-G</t></si>",
"<si><t>V-F-B-S-K</t></si>", "<si><t>L-Z-O-H-E</t></si>", "<si><t>D-S-Y-V-K</t></si>",
"<si><t>R-J-V-A-C</t></si>", "<si><t>P-L-B-Q-Z</t></si>", "<si><t>U-Q-Z-X-Y</t></si>",
"<si><t>E-P-L-F-T</t></si>", "<si><t>Z-F-C-G-B</t></si>", "<si><t>W-V-C-A-J</t></si>",
"<si><t>O-N-C-Y-H</t></si>", "<si><t>B-Y-C-D-Z</t></si>", "<si><t>E-X-G-H-Z</t></si>",
"<si><t>Y-H-X-J-I</t></si>", "<si><t>O-K-P-J-D</t></si>", "<si><t>G-E-K-T-B</t></si>",
"<si><t>G-A-K-Y-P</t></si>", "<si><t>T-V-X-P-H</t></si>", "<si><t>W-Y-D-K-V</t></si>",
"<si><t>Z-W-B-P-Q</t></si>", "<si><t>A-J-F-U-P</t></si>", "<si><t>V-A-X-E-Z</t></si>",
"<si><t>F-T-J-E-I</t></si>", "<si><t>V-M-L-Z-U</t></si>", "<si><t>H-I-B-L-Q</t></si>",
"<si><t>C-D-V-K-M</t></si>", "<si><t>G-Z-F-J-R</t></si>", "<si><t>C-T-N-U-H</t></si>",
"<si><t>W-Y-U-X-M</t></si>", "<si><t>T-F-I-W-V</t></si>", "<si><t>X-O-P-Y-W</t></si>",
"<si><t>L-Z-P-B-K</t></si>", "<si><t>A-E-T-Q-K</t></si>", "<si><t>K-P-C-T-Z</t></si>",
"<si><t>C-A-H-G-E</t></si>", "<si><t>B-W-G-D-V</t></si>", "<si><t>A-S-D-B-I</t></si>",
"<si><t>T-D-G-C-P</t></si>", "<si><t>J-B-F-T-K</t></si>", "<si><t>V-R-L-U-F</t></si>",
"<si><t>O-P-Q-X-M</t></si>", "<si><t>K-M-T-E-D</t></si>", "<si><t>R-B-H-X-G</t></si>",
"<si><t>L-C-O-Y-B</t></si>", "<si><t>R-Z-U-E-I</t></si>", "<si><t>K-I-W-O-G</t></si>",
"<si><t>Z-X-W-F-K</t></si>", "<si><t>Y-C-B-S-V</t></si>", "<si><t>L-M-R-N-Z</t></si>",
"<si><t>B-Q-M-Z-K</t></si>", "<si><t>P-S-Z-O-T</t></si>", "<si><t>Y-A-Z-N-R</t></si>",
"<si><t>L-O-A-P-J</t></si>", "<si><t>O-Z-Y-M-P</t></si>", "<si><t>C-P-S-J-Q</t></si>",
"<si><t>Y-F-Q-A-R</t></si>", "<si><t>U-Z-K-B-X</t></si>", "<si><t>Q-R-T-H-X</t></si>",
"<si><t>N-U-E-Q-A</t></si>", "<si><t>X-Z-R-J-C</t></si>", "<si><t>U-X-E-A-Z</t></si>",
"<si><t>Y-M-O-A-V</t></si>", "<si><t>N-K-D-W-M</t></si>", "<si><t>V-Q-E-F-S</t></si>",
"<si><t>L-U-A-Z-D</t></si>", "<si><t>X-S-R-P-E</t></si>", "<si><t>I-B-O-Z-L</t></si>",
"<si><t>J-G-K-H-Z</t></si>", "<si><t>T-P-O-Z-S</t></si>", "<si><t>L-I-R-G-N</t></si>",
"<si><t>Y-C-O-Z-A</t></si>", "<si><t>H-B-D-Q-R</t></si>", "<si><t>C-L-J-E-T</t></si>",
"<si><t>K-Z-N-U-X</t></si>", "<si><t>P-F-S-Z-H</t></si>", "<si><t>S-N-D-R-T</t></si>",
"<si><t>V-R-S-T-G</t></si>", "<si><t>N-S-F-U-Y</t></si>", "<si><t>D-P-L-C-A</t></si>",
"<si><t>B-X-V-M-S</t></si>", "<si><t>B-M-Z-E-Q</t></si>", "<si><t>K-Y-S-P-B</t></si>",
"<si><t>K-T-V-F-G</t></si>", "<si><t>U-Z-B-W-E</t></si>", "<si><t>J-X-O-C-Y</t></si>",
"<si><t>X-C-Q-P-D</t></si>", "<si><t>X-L-Y-J-Z</t></si>", "<si><t>Y-F-O-N-H</t></si>",
"<si><t>M-J-B-Z-X</t></si>", "<si><t>G-X-R-A-D</t></si>", "<si><t>E-I-L-O-A</t></si>",
"<si><t>B-R-C-I-K</t></si>", "<si><t>K-W-F-N-P</t></si>", "<si><t>C-Y-R-A-H</t></si>",
"<si><t>J-H-D-N-C</t></si>", "<si><t>P-Y-C-I-D</t></si>", "<si><t>P-D-C-U-E</t></si>",
"<si><t>H-A-I-E-P</t></si>", "<si><t>B-N-E-H-S</t></si>", "<si><t>C-Y-P-E-F</t></si>",
"<si><t>K-F-X-B-S</t></si>", "<si><t>M-Q-D-I-Z</t></si>", "<si><t>V-S-P-K-O</t></si>",
"<si><t>L-W-M-T-I</t></si>", "<si><t>K-N-B-V-D</t></si>", "<si><t>A-Z-N-X-G</t></si>",
"<si><t>U-T-D-A-Y</t></si>", "<si><t>Q-Z-D-F-E</t></si>", "<si><t>J-Q-I-Y-C</t></si>",
"<si><t>G-L-E-O-R</t></si>", "<si><t>V-J-Z-K-F</t></si>", "<si><t>O-W-F-X-H</t></si>",
"<si><t>H-R-P-X-L</t></si>", "<si><t>B-F-X-G-P</t></si>", "<si><t>I-C-A-M-R</t></si>",
"<si><t>P-N-W-Z-L</t></si>", "<si><t>R-G-O-H-D</t></si>", "<si><t>G-M-B-W-K</t></si>",
"<si><t>G-D-E-H-P</t></si>", "<si><t>Z-K-I-P-N</t></si>", "<si><t>K-V-C-E-W</t></si>",
"<si><t>O-K-N-T-R</t></si>", "<si><t>K-B-N-X-M</t></si>", "<si><t>E-V-A-X-P</t></si>",
"<si><t>Q-J-I-Y-C</t></si>", "<si><t>I-T-U-J-D</t></si>", "<si><t>W-U-T-O-Q</t></si>",
"<si><t>O-E-H-J-A</t></si>", "<si><t>D-K-P-A-I</t></si>", "<si><t>D-J-A-F-X</t></si>",
"<si><t>T-X-D-V-A</t></si>", "<si><t>B-W-T-H-V</t></si>", "<si><t>H-G-Q-E-U</t></si>",
"<si><t>B-U-F-Z-Y</t></si>", "<si><t>O-S-R-T-D</t></si>", "<si><t>F-W-S-I-G</t></si>",
"<si><t>Z-O-X-C-S</t></si>", "<si><t>H-V-K-N-E</t></si>", "<si><t>Z-M-L-E-O</t></si>",
"<si><t>Q-V-T-M-P</t></si>", "<si><t>T-N-D-C-S</t></si>", "<si><t>L-F-Q-R-Y</t></si>",
"<si><t>U-F-S-I-O</t></si>", "<si><t>S-R-M-B-K</t></si>", "<si><t>D-P-W-U-A</t></si>",
"<si><t>Y-W-A-T-E</t></si>", "<si><t>I-W-A-F-J</t></si>", "<si><t>V-J-G-A-Q</t></si>",
"<si><t>Z-S-C-Y-L</t></si>", "<si><t>T-C-N-O-S</t></si>", "<si><t>J-R-Y-X-Q</t></si>",
"<si><t>A-F-P-N-J</t></si>", "<si><t>R-Y-N-H-M</t></si>", "<si><t>S-W-Q-B-V</t></si>",
"<si><t>N-Q-U-G-K</t></si>", "<si><t>T-A-Y-R-Z</t></si>", "<si><t>I-L-O-U-V</t></si>",
"<si><t>W-B-L-F-Q</t></si>", "<si><t>N-T-E-W-G</t></si>", "<si><t>L-S-I-W-X</t></si>",
"<si><t>P-A-Z-J-U</t></si>", "<si><t>Z-N-F-X-G</t></si>", "<si><t>P-B-O-E-N</t></si>",
"<si><t>D-U-T-C-K</t></si>", "<si><t>G-Y-I-K-S</t></si>", "<si><t>F-H-W-X-P</t></si>",
"<si><t>O-B-T-E-Z</t></si>", "<si><t>N-K-T-S-X</t></si>", "<si><t>E-S-T-N-V</t></si>",
"<si><t>E-A-J-Q-F</t></si>", "<si><t>P-Q-D-X-B</t></si>", "<si><t>R-F-J-E-Q</t></si>",
"<si><t>X-Z-S-M-V</t></si>", "<si><t>E-Z-Q-D-X</t></si>", "<si><t>M-O-T-U-D</t></si>",
"<si><t>O-I-X-Z-H</t></si>", "<si><t>H-T-V-I-M</t></si>", "<si><t>U-E-A-D-W</t></si>",
"<si><t>Z-D-F-A-X</t></si>", "<si><t>E-D-V-P-N</t></si>", "<si><t>K-J-R-M-H</t></si>",
"<si><t>V-A-K-U-D</t></si>", "<si><t>S-B-L-A-N</t></si>", "<si><t>Q-C-Z-D-P</t></si>",
"<si><t>U-Z-A-W-C</t></si>", "<si><t>V-D-M-G-B</t></si>", "<si><t>Z-H-A-I-X</t></si>",
"<si><t>W-F-H-R-X</t></si>", "<si><t>G-E-V-F-K</t></si>", "<si><t>H-A-V-L-E</t></si>",
"<si><t>K-P-E-X-Y</t></si>", "<si><t>T-O-Y-R-P</t></si>", "<si><t>H-T-F-U-K</t></si>",
"<si><t>R-V-N-C-X</t></si>", "<si><t>K-H-Z-R-A</t></si>", "<si><t>Q-P-J-G-N</t></si>",
"<si><t>T-F-L-K-E</t></si>", "<si><t>E-T-O-D-G</t></si>", "<si><t>J-K-E-S-N</t></si>",
"<si><t>K-Q-D-C-B</t></si>", "<si><t>Q-R-A-F-D</t></si>", "<si><t>J-W-A-Q-I</t></si>",
"<si><t>N-T-F-G-D</t></si>", "<si><t>E-R-I-D-N</t></si>", "<si><t>M-G-P-Q-V</t></si>",
"<si><t>D-P-R-G-N</t></si>", "<si><t>N-C-F-T-A</t></si>", "<si><t>D-F-Q-X-O</t></si>",
"<si><t>U-D-K-Q-X</t></si>", "<si><t>N-G-M-Q-A</t></si>", "<si><t>I-X-F-D-V</t></si>",
"<si><t>R-T-C-K-I</t></si>", "<si><t>S-G-E-R-O</t></si>", "<si><t>R-B-J-G-Z</t></si>",
"<si><t>J-X-G-K-R</t></si>", "<si><t>U-K-O-L-C</t></si>", "<si><t>X-Q-U-S-B</t></si>",
"<si><t>B-A-M-V-N</t></si>", "<si><t>N-A-V-G-U</t></si>", "<si><t>I-Y-U-Z-C</t></si>",
"<si><t>Y-R-I-M-V</t></si>", "<si><t>Y-I-R-P-N</t></si>", "<si><t>E-C-Q-A-P</t></si>",
"<si><t>P-Z-B-O-A</t></si>", "<si><t>D-A-R-F-Y</t></si>", "<si><t>Q-E-T-L-N</t></si>",
"<si><t>Z-D-F-Q-C</t></si>", "<si><t>X-T-Q-W-D</t></si>", "<si><t>D-P-Y-U-J</t></si>",
"<si><t>S-J-Q-X-V</t></si>", "<si><t>E-O-P-W-N</t></si>", "<si><t>W-Q-B-O-Y</t></si>",
"<si><t>Y-Z-W-Q-F</t></si>", "<si><t>H-Q-C-X-O</t></si>", "<si><t>S-B-W-V-L</t></si>",
"<si><t>G-R-Y-V-J</t></si>", "<si><t>W-F-G-K-S</t></si>", "<si><t>F-N-P-D-S</t></si>",
"<si><t>L-C-Q-T-Z</t></si>", "<si><t>V-S-Y-O-B</t></si>", "<si><t>L-F-X-U-Q</t></si>",
"<si><t>G-D-R-M-E</t></si>", "<si><t>P-Q-R-Y-G</t></si>", "<si><t>N-E-H-L-P</t></si>",
"<si><t>Z-R-F-M-U</t></si>", "<si><t>I-X-C-F-O</t></si>", "<si><t>L-E-X-K-O</t></si>",
"<si><t>G-V-Y-X-F</t></si>", "<si><t>O-P-V-A-Z</t></si>", "<si><t>P-K-S-L-Y</t></si>",
"<si><t>Q-R-K-M-D</t></si>", "<si><t>A-N-B-J-R</t></si>", "<si><t>C-S-G-R-M</t></si>",
"<si><t>H-C-E-O-D</t></si>", "<si><t>E-I-N-F-O</t></si>", "<si><t>F-S-P-O-B</t></si>",
"<si><t>T-S-A-X-B</t></si>", "<si><t>R-K-Y-L-M</t></si>", "<si><t>F-G-O-C-T</t></si>",
"<si><t>C-F-H-Y-Z</t></si>", "<si><t>M-P-Z-A-V</t></si>", "<si><t>N-U-X-B-T</t></si>",
"<si><t>Q-A-V-N-P</t></si>", "<si><t>D-R-V-C-K</t></si>", "<si><t>U-P-X-M-F</t></si>",
"<si><t>S-P-I-T-Z</t></si>", "<si><t>O-Z-C-U-Y</t></si>", "<si><t>B-G-X-A-D</t></si>",
"<si><t>Y-U-L-A-W</t></si>", "<si><t>O-J-Q-W-G</t></si>", "<si><t>V-B-I-F-D</t></si>",
"<si><t>V-J-Q-K-A</t></si>", "<si><t>H-X-W-S-A</t></si>", "<si><t>E-D-F-T-I</t></si>",
"<si><t>H-Q-V-R-L</t></si>", "<si><t>M-U-Z-K-Q</t></si>", "<si><t>V-Y-U-Q-X</t></si>",
"<si><t>H-M-I-U-O</t></si>", "<si><t>N-Q-P-U-R</t></si>", "<si><t>Y-F-I-V-D</t></si>",
"<si><t>F-A-L-W-M</t></si>", "<si><t>G-Q-M-L-B</t></si>", "<si><t>X-B-L-P-W</t></si>",
"<si><t>I-A-R-Q-F</t></si>", "<si><t>U-E-J-T-V</t></si>", "<si><t>O-B-Q-U-S</t></si>",
"<si><t>B-P-U-S-M</t></si>", "<si><t>N-Z-D-O-V</t></si>", "<si><t>A-X-S-T-V</t></si>",
"<si><t>O-Y-C-F-K</t></si>", "<si><t>D-S-I-M-Y</t></si>", "<si><t>B-Y-N-G-I</t></si>",
"<si><t>G-P-U-M-F</t></si>", "<si><t>V-B-G-N-W</t></si>", "<si><t>C-K-I-S-Y</t></si>",
"<si><t>U-B-I-R-V</t></si>", "<si><t>L-R-M-C-Z</t></si>", "<si><t>T-Z-D-U-M</t></si>",
"<si><t>R-M-F-T-O</t></si>", "<si><t>S-V-D-F-Y</t></si>", "<si><t>M-F-R-C-J</t></si>",
"<si><t>G-P-O-X-W</t></si>", "<si><t>M-R-X-H-Z</t></si>", "<si><t>N-D-J-R-Y</t></si>",
"<si><t>B-J-W-U-L</t></si>", "<si><t>T-E-U-D-J</t></si>", "<si><t>M-V-J-R-B</t></si>",
"<si><t>G-X-Z-U-Y</t></si>", "<si><t>L-C-P-M-D</t></si>", "<si><t>H-Z-W-E-T</t></si>",
"<si><t>O-H-Y-C-K</t></si>", "<si><t>M-B-Q-N-E</t></si>", "<si><t>B-D-E-U-V</t></si>",
"<si><t>V-P-F-Y-R</t></si>", "<si><t>U-M-C-J-L</t></si>", "<si><t>P-X-L-Z-A</t></si>",
"<si><t>D-E-F-X-H</t></si>", "<si><t>P-I-Z-C-V</t></si>", "<si><t>V-N-O-B-G</t></si>",
"<si><t>M-T-U-D-P</t></si>", "<si><t>I-A-E-O-Q</t></si>", "<si><t>V-R-S-L-A</t></si>",
"<si><t>S-I-Q-N-T</t></si>", "<si><t>A-W-T-O-U</t></si>", "<si><t>O-T-V-A-Q</t></si>",
"<si><t>D-R-O-Z-F</t></si>", "<si><t>Z-M-F-Q-I</t></si>", "<si><t>B-H-E-L-M</t></si>",
"<si><t>Z-S-D-L-G</t></si>", "<si><t>E-B-N-A-Q</t></si>", "<si><t>K-Z-O-C-D</t></si>",
"<si><t>Y-J-M-C-Z</t></si>", "<si><t>K-O-F-A-G</t></si>", "<si><t>J-U-L-Y-G</t></si>",
"<si><t>A-F-C-V-D</t></si>", "<si><t>S-B-H-T-U</t></si>", "<si><t>J-F-V-T-Q</t></si>",
"<si><t>H-L-Z-K-M</t></si>", "<si><t>F-Q-O-K-S</t></si>", "<si><t>P-S-U-V-A</t></si>",
"<si><t>Y-L-E-D-F</t></si>", "<si><t>Z-L-U-K-V</t></si>", "<si><t>J-N-M-P-F</t></si>",
"<si><t>G-M-F-Y-Z</t></si>", "<si><t>W-P-N-D-U</t></si>", "<si><t>J-V-Q-H-P</t></si>",
"<si><t>Q-B-H-O-R</t></si>", "<si><t>U-R-J-K-W</t></si>", "<si><t>J-Q-S-O-F</t></si>",
"<si><t>S-J-N-T-O</t></si>", "<si><t>A-S-B-Q-W</t></si>", "<si><t>W-X-Q-H-I</t></si>",
"<si><t>K-R-V-S-X</t></si>", "<si><t>Q-S-O-R-W</t></si>", "<si><t>R-Q-N-G-Z</t></si>",
"<si><t>Z-P-A-S-R</t></si>", "<si><t>F-N-X-K-D</t></si>", "<si><t>S-I-X-A-W</t></si>",
"<si><t>K-E-J-H-G</t></si>", "<si><t>D-N-Z-W-U</t></si>", "<si><t>X-Y-T-J-O</t></si>",
"<si><t>X-I-J-Z-S</t></si>", "<si><t>R-V-L-W-C</t></si>", "<si><t>X-T-A-M-I</t></si>",
"<si><t>A-W-B-K-M</t></si>", "<si><t>E-C-Q-T-X</t></si>", "<si><t>A-B-V-W-X</t></si>",
"<si><t>K-O-B-W-Q</t></si>", "<si><t>V-Y-F-P-C</t></si>", "<si><t>H-O-E-X-D</t></si>",
"<si><t>I-Y-A-H-Q</t></si>", "<si><t>J-U-N-D-F</t></si>", "<si><t>O-V-N-P-Y</t></si>",
"<si><t>X-R-O-C-J</t></si>", "<si><t>W-I-D-R-M</t></si>", "<si><t>Q-C-O-H-N</t></si>",
"<si><t>L-Z-Y-W-T</t></si>", "<si><t>L-H-J-U-I</t></si>", "<si><t>X-M-E-R-U</t></si>",
"<si><t>R-J-K-Z-E</t></si>", "<si><t>Q-A-I-P-R</t></si>", "<si><t>A-D-L-Q-M</t></si>",
"<si><t>F-E-M-B-Z</t></si>", "<si><t>S-J-N-H-P</t></si>", "<si><t>I-Y-C-L-F</t></si>",
"<si><t>W-Y-O-N-I</t></si>", "<si><t>S-E-N-B-H</t></si>", "<si><t>K-Z-E-U-V</t></si>",
"<si><t>D-N-Y-Z-O</t></si>", "<si><t>Q-S-B-J-P</t></si>", "<si><t>J-N-V-T-B</t></si>",
"<si><t>U-H-Q-L-S</t></si>", "<si><t>U-C-N-Q-L</t></si>", "<si><t>A-L-R-Q-F</t></si>",
"<si><t>J-Y-K-P-L</t></si>", "<si><t>W-S-O-M-U</t></si>", "<si><t>L-P-S-U-T</t></si>",
"<si><t>U-V-P-F-M</t></si>", "<si><t>C-J-W-Q-N</t></si>", "<si><t>A-V-C-P-L</t></si>",
"<si><t>P-V-N-Y-E</t></si>", "<si><t>A-S-M-K-G</t></si>", "<si><t>T-U-I-W-H</t></si>",
"<si><t>E-K-G-P-M</t></si>", "<si><t>Z-F-O-H-E</t></si>", "<si><t>C-G-I-X-R</t></si>",
"<si><t>R-F-D-O-X</t></si>", "<si><t>C-R-F-M-Q</t></si>", "<si><t>H-F-M-N-W</t></si>",
"<si><t>M-Y-F-I-X</t></si>", "<si><t>A-B-U-X-S</t></si>", "<si><t>C-F-G-R-D</t></si>",
"<si><t>M-A-G-L-C</t></si>", "<si><t>W-L-Y-F-U</t></si>", "<si><t>U-M-C-R-H</t></si>",
"<si><t>A-C-P-Y-K</t></si>", "<si><t>A-E-V-C-P</t></si>", "<si><t>M-C-A-J-B</t></si>",
"<si><t>M-O-Z-G-A</t></si>", "<si><t>T-R-E-Y-M</t></si>", "<si><t>F-K-E-S-C</t></si>",
"<si><t>F-Q-B-J-T</t></si>", "<si><t>R-Y-D-V-B</t></si>", "<si><t>J-M-C-R-W</t></si>",
"<si><t>L-S-E-Z-R</t></si>", "<si><t>J-A-E-P-N</t></si>", "<si><t>Y-S-K-B-O</t></si>",
"<si><t>S-Y-N-G-C</t></si>", "<si><t>B-Q-I-W-H</t></si>", "<si><t>W-T-U-J-Y</t></si>",
"<si><t>O-J-W-G-C</t></si>", "<si><t>Q-B-G-I-F</t></si>", "<si><t>W-E-B-T-N</t></si>",
"<si><t>M-A-U-R-G</t></si>", "<si><t>Q-R-O-X-P</t></si>", "<si><t>H-T-Y-N-P</t></si>",
"<si><t>L-Q-A-G-X</t></si>", "<si><t>U-S-D-R-C</t></si>", "<si><t>I-J-F-R-Q</t></si>",
"<si><t>K-T-G-C-E</t></si>", "<si><t>M-K-P-C-T</t></si>", "<si><t>W-Z-L-N-K</t></si>",
"<si><t>B-O-G-U-P</t></si>", "<si><t>C-F-V-D-P</t></si>", "<si><t>G-A-P-R-X</t></si>",
"<si><t>E-I-Y-K-F</t></si>", "<si><t>W-H-G-P-S</t></si>", "<si><t>G-J-W-M-B</t></si>",
"<si><t>R-Y-B-F-L</t></si>", "<si><t>T-F-Y-Q-I</t></si>", "<si><t>R-L-O-C-F</t></si>",
"<si><t>I-X-S-G-O</t></si>", "<si><t>F-R-M-A-X</t></si>", "<si><t>H-B-L-Z-A</t></si>",
"<si><t>A-L-M-N-C</t></si>", "<si><t>F-D-Q-X-L</t></si>", "<si><t>Y-K-S-Q-D</t></si>",
"<si><t>I-Z-B-O-D</t></si>", "<si><t>R-M-A-S-C</t></si>", "<si><t>J-S-U-H-T</t></si>",
"<si><t>Q-B-A-P-Z</t></si>", "<si><t>I-D-X-Q-O</t></si>", "<si><t>F-H-S-W-Z</t></si>",
"<si><t>P-V-K-R-G</t></si>", "<si><t>L-B-A-H-I</t></si>", "<si><t>I-P-T-O-Q</t></si>",
"<si><t>N-F-K-Y-V</t></si>", "<si><t>T-U-M-A-G</t></si>", "<si><t>S-N-X-W-F</t></si>",
"<si><t>I-V-Y-O-C</t></si>", "<si><t>M-T-Z-G-O</t></si>", "<si><t>R-V-B-J-I</t></si>",
"<si><t>O-X-N-R-V</t></si>", "<si><t>W-N-M-F-J</t></si>", "<si><t>I-L-R-D-B</t></si>",
"<si><t>E-G-F-V-Z</t></si>", "<si><t>A-P-S-L-Y</t></si>", "<si><t>U-A-X-G-O</t></si>",
"<si><t>Y-D-B-O-M</t></si>", "<si><t>T-Q-K-M-D</t></si>", "<si><t>L-K-D-X-G</t></si>",
"<si><t>V-Z-J-A-C</t></si>", "<si><t>T-N-I-W-H</t></si>", "<si><t>Z-C-S-R-E</t></si>",
"<si><t>X-P-C-S-J</t></si>", "<si><t>O-A-F-C-R</t></si>", "<si><t>P-Z-X-W-E</t></si>",
"<si><t>N-L-Q-W-Z</t></si>", "<si><t>M-J-W-D-T</t></si>", "<si><t>R-S-Q-G-O</t></si>",
"<si><t>Z-C-Q-Y-S</t></si>", "<si><t>S-J-Y-R-V</t></si>", "<si><t>B-H-M-G-A</t></si>",
"<si><t>Y-K-D-O-N</t></si>", "<si><t>Y-F-G-W-J</t></si>", "<si><t>I-G-T-C-V</t></si>",
"<si><t>U-D-T-B-F</t></si>", "<si><t>N-Q-X-R-V</t></si>", "<si><t>F-O-N-L-V</t></si>",
"<si><t>R-C-X-F-I</t></si>", "<si><t>C-G-H-U-X</t></si>", "<si><t>T-I-J-W-G</t></si>",
"<si><t>U-B-G-O-Y</t></si>", "<si><t>G-C-H-Q-V</t></si>", "<si><t>S-U-D-A-H</t></si>",
"<si><t>F-B-S-I-H</t></si>", "<si><t>X-R-S-O-B</t></si>", "<si><t>M-H-C-E-K</t></si>",
"<si><t>Y-J-A-T-N</t></si>", "<si><t>Z-B-I-D-X</t></si>", "<si><t>R-I-U-E-B</t></si>",
"<si><t>C-S-O-V-X</t></si>", "<si><t>S-Y-G-E-M</t></si>", "<si><t>N-O-D-H-Z</t></si>",
"<si><t>U-D-V-T-S</t></si>", "<si><t>U-I-H-Q-M</t></si>", "<si><t>L-E-S-U-Y</t></si>",
"<si><t>L-Q-Y-W-P</t></si>", "<si><t>J-K-U-C-V</t></si>", "<si><t>A-Z-R-S-N</t></si>",
"<si><t>Z-F-A-Y-L</t></si>", "<si><t>C-L-G-R-I</t></si>", "<si><t>A-N-Q-C-Z</t></si>",
"<si><t>A-X-P-R-Z</t></si>", "<si><t>W-N-I-M-X</t></si>", "<si><t>O-I-L-B-N</t></si>",
"<si><t>P-U-Q-S-Y</t></si>", "<si><t>N-M-W-L-D</t></si>", "<si><t>D-V-X-C-R</t></si>",
"<si><t>P-G-J-I-X</t></si>", "<si><t>Y-G-C-T-H</t></si>", "<si><t>R-S-V-N-X</t></si>",
"<si><t>Y-H-O-Q-D</t></si>", "<si><t>Q-N-Y-Z-H</t></si>", "<si><t>D-Q-J-B-H</t></si>",
"<si><t>N-X-O-Z-T</t></si>", "<si><t>R-Q-B-X-J</t></si>", "<si><t>V-S-U-E-K</t></si>",
"<si><t>H-X-U-C-K</t></si>", "<si><t>W-X-E-I-P</t></si>", "<si><t>Z-H-J-N-L</t></si>",
"<si><t>A-R-N-V-H</t></si>", "<si><t>R-W-L-O-N</t></si>", "<si><t>Q-Z-K-E-G</t></si>",
"<si><t>M-X-L-W-F</t></si>", "<si><t>Z-R-L-K-J</t></si>", "<si><t>S-E-G-Y-N</t></si>",
"<si><t>R-H-K-V-L</t></si>", "<si><t>A-V-Q-R-I</t></si>", "<si><t>Z-L-J-B-O</t></si>",
"<si><t>W-S-R-C-V</t></si>", "<si><t>S-L-Q-M-R</t></si>", "<si><t>T-P-Y-A-K</t></si>",
"<si><t>W-R-H-U-O</t></si>", "<si><t>Z-B-Q-P-J</t></si>", "<si><t>I-H-Q-Y-U</t></si>",
"<si><t>W-K-U-I-S</t></si>", "<si><t>V-Y-N-M-W</t></si>", "<si><t>O-C-P-J-V</t></si>",
"<si><t>M-S-Z-W-G</t></si>", "<si><t>T-M-E-X-F</t></si>", "<si><t>E-W-A-P-N</t></si>",
"<si><t>Z-S-N-B-K</t></si>", "<si><t>G-D-X-R-V</t></si>", "<si><t>O-D-J-X-I</t></si>",
"<si><t>F-V-G-U-L</t></si>", "<si><t>R-U-I-Z-M</t></si>", "<si><t>G-E-O-L-I</t></si>",
"<si><t>K-T-B-F-X</t></si>", "<si><t>I-M-R-C-T</t></si>", "<si><t>B-Q-M-F-C</t></si>",
"<si><t>E-J-F-W-B</t></si>", "<si><t>W-P-N-H-G</t></si>", "<si><t>E-F-G-O-J</t></si>",
"<si><t>P-C-O-S-H</t></si>", "<si><t>C-L-A-N-W</t></si>", "<si><t>J-N-B-F-K</t></si>",
"<si><t>S-X-A-E-Z</t></si>", "<si><t>G-B-F-T-P</t></si>", "<si><t>K-C-G-D-E</t></si>",
"<si><t>T-I-O-G-U</t></si>", "<si><t>B-R-W-Q-Z</t></si>", "<si><t>L-C-R-G-N</t></si>",
"<si><t>F-A-B-V-G</t></si>", "<si><t>R-E-Q-W-L</t></si>", "<si><t>L-Z-J-H-S</t></si>",
"<si><t>E-R-L-D-N</t></si>", "<si><t>N-D-A-O-F</t></si>", "<si><t>V-O-A-C-L</t></si>",
"<si><t>A-J-S-M-W</t></si>", "<si><t>K-B-V-T-O</t></si>", "<si><t>J-D-P-K-L</t></si>",
"<si><t>J-Y-T-D-X</t></si>", "<si><t>Z-A-E-K-B</t></si>", "<si><t>L-D-R-Z-Q</t></si>",
"<si><t>O-X-L-B-G</t></si>", "<si><t>B-P-V-O-K</t></si>", "<si><t>Y-J-D-T-E</t></si>",
"<si><t>C-F-R-N-W</t></si>", "<si><t>U-Y-M-Q-E</t></si>", "<si><t>Y-O-V-X-H</t></si>",
"<si><t>Z-K-D-V-Q</t></si>", "<si><t>A-Q-B-P-S</t></si>", "<si><t>W-S-O-Z-B</t></si>",
"<si><t>W-D-U-F-S</t></si>", "<si><t>A-H-P-R-E</t></si>", "<si><t>W-N-V-J-K</t></si>",
"<si><t>D-F-U-Y-S</t></si>", "<si><t>O-A-G-P-V</t></si>", "<si><t>V-J-R-E-P</t></si>",
"<si><t>I-P-R-E-U</t></si>", "<si><t>F-T-C-O-G</t></si>", "<si><t>K-F-U-M-H</t></si>",
"<si><t>V-N-F-X-U</t></si>", "<si><t>E-R-C-H-B</t></si>", "<si><t>D-U-C-V-X</t></si>",
"<si><t>Q-Z-U-C-A</t></si>", "<si><t>B-G-I-O-T</t></si>", "<si><t>L-C-S-Z-M</t></si>",
"<si><t>S-Y-A-W-P</t></si>", "<si><t>K-M-D-G-N</t></si>", "<si><t>O-I-D-R-Q</t></si>",
"<si><t>D-P-J-Q-C</t></si>", "<si><t>T-N-I-B-L</t></si>", "<si><t>I-G-M-D-A</t></si>",
"<si><t>O-D-C-L-Y</t></si>", "<si><t>B-D-Q-H-F</t></si>", "<si><t>H-M-W-P-X</t></si>",
"<si><t>Z-Q-U-T-L</t></si>", "<si><t>K-F-I-O-R</t></si>", "<si><t>U-W-L-M-V</t></si>",
"<si><t>M-A-N-D-Y</t></si>", "<si><t>M-E-X-I-K</t></si>", "<si><t>Y-S-F-L-V</t></si>",
"<si><t>Q-Y-O-L-E</t></si>", "<si><t>T-K-G-A-O</t></si>", "<si><t>I-S-J-V-Q</t></si>",
"<si><t>J-K-P-B-G</t></si>", "<si><t>D-P-F-I-T</t></si>", "<si><t>I-Q-B-J-M</t></si>",
"<si><t>E-Q-H-V-W</t></si>", "<si><t>J-D-C-E-Q</t></si>", "<si><t>Q-U-V-D-J</t></si>",
"<si><t>G-D-S-Z-T</t></si>", "<si><t>U-M-X-Z-C</t></si>", "<si><t>Q-R-Z-G-W</t></si>",
"<si><t>R-C-L-Q-J</t></si>", "<si><t>E-I-O-V-W</t></si>", "<si><t>S-E-R-D-Q</t></si>",
"<si><t>V-J-E-D-T</t></si>", "<si><t>K-A-D-N-T</t></si>", "<si><t>P-C-R-Z-X</t></si>",
"<si><t>P-B-I-T-E</t></si>", "<si><t>H-W-Q-L-C</t></si>", "<si><t>C-J-K-E-G</t></si>",
"<si><t>R-Y-D-P-Q</t></si>", "<si><t>R-X-U-L-K</t></si>", "<si><t>R-T-Q-G-Y</t></si>",
"<si><t>X-H-J-T-D</t></si>", "<si><t>U-E-F-I-A</t></si>", "<si><t>L-K-O-C-M</t></si>",
"<si><t>K-Y-H-M-J</t></si>", "<si><t>T-M-K-L-Y</t></si>", "<si><t>B-D-U-L-P</t></si>",
"<si><t>D-G-N-F-H</t></si>", "<si><t>H-K-O-J-B</t></si>", "<si><t>L-A-C-X-D</t></si>",
"<si><t>L-D-P-Q-J</t></si>", "<si><t>A-F-T-U-R</t></si>", "<si><t>M-W-H-Q-V</t></si>",
"<si><t>T-F-J-S-G</t></si>", "<si><t>C-T-W-E-N</t></si>", "<si><t>K-U-F-A-D</t></si>",
"<si><t>S-U-Q-T-P</t></si>", "<si><t>K-V-Y-B-T</t></si>", "<si><t>E-V-Y-O-S</t></si>",
"<si><t>D-J-E-I-C</t></si>", "<si><t>Y-P-M-X-O</t></si>", "<si><t>Q-X-W-K-S</t></si>",
"<si><t>G-W-O-B-C</t></si>", "<si><t>A-V-G-B-D</t></si>", "<si><t>I-L-V-D-K</t></si>",
"<si><t>R-V-G-B-W</t></si>", "<si><t>Z-S-O-M-G</t></si>", "<si><t>B-A-C-X-W</t></si>",
"<si><t>S-P-X-G-Q</t></si>", "<si><t>A-I-S-C-B</t></si>", "<si><t>Q-N-S-J-P</t></si>",
"<si><t>E-T-W-J-B</t></si>", "<si><t>R-X-Y-T-E</t></si>", "<si><t>X-G-Z-V-S</t></si>",
"<si><t>C-M-B-A-N</t></si>", "<si><t>N-L-W-B-I</t></si>", "<si><t>R-H-E-F-X</t></si>",
"<si><t>E-U-I-Z-C</t></si>", "<si><t>N-F-E-Z-V</t></si>", "<si><t>T-S-O-J-F</t></si>",
"<si><t>R-U-B-S-K</t></si>", "<si><t>R-A-S-K-G</t></si>", "<si><t>O-F-K-R-V</t></si>",
"<si><t>N-X-J-A-M</t></si>", "<si><t>E-A-Z-T-X</t></si>", "<si><t>H-G-S-J-M</t></si>",
"<si><t>H-E-A-J-U</t></si>", "<si><t>N-Z-M-Q-O</t></si>", "<si><t>B-M-R-E-S</t></si>",
"<si><t>X-Y-Z-E-U</t></si>", "<si><t>W-I-H-R-J</t></si>", "<si><t>N-W-M-Y-Q</t></si>",
"<si><t>I-N-O-T-P</t></si>", "<si><t>C-N-T-H-W</t></si>", "<si><t>O-C-M-H-L</t></si>",
"<si><t>V-U-X-N-Q</t></si>", "<si><t>M-B-W-A-N</t></si>", "<si><t>H-Q-Z-B-L</t></si>",
"<si><t>H-E-C-O-Y</t></si>", "<si><t>A-D-W-F-Y</t></si>", "<si><t>C-G-L-M-O</t></si>",
"<si><t>A-D-U-O-C</t></si>", "<si><t>U-O-V-R-H</t></si>", "<si><t>Z-B-Y-G-L</t></si>",
"<si><t>L-X-C-E-P</t></si>", "<si><t>L-P-K-M-R</t></si>", "<si><t>A-F-T-M-B</t></si>",
"<si><t>E-Z-B-K-U</t></si>", "<si><t>D-F-E-A-Y</t></si>", "<si><t>J-A-R-M-O</t></si>",
"<si><t>T-N-I-U-X</t></si>", "<si><t>F-Q-B-D-J</t></si>", "<si><t>N-J-M-R-Z</t></si>",
"<si><t>Z-G-C-A-K</t></si>", "<si><t>U-G-V-X-H</t></si>", "<si><t>D-I-R-Z-W</t></si>",
"<si><t>E-O-M-R-T</t></si>", "<si><t>L-G-S-F-M</t></si>", "<si><t>A-J-C-K-N</t></si>",
"<si><t>Z-N-D-L-H</t></si>", "<si><t>X-Y-S-U-V</t></si>", "<si><t>B-Q-I-L-Y</t></si>",
"<si><t>J-C-D-Z-E</t></si>", "<si><t>S-U-K-T-G</t></si>", "<si><t>P-W-T-X-U</t></si>",
"<si><t>D-I-H-B-A</t></si>", "<si><t>Y-W-L-U-E</t></si>", "<si><t>F-O-A-S-V</t></si>",
"<si><t>B-H-R-Z-J</t></si>", "<si><t>B-V-C-Y-L</t></si>", "<si><t>Z-C-J-F-H</t></si>",
"<si><t>Z-Y-V-A-T</t></si>", "<si><t>R-F-D-E-Y</t></si>", "<si><t>J-O-L-A-M</t></si>",
"<si><t>L-B-Z-F-P</t></si>", "<si><t>X-P-S-D-R</t></si>", "<si><t>O-E-B-R-S</t></si>",
"<si><t>J-P-B-Q-X</t></si>", "<si><t>Q-E-Z-I-U</t></si>", "<si><t>Q-N-G-U-P</t></si>",
"<si><t>W-O-L-I-T</t></si>", "<si><t>D-O-B-K-Z</t></si>", "<si><t>Z-E-A-V-J</t></si>",
"<si><t>K-D-E-W-A</t></si>", "<si><t>Y-B-M-C-Z</t></si>", "<si><t>B-N-Y-J-O</t></si>",
"<si><t>L-U-F-E-J</t></si>", "<si><t>B-V-X-O-F</t></si>", "<si><t>V-X-S-A-P</t></si>",
"<si><t>L-B-Y-D-E</t></si>", "<si><t>E-U-D-V-T</t></si>", "<si><t>J-P-T-D-A</t></si>",
"<si><t>Q-C-R-X-V</t></si>", "<si><t>I-D-L-A-O</t></si>", "<si><t>R-G-Q-V-K</t></si>",
"<si><t>H-S-W-R-F</t></si>", "<si><t>C-E-F-Y-O</t></si>", "<si><t>S-P-B-Q-M</t></si>",
"<si><t>B-J-Z-F-Q</t></si>", "<si><t>U-E-C-P-Z</t></si>", "<si><t>D-H-O-E-B</t></si>",
"<si><t>G-J-L-R-S</t></si>", "<si><t>L-C-V-T-S</t></si>", "<si><t>R-V-W-K-I</t></si>",
"<si><t>A-M-X-W-P</t></si>", "<si><t>W-B-K-A-C</t></si>", "<si><t>P-O-I-L-S</t></si>",
"<si><t>A-K-T-B-Y</t></si>", "<si><t>K-B-X-R-T</t></si>", "<si><t>S-P-T-Q-W</t></si>",
"<si><t>D-Z-U-W-B</t></si>", "<si><t>L-S-E-H-Q</t></si>", "<si><t>G-F-W-U-N</t></si>",
"<si><t>J-T-E-Z-F</t></si>", "<si><t>V-X-N-T-B</t></si>", "<si><t>T-K-D-N-R</t></si>",
"<si><t>L-K-Q-I-T</t></si>", "<si><t>N-E-X-D-Q</t></si>", "<si><t>Y-B-S-X-A</t></si>",
"<si><t>S-D-W-J-Q</t></si>", "<si><t>U-H-J-W-I</t></si>", "<si><t>X-Z-A-J-B</t></si>",
"<si><t>E-S-D-O-H</t></si>", "<si><t>G-O-Y-N-Q</t></si>", "<si><t>U-F-I-B-A</t></si>",
"<si><t>M-H-W-C-O</t></si>", "<si><t>F-Z-C-B-M</t></si>", "<si><t>S-C-A-O-V</t></si>",
"<si><t>G-R-H-Q-U</t></si>", "<si><t>V-N-J-Q-P</t></si>", "<si><t>V-P-Y-M-U</t></si>",
"<si><t>R-J-O-Q-V</t></si>", "<si><t>G-C-U-E-I</t></si>", "<si><t>C-A-T-L-R</t></si>",
"<si><t>O-N-S-G-H</t></si>", "<si><t>P-Z-K-U-V</t></si>", "<si><t>R-Z-H-D-N</t></si>",
"<si><t>G-E-X-C-L</t></si>", "<si><t>Q-K-E-P-S</t></si>", "<si><t>N-K-I-H-A</t></si>",
"<si><t>A-N-T-R-M</t></si>", "<si><t>T-R-G-E-F</t></si>", "<si><t>I-B-T-S-D</t></si>",
"<si><t>G-R-J-L-W</t></si>", "<si><t>I-P-Y-K-L</t></si>", "<si><t>S-J-M-F-W</t></si>",
"<si><t>U-H-D-P-T</t></si>", "<si><t>A-D-H-M-B</t></si>", "<si><t>S-T-Z-P-U</t></si>",
"<si><t>N-I-G-R-S</t></si>", "<si><t>U-V-M-Q-S</t></si>", "<si><t>E-F-S-J-R</t></si>",
"<si><t>F-H-O-S-Z</t></si>", "<si><t>O-G-R-E-Z</t></si>", "<si><t>B-M-A-N-T</t></si>",
"<si><t>Z-H-D-L-Q</t></si>", "<si><t>Q-R-N-J-K</t></si>", "<si><t>C-X-H-Y-L</t></si>",
"<si><t>I-X-W-G-E</t></si>", "<si><t>T-B-M-Q-S</t></si>", "<si><t>A-H-Z-V-B</t></si>",
"<si><t>R-Z-M-X-G</t></si>", "<si><t>M-U-K-H-E</t></si>", "<si><t>G-B-L-A-W</t></si>",
"<si><t>R-X-T-S-F</t></si>", "<si><t>D-W-Q-M-S</t></si>", "<si><t>P-B-F-Q-K</t></si>",
"<si><t>R-H-I-J-V</t></si>", "<si><t>I-F-J-V-C</t></si>", "<si><t>U-T-K-R-F</t></si>",
"<si><t>P-T-L-U-R</t></si>", "<si><t>I-L-P-N-F</t></si>", "<si><t>D-H-K-X-J</t></si>",
"<si><t>A-Q-B-M-S</t></si>", "<si><t>B-V-L-Q-F</t></si>", "<si><t>C-H-K-V-A</t></si>",
"<si><t>T-Y-C-P-U</t></si>", "<si><t>B-U-P-Q-H</t></si>", "<si><t>M-H-Q-E-I</t></si>",
"<si><t>E-Z-S-U-K</t></si>", "<si><t>H-W-Q-R-M</t></si>", "<si><t>C-I-B-J-K</t></si>",
"<si><t>E-I-O-S-H</t></si>", "<si><t>Y-I-E-X-L</t></si>", "<si><t>S-Q-O-L-N</t></si>",
"<si><t>J-H-L-T-G</t></si>", "<si><t>H-M-Q-J-I</t></si>", "<si><t>V-I-Z-J-Q</t></si>",
"<si><t>B-G-R-J-P</t></si>", "<si><t>Z-I-W-B-O</t></si>", "<si><t>R-V-B-G-N</t></si>",
"<si><t>B-I-N-J-R</t></si>", "<si><t>F-T-W-M-L</t></si>", "<si><t>F-S-K-I-J</t></si>",
"<si><t>S-N-V-G-Z</t></si>", "<si><t>X-I-G-L-H</t></si>", "<si><t>K-B-X-V-A</t></si>",
"<si><t>F-M-A-H-N</t></si>", "<si><t>Y-Z-I-W-A</t></si>", "<si><t>P-M-R-C-Z</t></si>",
"<si><t>N-U-B-R-A</t></si>", "<si><t>wordZ2</t></si>", "<si><t>Var1</t></si>",
"<si><t>Var2</t></si>", "<si><t>Var3</t></si>", "<si><t>Var4</t></si>",
"<si><t>a</t></si>", "<si><t>b</t></si>", "<si><t>c</t></si>",
"<si><t>e</t></si>", "<si><t>f</t></si>", "<si><t>h</t></si>",
"<si><t>i</t></si>", "<si><t>Var5</t></si>", "<si><t>Var6</t></si>",
"<si><t>Var7</t></si>", "<si><t>col 1</t></si>", "<si><t>col 2</t></si>", "<si><t>g</t></si>", "<si><t>x</t></si>"
), uniqueCount = 2114L)
expect_equal(expected_shared_strings, wb$sharedStrings)
})
test_that("Loading multiple pivot tables: loadPivotTables.xlsx works",{
## loadPivotTables.xlsx is a file with 3 pivot tables and 2 of them have the same reference data (pivotCacheDefinition)
fl <- system.file("extdata", "loadPivotTables.xlsx", package = "openxlsx")
wb <- loadWorkbook(fl)
# Check that wb is correctly loaded
sheet_names <- c("iris",
"iris_pivot",
"penguins",
"penguins_pivot1",
"penguins_pivot2")
expect_equal(wb$sheet_names, sheet_names)
# Check number of 'pivotTables'
expect_equal(length(wb$pivotTables),
3)
# Check number of 'pivotCacheDefinition'
expect_equal(length(wb$pivotDefinitions),
2)
})
test_that("Load and saving a file with Threaded Comments works", {
## loadThreadComment.xlsx is a simple xlsx file that uses Threaded Comment.
fl <- system.file("extdata", "loadThreadComment.xlsx", package = "openxlsx")
wb <- loadWorkbook(fl)
# Check that wb can be saved without error
expect_silent(saveWorkbook(wb, file = temp_xlsx()))
})
test_that("Read and save file with inlineStr", {
## loadThreadComment.xlsx is a simple xlsx file that uses Threaded Comment.
fl <- system.file("extdata", "inlineStr.xlsx", package = "openxlsx")
wb <- loadWorkbook(fl)
wb_df <- readWorkbook(wb)
df <- data.frame(
this = c("is an xlsx file", "written with writexl::write_xlsx"),
it = c("cannot be read", "with open.xlsx::read.xlsx"),
stringsAsFactors = FALSE)
# compare file imported with inlineStr
expect_true(all.equal(df, wb_df, compare.attributes = FALSE))
df_read_xlsx <- read.xlsx(fl)
df_readWorkbook <- readWorkbook(fl)
expect_true(all.equal(df, df_read_xlsx, compare.attributes = FALSE))
expect_true(all.equal(df, df_readWorkbook, compare.attributes = FALSE))
tmp_xlsx <- temp_xlsx()
# Check that wb can be saved without error and reimported
expect_silent(saveWorkbook(wb, file = tmp_xlsx))
wb_df_re <- readWorkbook(loadWorkbook(tmp_xlsx))
expect_true(all.equal(wb_df, wb_df_re, compare.attributes = FALSE))
})
# tests for getChildlessNode returns the content of every node, single node or not. the name has only historical meaning
test_that("read nodes", {
# read single node
test <- "<xf numFmtId=\"0\" fontId=\"4\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\" applyAlignment=\"1\"><alignment horizontal=\"center\"/></xf>"
that <- openxlsx:::getChildlessNode(test, "xf")
expect_equal(test, that)
# real life example <foo/> and <foo>...</foo> mixed
cellXfs <- "<cellXfs count=\"8\"><xf numFmtId=\"0\" fontId=\"0\" fillId=\"0\" borderId=\"0\" xfId=\"0\"/><xf numFmtId=\"0\" fontId=\"1\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/><xf numFmtId=\"0\" fontId=\"3\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/><xf numFmtId=\"0\" fontId=\"5\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/><xf numFmtId=\"0\" fontId=\"6\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/><xf numFmtId=\"0\" fontId=\"2\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/><xf numFmtId=\"0\" fontId=\"7\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/><xf numFmtId=\"0\" fontId=\"4\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\" applyAlignment=\"1\"><alignment horizontal=\"center\"/></xf><xf numFmtId=\"0\" fontId=\"0\" fillId=\"0\" borderId=\"0\" xfId=\"0\"/></cellXfs>"
that <- openxlsx:::getChildlessNode(cellXfs, "xf")
test <- c("<xf numFmtId=\"0\" fontId=\"0\" fillId=\"0\" borderId=\"0\" xfId=\"0\"/>",
"<xf numFmtId=\"0\" fontId=\"1\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/>",
"<xf numFmtId=\"0\" fontId=\"3\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/>",
"<xf numFmtId=\"0\" fontId=\"5\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/>",
"<xf numFmtId=\"0\" fontId=\"6\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/>",
"<xf numFmtId=\"0\" fontId=\"2\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/>",
"<xf numFmtId=\"0\" fontId=\"7\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\"/>",
"<xf numFmtId=\"0\" fontId=\"4\" fillId=\"0\" borderId=\"0\" xfId=\"0\" applyFont=\"1\" applyAlignment=\"1\"><alignment horizontal=\"center\"/></xf>",
"<xf numFmtId=\"0\" fontId=\"0\" fillId=\"0\" borderId=\"0\" xfId=\"0\"/>"
)
expect_equal(test, that)
# test <foos/>
test <- "<xfs bla/>"
that <- openxlsx:::getChildlessNode(test, "xf")
expect_equal(character(0), that)
# test <foo/>
test <- "<b/><b/>"
that <- openxlsx:::getChildlessNode(test, "b")
test <- c(
"<b/>",
"<b/>"
)
expect_equal(test, that)
# test <foo>...</foo>
test <- "<b>a</b><b/>"
that <- openxlsx:::getChildlessNode(test, "b")
test <- c("<b>a</b>", "<b/>")
expect_equal(test, that)
# test <foos><foo/></foos>
test <- "<xfs><xf/></xfs>"
that <- openxlsx:::getChildlessNode(test, "xf")
test <- "<xf/>"
expect_equal(test, that)
})
test_that("sheet visibility", {
# example is rather slow (lots of hidden cols)
fl <- system.file("extdata", "ColorTabs3.xlsx", package = "openxlsx")
tmp_dir <- temp_xlsx()
exp_sheets <- c("Nums", "Chars", "hidden")
exp_vis <- c("visible", "visible", "hidden")
# after load
wb <- loadWorkbook(fl)
wb_sheets <- openxlsx::sheets(wb)
wb_vis <- openxlsx::sheetVisibility(wb)
# save
saveWorkbook(wb, tmp_dir)
# re-import
wb2 <- loadWorkbook(tmp_dir)
wb2_sheets <- openxlsx::sheets(wb)
wb2_vis <- openxlsx::sheetVisibility(wb)
expect_equal(exp_sheets, wb_sheets)
expect_equal(exp_vis, wb_vis)
expect_equal(exp_sheets, wb2_sheets)
expect_equal(exp_vis, wb2_vis)
})
test_that("test headerFooter", {
# Plain text headers and footers
header = c('ODD HEAD LEFT', 'ODD HEAD CENTER', 'ODD HEAD RIGHT')
footer = c('ODD FOOT RIGHT', 'ODD FOOT CENTER', 'ODD FOOT RIGHT')
evenHeader = c('EVEN HEAD LEFT', 'EVEN HEAD CENTER', 'EVEN HEAD RIGHT')
evenFooter = c('EVEN FOOT RIGHT', 'EVEN FOOT CENTER', 'EVEN FOOT RIGHT')
firstHeader = c('TOP', 'OF FIRST', 'PAGE')
firstFooter = c('BOTTOM', 'OF FIRST', 'PAGE')
# Add Sheet 1
wb=createWorkbook()
addWorksheet(wb, 'Sheet 1',
header = header,
footer = footer,
evenHeader = evenHeader,
evenFooter = evenFooter,
firstHeader = firstHeader,
firstFooter = firstFooter)
# Modified headers and footers to make them Arial 8
header <- paste0('&"Arial"&8', header)
footer <- paste0('&"Arial"&8', footer)
evenHeader <- paste0('&"Arial"&8', evenHeader)
evenFooter <- paste0('&"Arial"&8', evenFooter)
firstHeader <- paste0('&"Arial"&8', firstHeader)
firstFooter <- paste0('&"Arial"&8', firstFooter)
# Add Sheet 2
addWorksheet(wb, 'Sheet 2',
header = header,
footer = footer,
evenHeader = evenHeader,
evenFooter = evenFooter,
firstHeader = firstHeader,
firstFooter = firstFooter)
writeData(wb, sheet = 1, 1:400)
writeData(wb, sheet = 2, 1:400)
tmp1 <- temp_xlsx()
# Save workbook
saveWorkbook(wb, tmp1, overwrite = TRUE)
# Load workbook and save again
wb2 <- loadWorkbook(tmp1)
expect_equal(wb$worksheets[[1]]$headerFooter,
wb2$worksheets[[1]]$headerFooter)
expect_equal(wb$worksheets[[2]]$headerFooter,
wb2$worksheets[[2]]$headerFooter)
})
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.