String [] STR = new string [] {…}; // Create a pre-selected column header
Hssfsheet sheet = Workbook. createsheet ("sheet1 ");
Hssfrow ROW = sheet. createrow (0 );
For (INT I = 0; I <Str. length; I ++ ){
Hssfcell cell = row. createcell (short) I );
Cell. setcellvalue (New hssfrichtextstring (STR [I]);
}
// Encapsulate the data into the Map <integer, Map <integer, string> type and write data in two cycles
Map <integer, Map <integer, string> map = (Map <integer, Map <integer, string>) helper. getresult ("map ");
// Create an Excel report with the same columns as the String Array
For (Map. Entry <integer, Map <integer, string> entry: map. entryset ()){
// Create row
Hssfrow _ ROW = sheet. createrow (entry. getkey ());
Map <integer, string> value = entry. getvalue ();
// Create a cell
For (Map. Entry <integer, string> _ entry: value. entryset ()){
Hssfcell _ cell = _ row. createcell (_ entry. getkey (). duplicate value ());
_ Cell. setcellvalue (New hssfrichtextstring (_ entry. getvalue ()));
}
}
}