Java Export Excel three headers

1. Background of the problem

When you export an Excel table in Java, there are three table headers, that is, multiple header Excel

2. Realize the source code

/** * * @Project: report * @Title: Threehead.java * @Package: Com.you.excel * @Description: * @Author: Youhaidong * @Date: 201 5 November 4 pm 3:10:12 * @Version: */package com.you.excel;import Java.io.fileoutputstream;import Org.apache.poi.hssf.usermodel.hssfcell;import Org.apache.poi.hssf.usermodel.hssfrichtextstring;import Org.apache.poi.hssf.usermodel.hssfrow;import Org.apache.poi.hssf.usermodel.hssfsheet;import Org.apache.poi.hssf.usermodel.hssfworkbook;import org.apache.poi.hssf.util.region;/** * <p> export three-head excel</p > * @ClassName: Threehead * @Description: * @Author: Youhaidong * @Date: November 4, 2015 PM 3:10:12 * */public class Threehead {/** * Export three Header table * @Title: Threehead * @Description: * @param args * @Date: November 4, 2015 PM 3:10:12 * @return: void * @throws Ex Ception */@SuppressWarnings ({"Resource", "deprecation"}) public static void main (string[] args) throws exception{// Create Workbook Hssfworkbook workbook = new Hssfworkbook (); Create sheet page Hssfsheet sheet = workbook.createsheet ("Student table"); //Create cell Hssfrow row = sheet.createrow (0); Hssfcell C0 = Row.createcell (0); C0.setcellvalue (New Hssfrichtextstring ("Year")); Hssfcell C1 = Row.createcell (1); C1.setcellvalue (New Hssfrichtextstring ("School of Computer")); Hssfcell C2 = Row.createcell (7); C2.setcellvalue (New Hssfrichtextstring ("Logistics Academy")); Hssfcell C3 = Row.createcell (13); C3.setcellvalue (New Hssfrichtextstring ("Faculty of Administration")); Hssfrow row1 = Sheet.createrow (1); Hssfcell C6 = Row1.createcell (1); C6.setcellvalue (New hssfrichtextstring ("one Shift")); Hssfcell c7 = Row1.createcell (3); C7.setcellvalue (New Hssfrichtextstring ("Class II")); Hssfcell C8 = Row1.createcell (5); C8.setcellvalue (New Hssfrichtextstring ("three shifts")); Hssfcell C9 = Row1.createcell (7); C9.setcellvalue (New hssfrichtextstring ("one Shift")); Hssfcell C10 = Row1.createcell (9); C10.setcellvalue (New Hssfrichtextstring ("Class II")); Hssfcell C11 = Row1.createcell (11); C11.setcellvalue (New Hssfrichtextstring ("three shifts")); Hssfcell C12 = Row1.createcell (13); C12.setcellvalue (New hssfrichtextstring ("one Shift")); Hssfcell C13 = row1.creatEcell (15); C13.setcellvalue (New Hssfrichtextstring ("Class II")); Hssfcell C14 = Row1.createcell (17); C14.setcellvalue (New Hssfrichtextstring ("three shifts")); Hssfrow row2 = Sheet.createrow (2); Hssfcell C15 = Row2.createcell (1); C15.setcellvalue (New Hssfrichtextstring ("last Semester")); Hssfcell C16 = Row2.createcell (2); C16.setcellvalue (New Hssfrichtextstring ("Next semester")); Hssfcell C17 = Row2.createcell (3); C17.setcellvalue (New Hssfrichtextstring ("last Semester")); Hssfcell C18 = Row2.createcell (4); C18.setcellvalue (New Hssfrichtextstring ("Next semester")); Hssfcell C19 = Row2.createcell (5); C19.setcellvalue (New Hssfrichtextstring ("last Semester")); Hssfcell C20 = Row2.createcell (6); C20.setcellvalue (New Hssfrichtextstring ("Next semester")); Hssfcell C21 = Row2.createcell (7); C21.setcellvalue (New Hssfrichtextstring ("last Semester")); Hssfcell C22 = Row2.createcell (8); C22.setcellvalue (New Hssfrichtextstring ("Next semester")); Hssfcell c23 = Row2.createcell (9); C23.setcellvalue (New Hssfrichtextstring ("last Semester")); Hssfcell C24 = Row2.createcell (10); C24.setcellvalue (New Hssfrichtextstring ("Next semester")); Hssfcell C25 = Row2.createcell (11); C25.setcellvalue (New Hssfrichtextstring ("last Semester")); Hssfcell c26 = Row2.createcell (12); C26.setcellvalue (New Hssfrichtextstring ("Next semester")); Hssfcell c27 = Row2.createcell (13); C27.setcellvalue (New Hssfrichtextstring ("last Semester")); Hssfcell C28 = Row2.createcell (14); C28.setcellvalue (New Hssfrichtextstring ("Next semester")); Hssfcell c29 = Row2.createcell (15); C29.setcellvalue (New Hssfrichtextstring ("last Semester")); Hssfcell C30 = Row2.createcell (16); C30.setcellvalue (New Hssfrichtextstring ("Next semester")); Hssfcell C31 = Row2.createcell (17); C31.setcellvalue (New Hssfrichtextstring ("last Semester")); Hssfcell C32 = Row2.createcell (18); C32.setcellvalue (New Hssfrichtextstring ("Next semester")); Region Region1 = new Region (0, (short) 0, 2, (short) 0); Region Region2 = new Region (0, (short) 1, 0, (short) 6); Region Region3 = new Region (0, (short) 7, 0, (short) 12); Region Region4 = new Region (0, (short) of 0, (short) 18); Region Region5 = new Region (1, (short) 1, 1, (short) 2); Region Region6 = new Region (1, (short) 3, 1, (short) 4); Region region7 = new Region (1, (short) 5, 1, (short) 6); Region Region8 = new Region (1, (short) 7, 1, (short) 8); Region Region9 = new Region (1, (short) 9, 1, (short) 10); Region Region10 = new Region (1, (short) One, 1, (short) 12); Region Region11 = new Region (1, (short) of 1, (short) 14); Region Region12 = new Region (1, (short) at 1, (short) 16); Region Region13 = new Region (1, (short) of 1, (short) 18); Sheet.addmergedregion (Region1); Sheet.addmergedregion (Region2); Sheet.addmergedregion (Region3); Sheet.addmergedregion (REGION4); Sheet.addmergedregion (REGION5); Sheet.addmergedregion (REGION6); Sheet.addmergedregion (region7); Sheet.addmergedregion (REGION8); Sheet.addmergedregion (REGION9); Sheet.addmergedregion (REGION10); Sheet.addmergedregion (REGION11); Sheet.addmergedregion (REGION12); Sheet.addmergedregion (REGION13); FileOutputStream stream = new FileOutputStream ("D:/student.xls"); Workbook.write (stream);}}

3. Achieve Results

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Java Export Excel three headers