Java generates excel and javaexcel

Java generates excel and javaexcel

Package test. poi; import java. io. file; import java. io. fileOutputStream; import java. io. outputStream; import java. util. arrayList; import java. util. list; import java. util. map; import jxl. workbook; import jxl. format. alignment; import jxl. format. border; import jxl. format. borderLineStyle; import jxl. format. colour; import jxl. format. underlineStyle; import jxl. write. label; import jxl. write. writableCellFormat; import jxl. write. writableFont; import jxl. write. writableSheet; import jxl. write. writableWorkbook; public class createExcel {public static void main (String [] args) {createExcel ();} public static void createExcel () {try {File file = new File ("f: // text.xls "); OutputStream OS = new FileOutputStream (file); WritableWorkbook wwb = Workbook. createWorkbook (OS); WritableSheet ws = wwb. createSheet ("sheet1", 0); // obtain the object set List by month <Map <String, String> list = new ArrayList <Map <String, String> (); // set the cell format WritableFont wf = new WritableFont (WritableFont. ARIAL, 11, WritableFont. BOLD, false, UnderlineStyle. NO_UNDERLINE, Colour. WHITE); WritableCellFormat cellFormat = new WritableCellFormat (wf); cellFormat. setBorder (Border. ALL, BorderLineStyle. THIN, Colour. BLUE_GREY); cellFormat. setAlignment (Alignment. CENTRE); cellFormat. setBackground (Colour. BLUE); // The first line Label label = new Label (0, 0, "Serial Number"); label. setCellFormat (cellFormat); ws. addCell (label); label = new Label (1, 0, "name"); label. setCellFormat (cellFormat); ws. addCell (label); // merge cells ws. mergeCells (2, 0, 3, 0); label = new Label (2, 0, "merge cells"); label. setCellFormat (cellFormat); ws. addCell (label); // The second line label = new Label (0, 1, "1"); ws. addCell (label); label = new Label (1, 1, "name"); ws. addCell (label); label = new Label (2, 1, "merge 1"); ws. addCell (label); label = new Label (3, 1, "merge 2"); ws. addCell (label); // The third line label = new Label (0, 2, "2"); ws. addCell (label); label = new Label (1, 2, "name"); ws. addCell (label); label = new Label (2, 2, "merge 1"); ws. addCell (label); label = new Label (3, 2, "merge 2"); ws. addCell (label); // Add data wwb. write (); wwb. close (); System. out. println ("generated information table (Excel Format) succeeded");} catch (Exception e) {System. out. println ("an error occurred when generating the information table (Excel Format):"); e. printStackTrace ();}}}

To operate excel, you need to use the jar package jxl. jar.