Example usage for org.apache.poi.hssf.usermodel HSSFRow getCell

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFRow getCell.

Prototype

@Override
public HSSFCell getCell(int cellnum) 

Source Link

Document

Get the hssfcell representing a given column (logical cell) 0-based.

Usage

From source file:com.synct.report.bm10101_2.java

private void printHeader(String[] wherestring) throws Exception {
    //gX//  w ww  .  java  2s  .c  om
    HSSFRow pageRow = sheet.getRow(page * page_rows);
    HSSFCell pageCell = pageRow.getCell((short) 1);

    pageRow = sheet.getRow(page * page_rows + 1);
    pageCell = pageRow.getCell((short) 0);

    setBig5CellValue(
            "XG" + Utils.convertToString(
                    DBTools.dLookUp("LM_LICNUM", "LICENSEMEMO", "SEQ=" + wherestring[0], "SynctConn")),
            pageCell);
}

---

From source file:com.synct.report.bm10101_2.java

private void printFoot(String printpage) throws Exception {
    //gX/*from   w  w w. ja v a 2s .  co m*/
    HSSFRow pageRow = sheet.getRow((page * page_rows) + 13);
    HSSFCell pageCell = pageRow.getCell((short) 0);
    setBig5CellValue(printpage, pageCell);

}

---

From source file:com.synct.report.bm10101_2.java

public void printPageBody(int k, String[] data1, int rowno) throws IOException {
    try {/*from   w ww.  ja  v  a 2  s .  c  o  m*/
        //[J
        HSSFRow row = sheet.getRow(0);
        HSSFCell cell1 = row.getCell((short) (20));
        setBig5CellValue(data1[15], cell1); //U1 LICENSE_DESC

        row = sheet.getRow(1);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[11], cell1); //G2 P01_NAME

        row = sheet.getRow(2);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[12], cell1); //G3 ADDR

        row = sheet.getRow(3);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[13], cell1); //G4 P02_NAME

        row = sheet.getRow(3);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[14], cell1); //X4 OFFICE_NAME

        row = sheet.getRow(4);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[10], cell1); //G5 LANNO

        row = sheet.getRow(5);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[12], cell1); //G6 ADDR

        row = sheet.getRow(6);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[9], cell1); //G7 USE_CATEGORY_CODE_DESC

        row = sheet.getRow(7);
        cell1 = row.getCell((short) (9));
        setBig5CellValue(data1[0] + "T", cell1); //J8 AREA_ARC

        row = sheet.getRow(7);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[2] + "T", cell1); //X8 AREA_OTHER

        row = sheet.getRow(8);
        cell1 = row.getCell((short) (9));
        setBig5CellValue(data1[1] + "T", cell1); //J9 AREA_SHRINK

        row = sheet.getRow(8);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[3] + "T", cell1); //X9 AREA_TOTAL

        row = sheet.getRow(9);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[4], cell1); //G10 PRICE

        row = sheet.getRow(10);
        cell1 = row.getCell((short) (24));
        setBig5CellValue(data1[6], cell1); //Y11 VALID_MONTH

        row = sheet.getRow(11);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[7], cell1); //G12 APPROVE_LICE_DATE

        row = sheet.getRow(11);
        cell1 = row.getCell((short) (24));
        setBig5CellValue(data1[8], cell1); //Y12 RECEIVE_LICE_DATE

        row = sheet.getRow(36);
        cell1 = row.getCell((short) (1));
        setBig5CellValue("W    " + data1[11], cell1); //B37 P01_NAME

        row = sheet.getRow(40);
        cell1 = row.getCell((short) (15));
        setBig5CellValue(data1[16], cell1); //P41 IDENTIFY_LICE_DATE

        row = sheet.getRow(12);
        cell1 = row.getCell((short) (0));
        setBig5CellValue("u@G", cell1); //A13
        int j = 0;
        for (int i = 0; i < data_other.length; i++) { //A14 A15 A16 A17 A18
            row = sheet.getRow(13 + i);
            cell1 = row.getCell((short) (0));
            setBig5CellValue(data_other[i], cell1);
            j = i;
            if (StringUtils.isEmpty(data_other[i]))
                break;

        }

        row = sheet.getRow(15 + j);
        cell1 = row.getCell((short) (0));
        setBig5CellValue("HU", cell1); //

    } catch (Exception e) {
        System.err.println("bm10101_2:printPageBody error is " + e);
    }

}

