java - 使用 groovy 中的 map 编写 Excel

Question

我正在尝试使用 groovy 中的 map 编写 Excel 文件。在java中，我在 map 中输入值，如下所示

  //writing data in the map   
Map < String, Object[] > empinfo = new TreeMap < String, Object[] >();
  empinfo.put( "1", new Object[] {"EMP ID", "EMP NAME", "DESIGNATION" });
  empinfo.put( "2", new Object[] {"", "Gopal", "Technical Manager" });
  empinfo.put( "7", new Object[] {"tp02", "Manisha", "Proof Reader" });
  empinfo.put( "4", new Object[] {"tp03", "", "Technical Writer" });
  empinfo.put( "5", new Object[] {"tp04", "Satish", "Technical Writer" });
  empinfo.put( "6", new Object[] {"tp05", "Krishna", "" });

  //Iterate over data and write to sheet
  Set < String > keyid = empinfo.keySet();
  int rowid = 0;
  for (String key : keyid)
  {
     row = spreadsheet.createRow(rowid++);
     Object [] objectArr = empinfo.get(key);
     int cellid = 0;
     for (Object obj : objectArr)
     {
        Cell cell = row.createCell(cellid++);
        cell.setCellValue((String)obj);
     }
  }

如何在 groovy 中完成此操作？我是 groovy 的新手，非常感谢任何帮助。

Answer 1

你会得到groovy.lang.MissingMethodException，因为groovy不支持这样的数组声明语法。

Groovy array declaration

Groovy map declaration

以下是声明 TreeMap 的方法

def empinfo = new TreeMap<String, Object[]>();

empinfo["1"] = ["EMP ID", "EMP NAME", "DESIGNATION"] as Object[];
empinfo["2"] = ["", "Gopal", "Technical Manager"] as Object[];
empinfo["7"] = ["tp02", "Manisha", "Proof Reader"] as Object[];
empinfo["4"] = ["tp03", "", "Technical Writer"] as Object[];
empinfo["5"] = ["tp04", "Satish", "Technical Writer"] as Object[];
empinfo["6"] = ["tp05", "Krishna", ""] as Object[];

或

TreeMap empinfo = [
    "1": ["EMP ID", "EMP NAME", "DESIGNATION"] as Object[],
    "2": ["", "Gopal", "Technical Manager"] as Object[],
    "7": ["tp02", "Manisha", "Proof Reader"] as Object[],
    "4": ["tp03", "", "Technical Writer"] as Object[],
    "5": ["tp04", "Satish", "Technical Writer"] as Object[],
    "6": ["tp05", "Krishna", ""] as Object[]
];