Read the Excel template, insert data, and generate a new file to save.
This article accepts 03 Excel operations (same as 07, but hssf is replaced with xssf)
Fileinputstream = new fileinputstream (templeexcelpath); hssfworkbook xssfworkbook = new hssfworkbook (fileinputstream); hssfsheet xssfsheet = xssfworkbook. getsheetat (0); hssfrow xssfrow = xssfsheet. createrow (xssfsheet. getlastrownum () + 1); xssfrow. createcell (0 ). setcellvalue (type); // The Insert Type xssfrow. createcell (1 ). setcellvalue (title); // insert question stem xssfrow. createcell (2 ). setcellvalue (option); // insert option xssfrow. createcell (3 ). setcellvalue (answer); // Insert the answer xssfrow. createcell (4 ). setcellvalue (remark); // insert xssfrow. createcell (5 ). setcellvalue (complexity); // insert difficulty xssfrow. createcell (6 ). setcellvalue (score); // Insert the score hssfcellstyle cellstyle = xssfworkbook. createcellstyle (); hssffont font = xssfworkbook. createfont (); font. setfontheightinpoints (short) 11); cellstyle. setfont (font); cellstyle. setalignment (hssfcellstyle. align_justify); cellstyle. setverticalignment (hssfcellstyle. vertical_center); setcellstyle (cellstyle, xssfrow); fileoutputstream OS = new fileoutputstream (exportexcelpath + filename + ". xls "); xssfworkbook. write (OS); fileinputstream. close (); OS. close ();
public static void setCellStyle(HSSFCellStyle cellStyle, HSSFRow row) { for (int i = 0; i < row.getLastCellNum(); i++) { Cell cell = row.getCell(i); cell.setCellStyle(cellStyle); } }
Append data to excel