---

From source file:com.synct.report.bm10101_2.java

public void printPageBody1(int k, String[] data1, int rowno) throws IOException {
    try {/*from  www  .  java  2s  .  c o m*/

        HSSFRow row = sheet1.getRow(1);
        HSSFCell cell1 = row.getCell((short) (0));
        setBig5CellValue("u@G", cell1); //A2

        row = sheet1.getRow(0);
        cell1 = row.getCell((short) (21));
        setBig5CellValue(data1[15], cell1); //V1

        int j = 0;
        for (int i = 0; i < data_other.length; i++) { //A14 A15 A16 A17 A18
            row = sheet1.getRow(2 + i);
            cell1 = row.getCell((short) (0));
            setBig5CellValue(data_other[i], cell1);
            j = i;
            if (StringUtils.isEmpty(data_other[i]))
                break;

        }

        row = sheet1.getRow(3 + j);
        cell1 = row.getCell((short) (0));
        setBig5CellValue("HU", cell1); //        

    } catch (Exception e) {
        System.err.println("bm10101_2:printPageBody error is " + e);
    }

}

---

From source file:com.synct.report.bm10101_2.java

public void printPageBody2(int k, String[] data1, int rowno) throws IOException {
    try {//  w  w  w  . jav a2 s .co m
        //[J
        HSSFRow row = sheet2.getRow(1);
        HSSFCell cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[11], cell1); //G2 P01_NAME

        row = sheet2.getRow(0);
        cell1 = row.getCell((short) (20));
        setBig5CellValue(data1[15], cell1); //U1 LICENSE_DESC

        row = sheet2.getRow(2);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[12], cell1); //G3 ADDR

        row = sheet2.getRow(3);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[13], cell1); //G4 P02_NAME

        row = sheet2.getRow(3);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[14], cell1); //X4 OFFICE_NAME

        row = sheet2.getRow(4);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[10], cell1); //G5 LANNO

        row = sheet2.getRow(5);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[12], cell1); //G6 ADDR

        row = sheet2.getRow(6);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[9], cell1); //G7 USE_CATEGORY_CODE_DESC

        row = sheet2.getRow(7);
        cell1 = row.getCell((short) (9));
        setBig5CellValue(data1[0] + "T", cell1); //J8 AREA_ARC

        row = sheet2.getRow(7);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[2] + "T", cell1); //X8 AREA_OTHER

        row = sheet2.getRow(8);
        cell1 = row.getCell((short) (9));
        setBig5CellValue(data1[1] + "T", cell1); //J9 AREA_SHRINK

        row = sheet2.getRow(8);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[3] + "T", cell1); //X9 AREA_TOTAL

        row = sheet2.getRow(9);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[4], cell1); //G10 PRICE

        row = sheet2.getRow(10);
        cell1 = row.getCell((short) (24));
        setBig5CellValue(data1[6], cell1); //Y11 VALID_MONTH

        row = sheet2.getRow(11);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[7], cell1); //G12 APPROVE_LICE_DATE

        row = sheet2.getRow(11);
        cell1 = row.getCell((short) (24));
        setBig5CellValue(data1[8], cell1); //Y12 RECEIVE_LICE_DATE

        //row = sheet2.getRow(36);
        //cell1 =row.getCell((short)(1));
        //setBig5CellValue("W    "+data1[11],cell1);  //B37 P01_NAME

        //row = sheet2.getRow(40);
        //cell1 =row.getCell((short)(15));
        //setBig5CellValue(data1[16],cell1);  //P41 IDENTIFY_LICE_DATE

        row = sheet2.getRow(12);
        cell1 = row.getCell((short) (0));
        setBig5CellValue("u@G", cell1); //A13
        int j = 0;
        for (int i = 0; i < data_other.length; i++) { //A14 A15 A16 A17 A18
            row = sheet2.getRow(13 + i);
            cell1 = row.getCell((short) (0));
            setBig5CellValue(data_other[i], cell1);
            j = i;
            if (StringUtils.isEmpty(data_other[i]))
                break;
        }

        row = sheet2.getRow(15 + j);
        cell1 = row.getCell((short) (0));
        setBig5CellValue("HU", cell1); //

    } catch (Exception e) {
        System.err.println("sheet2:printPageBody error is " + e);
    }

}

