List of usage examples for org.apache.poi.hssf.util CellReference CellReference
public CellReference(String cellRef)
From source file:ADP_Streamline.MatrixReader.java
public String CellIteration(XSSFSheet sheet, String columnletter, int rownum, int columncount, int rowcount) throws Exception { if (columncount > 0) { int column = (int) columnletter.charAt(0) + columncount; columnletter = Character.toString((char) column); }/*from w ww .j a va 2 s. com*/ CellReference cr = new CellReference(columnletter + (rownum + rowcount)); Row row = sheet.getRow(cr.getRow()); String Roles = row.getCell(cr.getCol()).getStringCellValue(); return Roles; }
From source file:com.accenture.bean.PlanoExcel.java
public void extraiPlanilha() { try {//from ww w. ja v a 2 s . co m //Leitura FileInputStream arquivo = new FileInputStream(new File(fileName)); // Carregando workbook XSSFWorkbook wb = new XSSFWorkbook(arquivo); // Selecionando a primeira aba XSSFSheet s = wb.getSheetAt(1); // Caso queira pegar valor por referencia CellReference cellReference = new CellReference("M8"); Row row = s.getRow(cellReference.getRow()); Cell cell = row.getCell(cellReference.getCol()); System.out.println("Valor Refe:" + cell.getStringCellValue()); // Fazendo um loop em todas as linhas for (Row rowFor : s) { // FAzendo loop em todas as colunas for (Cell cellFor : rowFor) { try { // Verifica o tipo de dado if (cellFor.getCellType() == Cell.CELL_TYPE_NUMERIC) { // Na coluna 6 tenho um formato de data if (cellFor.getColumnIndex() == 6) { // Se estiver no formato de data if (DateUtil.isCellDateFormatted(cellFor)) { // Formatar para o padrao brasileiro Date d = cellFor.getDateCellValue(); DateFormat df = new SimpleDateFormat("dd/MM/yyyy"); System.out.println(df.format(d)); } } else { // Mostrar numerico System.out.println(cellFor.getNumericCellValue()); } } else { // Mostrar String System.out.println(cellFor.getStringCellValue()); } } catch (Exception e) { // Mostrar Erro System.out.println(e.getMessage()); } } // Mostrar pulo de linha System.out.println("------------------------"); } } catch (Exception e) { e.printStackTrace(); } }
From source file:com.synct.report.bm10101_1.java
public void printPageBody(int k, String[] data1, int rowno) throws IOException { try {/*from ww w . j a v a 2s .c o m*/ //[J CellReference cellReference = new CellReference("J13"); 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 LANNO row = sheet.getRow(5); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[6], cell1); //G6 ADDR row = sheet.getRow(6); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[7], cell1); //G7 USE_CATEGORY_CODE_DESC row = sheet.getRow(7); cell1 = row.getCell((short) (9)); setBig5CellValue(data1[8], cell1); //J8 AREA_ARC row = sheet.getRow(7); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[9], cell1); //X8 AREA_OTHER row = sheet.getRow(8); cell1 = row.getCell((short) (9)); setBig5CellValue(data1[10], cell1); //J9 AREA_SHRINK row = sheet.getRow(8); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[11], cell1); //X9 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(9); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[12], cell1); //G10 USAGE_CODE_DESC row = sheet.getRow(10); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[13], cell1); //G11 BUILDING_CATEGORY row = sheet.getRow(10); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[14], cell1); //X11 CHWANG DONG row = sheet.getRow(10); cell1 = row.getCell((short) (31)); setBig5CellValue(data1[15], cell1); //AF11 BUILD_HIHIGHT row = sheet.getRow(11); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[15], cell1); //G12 BUILDING_KIND_DESC row = sheet.getRow(11); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[16], cell1); //X12 BUILDING_HEIGHT row = sheet.getRow(11); cell1 = row.getCell((short) (31)); setBig5CellValue(data1[17], cell1); //AF12 BUILD_HIHIGHT row = sheet.getRow(12); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[19], cell1); //X13 LAW_COVER_RATE row = sheet.getRow(12); cell1 = row.getCell((short) (31)); setBig5CellValue(data1[18], cell1); //AF13 SPACE_RATE row = sheet.getRow(12); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[20], cell1); //G13 BASE_AREA_TOTAL // row = sheet.getRow(12); // cell1 =row.getCell((short)(23)); // setBig5CellValue(data1[20],cell1); //X13 BUILD_COVER_RATE row = sheet.getRow(13); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[21], cell1); //J14 TOTAL_CONSTRU_AREA row = sheet.getRow(14); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[22], cell1); //J15 STATUTORY_OPEN_SPACE row = sheet.getRow(13); cell1 = row.getCell((short) (26)); setBig5CellValue(data1[23], cell1); //AA14 AIRRAID_U_AREA row = sheet.getRow(14); cell1 = row.getCell((short) (26)); setBig5CellValue(data1[24], cell1); //AA15 AIRRAID_D_AREA row = sheet.getRow(16); cell1 = row.getCell((short) (2)); setBig5CellValue(data1[25], cell1); //C17 PARK_SUM1 row = sheet.getRow(16); cell1 = row.getCell((short) (9)); setBig5CellValue(data1[26], cell1); //J17 PARK_SUM3 row = sheet.getRow(16); cell1 = row.getCell((short) (16)); setBig5CellValue(data1[27], cell1); //Q17 PARK_SUM2 row = sheet.getRow(16); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[28], cell1); //X17 PARK_SUM row = sheet.getRow(16); cell1 = row.getCell((short) (29)); setBig5CellValue(data1[29], cell1); //AD17 PARK_ row = sheet.getRow(17); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[30], cell1); //G18 OTHERS_NAME row = sheet.getRow(18); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[31], cell1); //G19 PRICE row = sheet.getRow(19); cell1 = row.getCell((short) (24)); setBig5CellValue(data1[32], cell1); //Y20 VALID_MONTH row = sheet.getRow(20); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[33], cell1); //G21 APPROVE_LICE_DATE row = sheet.getRow(20); cell1 = row.getCell((short) (24)); setBig5CellValue(data1[34], cell1); //Y21 RECEIVE_LICE_DATE row = sheet.getRow(36); cell1 = row.getCell((short) (1)); setBig5CellValue("W " + data1[1], cell1); //B37 P01_NAME row = sheet.getRow(40); cell1 = row.getCell((short) (15)); setBig5CellValue(data1[35], cell1); //P41 IDENTIFY_LICE_DATE row = sheet.getRow(21); cell1 = row.getCell((short) (0)); setBig5CellValue(data1[36], cell1); //A22 PUBLIC_CODE row = sheet.getRow(21); cell1 = row.getCell((short) (19)); setBig5CellValue(data1[37], cell1); //T22 BASE_AREA_PURPOSE } catch (Exception e) { System.err.println("bm10101_1:printPageBody error is " + e); } }
From source file:com.synct.report.cm40101.java
public void printPageBody() throws IOException { try {/* w ww .ja v a 2s . c o m*/ //HSSFRow row = sheet.getRow(rowno); //HSSFCell cell1 =null; System.out.println("Start to write excel"); //System.out.println(data.get(0)); System.out.println(data.get(1)); System.out.println(data.get(2)); System.out.println(data.get(3)); CellReference cellReference = new CellReference("G3"); HSSFRow row = sheet.getRow(cellReference.getRow()); HSSFCell cell = row.getCell(cellReference.getCol()); // setBig5CellValue(data.get(1), cell); //cell.setCellValue( data.get(1) ); cellReference = new CellReference("G63"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(1), cell); cellReference = new CellReference("G123"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(1), cell); cellReference = new CellReference("G183"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(1), cell); cellReference = new CellReference("V3"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("V63"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("V123"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("V183"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AM3"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AM63"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AM123"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AM183"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F4"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F64"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F124"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F184"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AM4"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AM64"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AM124"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AM184"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("U6"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("U66"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("U126"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("U186"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); //cell.setCellValue( "\u7f85\u5ef7\u4e2d\u5e25\u54e5" ); cellReference = new CellReference("U8"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(5)); cellReference = new CellReference("U68"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(5)); cellReference = new CellReference("U128"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(5)); cellReference = new CellReference("U188"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(5)); cellReference = new CellReference("U10"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(3)); cellReference = new CellReference("U70"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(3)); cellReference = new CellReference("U130"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(3)); cellReference = new CellReference("U190"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(3)); cellReference = new CellReference("U12"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U72"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U132"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U192"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U14"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U74"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U134"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U194"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U14"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U74"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U134"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U194"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(4)); cellReference = new CellReference("U16"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(6)); cellReference = new CellReference("U76"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(6)); cellReference = new CellReference("U136"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(6)); cellReference = new CellReference("U196"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(6)); cellReference = new CellReference("U18"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U78"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U138"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U198"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U20"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U80"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U140"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U200"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U22"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U82"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U142"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U202"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U22"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U82"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U142"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U202"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U26"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U86"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U146"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U206"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U30"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U90"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U150"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("U210"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); cell.setCellValue(data.get(8)); cellReference = new CellReference("AU6"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU66"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU126"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU186"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU7"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU67"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU127"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU187"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AJ8"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AJ68"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AJ128"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AJ188"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU8"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU68"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU128"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU188"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU9"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU69"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU129"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU189"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU10"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU70"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU130"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU190"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG14"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG74"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG134"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG194"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG16"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG76"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG136"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG196"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG18"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG78"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG138"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG198"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG20"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG80"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG140"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG200"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL22"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL82"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL142"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL202"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL25"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL85"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL145"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL205"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL28"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL88"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL148"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL208"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL31"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL91"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL151"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL211"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B34"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B94"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B154"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B214"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("M34"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("M94"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("M154"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("M214"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD34"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD94"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD154"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD214"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("H35"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("H95"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("H155"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("H215"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B36"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B96"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B156"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B216"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("G36"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("G96"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("G156"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("G216"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B37"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B97"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B157"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B217"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AN37"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AN97"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AN157"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AN217"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AS37"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AS97"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AS157"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AS217"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AR40"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AR100"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AR160"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AR220"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU41"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU101"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU161"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU221"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B43"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B103"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B163"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B223"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B44"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B104"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B164"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B224"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F44"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F104"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F164"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F224"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("H45"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("H105"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("H165"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("H225"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Y45"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Y105"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Y165"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Y225"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F46"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F106"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F166"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F226"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B47"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B107"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B167"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("B227"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AN47"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AN107"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AN167"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AN227"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AS47"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AS107"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AS167"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AS227"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AR48"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AR108"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AR168"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AR228"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU49"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU109"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU169"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU229"); row = sheet.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); //cell1 = row.getCell((short)(0)); //setBig5CellValue(data1[0],cell1); //cell1 = row.getCell((short)(1)); //setBig5CellValue(data1[1],cell1); //cell1 = row.getCell((short)(31)); //setBig5CellValue(data1[2],cell1); } catch (Exception e) { System.err.println("cm40101:printPageBody error is " + e); } }
From source file:com.synct.report.cm40101.java
public void printPageBody2() throws IOException { try {/* ww w. j a v a2 s.co m*/ CellReference cellReference = new CellReference("J3"); HSSFRow row = sheet2.getRow(cellReference.getRow()); HSSFCell cell = row.getCell(cellReference.getCol()); // setBig5CellValue(data.get(1), cell); //cell.setCellValue( data.get(1) ); cellReference = new CellReference("J43"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(1), cell); cellReference = new CellReference("Q3"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q43"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("W3"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("W43"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG3"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AG43"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL3"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AL43"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AS3"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AS43"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BA3"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BA43"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J4"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J44"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AT4"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AT44"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BD4"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BD44"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AT5"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AT45"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J6"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J46"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J7"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J47"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU6"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU46"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AY6"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AY46"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BH6"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BH46"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU7"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AU47"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AY7"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AY47"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BH7"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BH47"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J8"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J48"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("V8"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("V48"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AT8"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AT48"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J10"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J50"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("S10"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("S50"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("S10"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("S50"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AB10"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AB50"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AK10"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AK50"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AT10"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AT50"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J11"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J51"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AB11"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AB51"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AK11"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AK51"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AQ11"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AQ51"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("D14"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("D54"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J14"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("J54"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("P14"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("P54"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("V14"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("V54"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AB14"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AB54"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AH14"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AH54"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AN14"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AN54"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BB14"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BB54"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("W15"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("W55"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("W16"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("W56"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE17"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE57"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE18"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE58"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE19"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE59"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE20"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE60"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE21"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE61"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE22"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE62"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE23"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE63"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE24"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE64"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("A27"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BE67"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AW33"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AW73"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BB33"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BB73"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BH33"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("BH73"); row = sheet2.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); } catch (Exception e) { System.err.println("cm40101:printPageBody2 error is " + e); } }
From source file:com.synct.report.cm40101.java
public void printPageBody3() throws IOException { try {/* w w w.ja v a 2 s . c om*/ CellReference cellReference = new CellReference("E3"); HSSFRow row = sheet3.getRow(cellReference.getRow()); HSSFCell cell = row.getCell(cellReference.getCol()); // setBig5CellValue(data.get(1), cell); cellReference = new CellReference("E43"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("E83"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("E123"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("I3"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("I43"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("I83"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("I123"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("T3"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("T43"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("T83"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("T123"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("X3"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("X43"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("X83"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("X123"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AE3"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AE43"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AE83"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AE123"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F5"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F45"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F85"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F125"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F6"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F46"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F86"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F126"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F7"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F47"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F87"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F127"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F8"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F48"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F88"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F128"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F9"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F49"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F89"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F129"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F10"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F50"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F90"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F130"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F11"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F51"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F91"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F131"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F12"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F52"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F92"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F132"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F13"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F53"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F93"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F133"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F14"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F54"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F94"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F134"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F15"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F55"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F95"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F135"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F16"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F56"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F96"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F136"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F17"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F57"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F97"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F137"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F18"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F58"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F98"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F138"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F19"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F59"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F99"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F139"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F20"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F60"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F100"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F140"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F21"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F61"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F101"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F141"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F22"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F62"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F102"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F142"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F23"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F63"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F103"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("F143"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q6"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q46"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q86"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q126"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q7"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q8"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q9"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q10"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD6"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD7"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD8"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD9"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD10"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q12"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q13"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q14"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q15"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q16"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q17"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD12"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD13"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD14"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD15"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD16"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD17"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q19"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q20"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q21"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q22"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q23"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD19"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD20"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD21"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD22"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AD23"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("A25"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q25"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("W25"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Q26"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("W26"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("T27"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("T31"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("W32"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("Z32"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); cellReference = new CellReference("AE32"); row = sheet3.getRow(cellReference.getRow()); cell = row.getCell(cellReference.getCol()); setBig5CellValue(data.get(2), cell); } catch (Exception e) { System.err.println("cm40101:printPageBody3 error is " + e); } }
From source file:poi.hssf.usermodel.examples.AddDimensionedImage.java
License:Apache License
/** * Add an image to a worksheet./* w w w . j a v a2s . c o m*/ * * @param cellNumber A String that contains the location of the cell whose * top left hand corner should be aligned with the top * left hand corner of the image; for example "A1", "A2" * etc. This is to support the familiar Excel syntax. * Whilst images are are not actually inserted into cells * this provides a convenient method of indicating where * the image should be positioned on the sheet. * @param sheet A reference to the sheet that contains the cell referenced * above. * @param imageFile A String that encapsulates the name of and path to * the image that is to be 'inserted into' the sheet. * @param reqImageWidthMM A primitive double that contains the required * width of the image in millimetres. * @param reqImageHeightMM A primitive double that contains the required * height of the image in millimetres. * @param resizeBehaviour A primitive int whose value will determine how * the code should react if the image is larger than * the cell referenced by the cellNumber parameter. * Four constants are provided to determine what * should happen; * AddDimensionedImage.EXPAND_ROW * AddDimensionedImage.EXPAND_COLUMN * AddDimensionedImage.EXPAND_ROW_AND_COLUMN * AddDimensionedImage.OVERLAY_ROW_AND_COLUMN * @throws java.io.FileNotFoundException If the file containing the image * cannot be located. * @throws java.io.IOException If a problem occurs whilst reading the file * of image data. * @throws IllegalArgumentException If an invalid value is passed * to the resizeBehaviour * parameter. */ public void addImageToSheet(String cellNumber, HSSFSheet sheet, String imageFile, double reqImageWidthMM, double reqImageHeightMM, int resizeBehaviour) throws IOException, IllegalArgumentException { // Convert the String into column and row indices then chain the // call to the overridden addImageToSheet() method. CellReference cellRef = new CellReference(cellNumber); this.addImageToSheet(cellRef.getCol(), cellRef.getRow(), sheet, imageFile, reqImageWidthMM, reqImageHeightMM, resizeBehaviour); }
From source file:POS.migrate.Excel_to_db_inventory_items.java
public static List<Excel_to_db_inventory_items> showExcelData(List sheetData, String path) { FileInputStream fis;//from w w w.ja va2 s .c o m List<Excel_to_db_inventory_items> datas = new ArrayList(); try { fis = new FileInputStream(path); int r = 0; int r_set = 1; int id = 0; for (int i = 0; i < sheetData.size(); i++) { List list = (List) sheetData.get(i); int size = list.size(); String[] record = new String[12]; int record_size = 0; for (int j = 0; j < list.size(); j++) { CellReference cellReference = new CellReference("B3"); HSSFCell cell = (HSSFCell) list.get(j); HSSFDataFormatter hdf = new HSSFDataFormatter(); String data = ""; if (j >= 12) { break; } if (j == 1 || j == 4 || j == 5) { try { data = "" + cell.getNumericCellValue(); } catch (Exception e) { data = "" + cell.getStringCellValue(); } } else { try { data = "" + cell.getStringCellValue(); } catch (Exception e) { data = "" + cell.getNumericCellValue(); } } record[record_size] = data; // System.out.print(data + " | "); record_size++; } String qty = record[0]; String item_code = record[1]; String barcode = record[2]; String description = record[3]; String cost = record[4]; String selling_price = record[5]; String category = record[6]; String classification = record[7]; String sub_classification = record[8]; String brand = record[9]; String model = record[10]; String unit = record[11]; System.out.println("model:" + model); System.out.println("unit:" + unit); Excel_to_db_inventory_items encoded = new Excel_to_db_inventory_items(qty, item_code, barcode, description, cost, selling_price, category, classification, sub_classification, brand, model, unit); if (record[0] != null) { datas.add(encoded); System.out.println(""); } } } catch (FileNotFoundException ex) { Logger.getLogger(Excel_to_db_inventory_items.class.getName()).log(Level.SEVERE, null, ex); } return datas; }
From source file:spires.printing.Encoded_baptism.java
public static List<Encoded_baptism> showExcelData(List sheetData, String path) { FileInputStream fis;/*from w ww . ja v a2 s. co m*/ List<Encoded_baptism> datas = new ArrayList(); try { fis = new FileInputStream(path); int r = 0; int r_set = 1; int id = 0; for (int i = 0; i < sheetData.size(); i++) { List list = (List) sheetData.get(i); int size = list.size(); String[] record = new String[15]; int record_size = 0; for (int j = 0; j < list.size(); j++) { CellReference cellReference = new CellReference("B3"); HSSFCell cell = (HSSFCell) list.get(j); HSSFDataFormatter hdf = new HSSFDataFormatter(); String data = ""; if (j >= 14) { break; } if (cell.getCellType() == 0) { if (j == 5 || j == 8) { data = "" + DateType.sf.format(getRoundedDate(cell.getNumericCellValue())) + ""; } else { data = "" + cell.getNumericCellValue(); } } else { data = cell.getStringCellValue(); } record[record_size] = data; // System.out.print(data + " | "); record_size++; } // System.out.println(""); Date d = getRoundedDate(FitIn.toDouble(record[3])); String da = DateType.sf.format(d); int page_no = FitIn.toInt(record[0]); int index_no = FitIn.toInt(record[1]); String fname = record[2]; String mi = record[3]; String lname = record[4]; String date_of_baptism = record[5]; String parish_priest = record[6]; String minister = record[7]; String date_of_birth = record[8]; String place_of_birth = record[9]; String place_of_baptism = ""; String father = record[10]; String mother = record[11]; String sponsors = record[12]; String remarks = record[13]; if (page_no != 0) { if (fname.equalsIgnoreCase("n/a")) { fname = ""; } if (mi.equalsIgnoreCase("n/a")) { mi = ""; } if (lname.equalsIgnoreCase("n/a")) { lname = ""; } if (parish_priest.equalsIgnoreCase("n/a")) { parish_priest = ""; } if (minister.equalsIgnoreCase("n/a")) { minister = ""; } if (place_of_birth.equalsIgnoreCase("n/a")) { place_of_birth = ""; } if (place_of_baptism.equalsIgnoreCase("n/a")) { place_of_baptism = ""; } if (father.equalsIgnoreCase("n/a")) { father = ""; } if (mother.equalsIgnoreCase("n/a")) { mother = ""; } if (sponsors.equalsIgnoreCase("n/a")) { sponsors = ""; } if (remarks.equalsIgnoreCase("n/a")) { remarks = ""; } Encoded_baptism to = new Encoded_baptism(page_no, index_no, fname, mi, lname, date_of_baptism, parish_priest, minister, date_of_birth, place_of_birth, place_of_baptism, father, mother, sponsors, remarks); datas.add(to); } } } catch (FileNotFoundException ex) { Logger.getLogger(Encoded_Funeral.class.getName()).log(Level.SEVERE, null, ex); } return datas; }
From source file:spires.printing.Encoded_Funeral.java
public static List<to_encoded> showExcelData(List sheetData, String path) { FileInputStream fis;// w w w.jav a 2 s . c o m List<to_encoded> datas = new ArrayList(); try { fis = new FileInputStream(path); int r = 0; int r_set = 1; int id = 0; for (int i = 0; i < sheetData.size(); i++) { List list = (List) sheetData.get(i); int size = list.size(); String[] record = new String[11]; int record_size = 0; for (int j = 0; j < list.size(); j++) { CellReference cellReference = new CellReference("B3"); HSSFCell cell = (HSSFCell) list.get(j); HSSFDataFormatter hdf = new HSSFDataFormatter(); String data = ""; if (j >= 11) { break; } if (j >= 0 && j <= 2 || j == 7 || j == 10) { data = "" + cell.getNumericCellValue(); } else if (j == 7 || j == 10) { data = "" + DateType.sf.format(getRoundedDate(cell.getNumericCellValue())) + ""; } else { data = cell.getStringCellValue(); } record[record_size] = data; System.out.print(data + " | "); record_size++; } String index_no = record[0]; String book_no = record[1]; String page_no = record[2]; String date_of_burial = record[7]; String price = record[9]; String fname = record[3]; String mi = record[4]; String lname = record[5]; String residence = record[8]; String informant = record[6]; String remarks = ""; String parents = record[6]; String date_of_burial2 = record[10]; to_encoded t = new to_encoded(index_no, book_no, page_no, date_of_burial, price, fname, mi, lname, residence, informant, remarks, parents, date_of_burial2, 0); if (record[0] != null) { datas.add(t); System.out.println(""); } } } catch (FileNotFoundException ex) { Logger.getLogger(Encoded_Funeral.class.getName()).log(Level.SEVERE, null, ex); } return datas; }