---

From source file:com.synct.report.bm10101_2.java

public void printPageBody3(int k, String[] data1, int rowno) throws IOException {
    try {/*from ww  w  .  jav a 2 s  .  c o  m*/

        HSSFRow row = sheet3.getRow(1);
        HSSFCell cell1 = row.getCell((short) (0));
        setBig5CellValue("u@G", cell1); //A2

        row = sheet3.getRow(0);
        cell1 = row.getCell((short) (21));
        setBig5CellValue(data1[15], cell1); //V1

        int j = 0;
        for (int i = 0; i < data_other.length; i++) { //A14 A15 A16 A17 A18
            row = sheet3.getRow(2 + i);
            cell1 = row.getCell((short) (0));
            setBig5CellValue(data_other[i], cell1);
            j = i;
            if (StringUtils.isEmpty(data_other[i]))
                break;

        }

        row = sheet3.getRow(3 + j);
        cell1 = row.getCell((short) (0));
        setBig5CellValue("HU", cell1); //        

    } catch (Exception e) {
        System.err.println("sheet3:printPageBody error is " + e);
    }

}

---

From source file:com.synct.report.bm10101_3.java

public void printPageBody(int j, String[] data1, int rowno) throws IOException {
    try {//from  w  ww.  j av a2 s  . c om
        //
        HSSFRow row = sheet.getRow(0);
        HSSFCell cell1 = row.getCell((short) (20));
        setBig5CellValue(data1[0], cell1); //U1 LICENSE_DESC

        row = sheet.getRow(1);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[1], cell1); //G2 P01_NAME

        row = sheet.getRow(2);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[2], cell1); //G3 ADDR

        row = sheet.getRow(3);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[3], cell1); //G4 P02_NAME

        row = sheet.getRow(3);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[4], cell1); //X4 OFFICE_NAME

        row = sheet.getRow(4);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[5], cell1); //G5 P03_NAME

        row = sheet.getRow(4);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[6], cell1); //X5 OFFICE_NAME

        row = sheet.getRow(5);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[7], cell1); //G6 P04_NAME

        row = sheet.getRow(5);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[8], cell1); //X6 OFFICE_NAME

        row = sheet.getRow(6);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[9], cell1); //G7 LANNO

        row = sheet.getRow(7);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[10], cell1); //G8 ADDR

        row = sheet.getRow(8);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[11], cell1); //G9 USE_CATEGORY_CODE_DESC

        row = sheet.getRow(9);
        cell1 = row.getCell((short) (9));
        setBig5CellValue(data1[12], cell1); //J10 AREA_ARC

        row = sheet.getRow(9);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[13], cell1); //X10 AREA_OTHER

        row = sheet.getRow(10);
        cell1 = row.getCell((short) (9));
        setBig5CellValue(data1[14], cell1); //J11 AREA_SHRINK

        row = sheet.getRow(10);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[15], cell1); //X11 AREA_TOTAL

        //*****************************************************************************
        /*
        0 1 2 3 4 5 6 7 8 910111213141516171819202122232425 6 7 8 930 1 2 3 4 5 
        A B C D E F G H I J K L M N O P Q R S T U V W X Y ZAAABACADAEAFAGAHAIAJ        
        */
        row = sheet.getRow(11);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[16], cell1); //G12 USAGE_CODE_DESC

        row = sheet.getRow(12);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[17], cell1); //G13 BUILDING_CATEGORY

        row = sheet.getRow(12);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[18], cell1); //X13 CHWANG DONG

        row = sheet.getRow(13);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[19], cell1); //G14 BUILDING_KIND_DESC

        row = sheet.getRow(13);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[20], cell1); //X14 BUILDING_HEIGHT

        row = sheet.getRow(13);
        cell1 = row.getCell((short) (31));
        setBig5CellValue(data1[21], cell1); //AF14 BUILD_HIHIGHT

        row = sheet.getRow(14);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[22], cell1); //G15 BASE_AREA_TOTAL

        row = sheet.getRow(14);
        cell1 = row.getCell((short) (31));
        setBig5CellValue(data1[23], cell1); //X15 LAW_COVER_RATE

        row = sheet.getRow(14);
        cell1 = row.getCell((short) (31));
        setBig5CellValue(data1[24], cell1); //AF15 SPACE_RATE

        row = sheet.getRow(15);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[25], cell1); //J16 TOTAL_CONSTRU_AREA

        row = sheet.getRow(16);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[26], cell1); //J17 STATUTORY_OPEN_SPACE

        row = sheet.getRow(15);
        cell1 = row.getCell((short) (26));
        setBig5CellValue(data1[27], cell1); //AA16 AIRRAID_U_AREA

        row = sheet.getRow(16);
        cell1 = row.getCell((short) (26));
        setBig5CellValue(data1[28], cell1); //AA17 AIRRAID_D_AREA

        row = sheet.getRow(18);
        cell1 = row.getCell((short) (2));
        setBig5CellValue(data1[29], cell1); //C19 PARK_SUM1

        row = sheet.getRow(18);
        cell1 = row.getCell((short) (9));
        setBig5CellValue(data1[30], cell1); //J19 PARK_SUM3

        row = sheet.getRow(18);
        cell1 = row.getCell((short) (16));
        setBig5CellValue(data1[31], cell1); //Q19 PARK_SUM2

        row = sheet.getRow(18);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[32], cell1); //X19 PARK_SUM

        row = sheet.getRow(18);
        cell1 = row.getCell((short) (29));
        setBig5CellValue(data1[33], cell1); //AD19 PARK_

        row = sheet.getRow(19);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[34], cell1); //G20 OTHERS_NAME

        row = sheet.getRow(20);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[35], cell1); //G21 PRICE

        row = sheet.getRow(21);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[36], cell1); //G22 APPROVE_LICE_DATE

        row = sheet.getRow(21);
        cell1 = row.getCell((short) (24));
        setBig5CellValue(data1[37], cell1); //Y22 RECEIVE_LICE_DATE

        row = sheet.getRow(22);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[38], cell1); //G23 BUILD IDENTIFY_LICE_DATE

        row = sheet.getRow(22);
        cell1 = row.getCell((short) (24));
        setBig5CellValue(data1[39], cell1); //Y23 BUILD LICE_DESC

        row = sheet.getRow(23);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[40], cell1); //G24 COMMENCE_DATE

        row = sheet.getRow(23);
        cell1 = row.getCell((short) (24));
        setBig5CellValue(data1[41], cell1); //Y24 COMPLETE_DATE

        row = sheet.getRow(24);
        cell1 = row.getCell((short) (2));
        setBig5CellValue(data1[42], cell1); //C25 PUBLIC_CODE 

        row = sheet.getRow(24);
        cell1 = row.getCell((short) (19));
        setBig5CellValue(data1[43], cell1); //T25 BASE_AREA_PURPOSE 

        row = sheet.getRow(26);
        cell1 = row.getCell((short) (1));
        setBig5CellValue("W    " + data1[1], cell1); //B27 P01_NAME

    } catch (Exception e) {
        System.err.println("bm10101_3:printPageBody error is " + e);
    }

}

---

From source file:com.synct.report.bm10101_3.java

public void printPageBody1(int k, String[] data1, int rowno) throws IOException {
    try {//from ww w  .  j  a  v  a  2s .  c  om

        HSSFRow row = sheet1.getRow(0);
        HSSFCell cell1 = row.getCell((short) (0));
        int j = 0;

        for (int i = 0; i < data_other.size(); i++) {
            row = sheet1.getRow(i); //1+i
            cell1 = row.getCell((short) (0));
            //setBig5CellValue(data_other[i],cell1); 
            setBig5CellValue(data_other.get(i), cell1);
            j = i;
            if (i > 220) {
                System.out.println("bm10101_3 sheet3:data_other.get(i),i= " + i + "," + data_other.get(i));
            }
        }
        row = sheet1.getRow(3 + j);
        cell1 = row.getCell((short) (0));
        setBig5CellValue("HU", cell1); //        

    } catch (Exception e) {
        System.err.println("bm10101_3:printPageBody1 error is " + e);
    }

}

---

From source file:com.synct.report.bm10101_3.java

public void printPageBody2(int j, String[] data1, int rowno) throws IOException {
    try {// w  w  w .j  a va 2s . c o m
        //
        HSSFRow row = sheet2.getRow(0);
        HSSFCell cell1 = row.getCell((short) (20));
        setBig5CellValue(data1[0], cell1); //U1 LICENSE_DESC

        row = sheet2.getRow(1);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[1], cell1); //G2 P01_NAME

        row = sheet2.getRow(2);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[2], cell1); //G3 ADDR

        row = sheet2.getRow(3);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[3], cell1); //G4 P02_NAME

        row = sheet2.getRow(3);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[4], cell1); //X4 OFFICE_NAME

        row = sheet2.getRow(4);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[5], cell1); //G5 P03_NAME

        row = sheet2.getRow(4);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[6], cell1); //X5 OFFICE_NAME

        row = sheet2.getRow(5);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[7], cell1); //G6 P02_NAME

        row = sheet2.getRow(5);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[8], cell1); //X6 OFFICE_NAME

        row = sheet2.getRow(6);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[9], cell1); //G7 LANNO

        row = sheet2.getRow(7);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[10], cell1); //G8 ADDR

        row = sheet2.getRow(8);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[11], cell1); //G9 USE_CATEGORY_CODE_DESC

        row = sheet2.getRow(9);
        cell1 = row.getCell((short) (9));
        setBig5CellValue(data1[12], cell1); //J10 AREA_ARC

        row = sheet2.getRow(9);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[13], cell1); //X10 AREA_OTHER

        row = sheet2.getRow(10);
        cell1 = row.getCell((short) (9));
        setBig5CellValue(data1[14], cell1); //J11 AREA_SHRINK

        row = sheet2.getRow(10);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[15], cell1); //X11 AREA_TOTAL

        //*****************************************************************************
        /*
        0 1 2 3 4 5 6 7 8 910111213141516171819202122232425 6 7 8 930 1 2 3 4 5 
        A B C D E F G H I J K L M N O P Q R S T U V W X Y ZAAABACADAEAFAGAHAIAJ        
        */
        row = sheet2.getRow(11);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[16], cell1); //G12 USAGE_CODE_DESC

        row = sheet2.getRow(12);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[17], cell1); //G13 BUILDING_CATEGORY

        row = sheet2.getRow(12);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[18], cell1); //X13 CHWANG DONG

        row = sheet2.getRow(13);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[19], cell1); //G14 BUILDING_KIND_DESC

        row = sheet2.getRow(13);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[20], cell1); //X14 BUILDING_HEIGHT

        row = sheet2.getRow(13);
        cell1 = row.getCell((short) (31));
        setBig5CellValue(data1[21], cell1); //AF14 BUILD_HIHIGHT

        row = sheet2.getRow(14);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[22], cell1); //G15 BASE_AREA_TOTAL

        row = sheet2.getRow(14);
        cell1 = row.getCell((short) (31));
        setBig5CellValue(data1[23], cell1); //X15 LAW_COVER_RATE

        row = sheet2.getRow(14);
        cell1 = row.getCell((short) (31));
        setBig5CellValue(data1[24], cell1); //AF15 SPACE_RATE

        row = sheet2.getRow(15);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[25], cell1); //J16 TOTAL_CONSTRU_AREA

        row = sheet2.getRow(16);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[26], cell1); //J17 STATUTORY_OPEN_SPACE

        row = sheet2.getRow(15);
        cell1 = row.getCell((short) (26));
        setBig5CellValue(data1[27], cell1); //AA16 AIRRAID_U_AREA

        row = sheet2.getRow(16);
        cell1 = row.getCell((short) (26));
        setBig5CellValue(data1[28], cell1); //AA17 AIRRAID_D_AREA

        row = sheet2.getRow(18);
        cell1 = row.getCell((short) (2));
        setBig5CellValue(data1[29], cell1); //C19 PARK_SUM1

        row = sheet2.getRow(18);
        cell1 = row.getCell((short) (9));
        setBig5CellValue(data1[30], cell1); //J19 PARK_SUM3

        row = sheet2.getRow(18);
        cell1 = row.getCell((short) (16));
        setBig5CellValue(data1[31], cell1); //Q19 PARK_SUM2

        row = sheet2.getRow(18);
        cell1 = row.getCell((short) (23));
        setBig5CellValue(data1[32], cell1); //X19 PARK_SUM

        row = sheet2.getRow(18);
        cell1 = row.getCell((short) (29));
        setBig5CellValue(data1[33], cell1); //AD19 PARK_

        row = sheet2.getRow(19);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[34], cell1); //G20 OTHERS_NAME

        row = sheet2.getRow(20);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[35], cell1); //G21 PRICE

        row = sheet2.getRow(21);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[36], cell1); //G22 APPROVE_LICE_DATE

        row = sheet2.getRow(21);
        cell1 = row.getCell((short) (24));
        setBig5CellValue(data1[37], cell1); //Y22 RECEIVE_LICE_DATE

        row = sheet2.getRow(22);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[38], cell1); //G23 BUILD IDENTIFY_LICE_DATE

        row = sheet2.getRow(22);
        cell1 = row.getCell((short) (24));
        setBig5CellValue(data1[39], cell1); //Y23 BUILD LICE_DESC

        row = sheet2.getRow(23);
        cell1 = row.getCell((short) (6));
        setBig5CellValue(data1[40], cell1); //G24 COMMENCE_DATE

        row = sheet2.getRow(23);
        cell1 = row.getCell((short) (24));
        setBig5CellValue(data1[41], cell1); //Y24 COMPLETE_DATE

        row = sheet2.getRow(24);
        cell1 = row.getCell((short) (2));
        setBig5CellValue(data1[42], cell1); //C25 PUBLIC_CODE 

        row = sheet2.getRow(24);
        cell1 = row.getCell((short) (19));
        setBig5CellValue(data1[43], cell1); //T25 BASE_AREA_PURPOSE 

        row = sheet2.getRow(26);
        cell1 = row.getCell((short) (1));
        setBig5CellValue("W    " + data1[1], cell1); //B27 P01_NAME

    } catch (Exception e) {
        System.err.println("bm10101_3:printPageBody2 error is " + e);
    }

}

---

From source file:com.synct.report.bm10101_3.java

public void printPageBody3(int k, String[] data1, int rowno) throws IOException {
    try {/*w  ww.  j a  va 2s. c o m*/

        HSSFRow row = sheet3.getRow(0);
        HSSFCell cell1 = row.getCell((short) (0));
        int j = 0;
        for (int i = 0; i <= data_other.size(); i++) { //A3 A4 A5 A6 A7   55*5
            row = sheet3.getRow(i); //1+i
            cell1 = row.getCell((short) (0));
            setBig5CellValue(data_other.get(i), cell1);
            j = i;
            if (i > 220) {
                System.out.println("bm10101_3 sheet3:data_other.get(i),i= " + i + "," + data_other.get(i));
            }
        }

        row = sheet3.getRow(3 + j);
        cell1 = row.getCell((short) (0));
        setBig5CellValue("HU", cell1); //        

    } catch (Exception e) {
        System.err.println("bm10101_3:printPageBody3 error is " + e);
    }

}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »