Example usage for org.apache.poi.ss.usermodel Cell setCellStyle

List of usage examples for org.apache.poi.ss.usermodel Cell setCellStyle

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.ss.usermodel.*
  5. Cell
  6. setCellStyle

Introduction

In this page you can find the example usage for org.apache.poi.ss.usermodel Cell setCellStyle.

Prototype

void setCellStyle(CellStyle style);

Source Link

Document

Set the style for the cell.

Usage

From source file:com.griffinslogistics.document.excel.BookLabelGenerator.java

private static void generateHeaders(Sheet sheet, Map<String, CellStyle> styles) {
    Row row0 = sheet.getRow(0);/*from   w  ww. ja  v  a2  s .c  o  m*/
    Row row11 = sheet.getRow(10);

    Cell a1 = row0.createCell(0);
    a1.setCellStyle(styles.get(STYLE_SMALL_FONT));
    Cell b1 = row0.createCell(1);
    b1.setCellStyle(styles.get(STYLE_SMALL_FONT));
    b1.setCellValue(PULSIO_START);

    Cell d1 = row0.createCell(3);
    d1.setCellStyle(styles.get(STYLE_SMALL_FONT));
    Cell e1 = row0.createCell(4);
    e1.setCellStyle(styles.get(STYLE_SMALL_FONT));
    e1.setCellValue(PULSIO_START);

    Cell a11 = row11.createCell(0);
    a11.setCellStyle(styles.get(STYLE_SMALL_FONT));
    Cell b11 = row11.createCell(1);
    b11.setCellStyle(styles.get(STYLE_SMALL_FONT));
    b11.setCellValue(PULSIO_START);

    Cell d11 = row11.createCell(3);
    d11.setCellStyle(styles.get(STYLE_SMALL_FONT));
    Cell e11 = row11.createCell(4);
    e11.setCellStyle(styles.get(STYLE_SMALL_FONT));
    e11.setCellValue(PULSIO_START);
}

From source file:com.griffinslogistics.document.excel.BookLabelGenerator.java

private static void generateAddress(Sheet sheet, Map<String, CellStyle> styles, BookLabelModel bookLabelModel) {
    sheet.addMergedRegion(CellRangeAddress.valueOf("$A2:A3"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$A12:A13"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$D2:D3"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$D12:D13"));

    Row row2 = sheet.getRow(1);/* ww  w.  ja v a  2 s.c o m*/
    Row row3 = sheet.getRow(2);

    Cell a2 = row2.createCell(0);
    a2.setCellValue(ADDRESS);
    a2.setCellStyle(styles.get(STYLE_LABEL));

    Cell a3 = row3.createCell(0);
    a3.setCellStyle(styles.get(STYLE_LABEL));

    Cell d2 = row2.createCell(3);
    d2.setCellValue(ADDRESS);
    d2.setCellStyle(styles.get(STYLE_LABEL));

    Cell d3 = row3.createCell(3);
    d3.setCellStyle(styles.get(STYLE_LABEL));

    Cell b2 = row2.createCell(1);
    b2.setCellValue(bookLabelModel.getAddress());
    b2.setCellStyle(styles.get(STYLE_CONTENT));

    Cell b3 = row3.createCell(1);
    b3.setCellValue(bookLabelModel.getPostalCode());
    b3.setCellStyle(styles.get(STYLE_CONTENT));

    Cell e2 = row2.createCell(4);
    e2.setCellValue(bookLabelModel.getAddress());
    e2.setCellStyle(styles.get(STYLE_CONTENT));

    Cell e3 = row3.createCell(4);
    e3.setCellValue(bookLabelModel.getPostalCode());
    e3.setCellStyle(styles.get(STYLE_CONTENT));

    Row row12 = sheet.getRow(11);

    Row row13 = sheet.getRow(12);

    Cell a12 = row12.createCell(0);
    a12.setCellValue(ADDRESS);
    a12.setCellStyle(styles.get(STYLE_LABEL));

    Cell a13 = row13.createCell(0);
    a13.setCellStyle(styles.get(STYLE_LABEL));

    Cell d12 = row12.createCell(3);
    d12.setCellValue(ADDRESS);
    d12.setCellStyle(styles.get(STYLE_LABEL));

    Cell d13 = row13.createCell(3);
    d13.setCellStyle(styles.get(STYLE_LABEL));

    Cell b12 = row12.createCell(1);
    b12.setCellValue(bookLabelModel.getAddress());
    b12.setCellStyle(styles.get(STYLE_CONTENT));

    Cell b13 = row13.createCell(1);
    b13.setCellValue(bookLabelModel.getPostalCode());
    b13.setCellStyle(styles.get(STYLE_CONTENT));

    Cell e12 = row12.createCell(4);
    e12.setCellValue(bookLabelModel.getAddress());
    e12.setCellStyle(styles.get(STYLE_CONTENT));

    Cell e13 = row13.createCell(4);
    e13.setCellValue(bookLabelModel.getPostalCode());
    e13.setCellStyle(styles.get(STYLE_CONTENT));
}

From source file:com.griffinslogistics.document.excel.BookLabelGenerator.java

private static void generateClient(Sheet sheet, Map<String, CellStyle> styles, BookLabelModel bookLabelModel) {
    Row row4 = sheet.getRow(3);/*w  ww . j  av a  2 s  .c om*/

    Cell a4 = row4.createCell(0);
    a4.setCellStyle(styles.get(STYLE_LABEL));
    a4.setCellValue(CLIENT);

    Cell b4 = row4.createCell(1);
    b4.setCellStyle(styles.get(STYLE_CONTENT));
    b4.setCellValue(bookLabelModel.getClient());

    Cell d4 = row4.createCell(3);
    d4.setCellStyle(styles.get(STYLE_LABEL));
    d4.setCellValue(CLIENT);

    Cell e4 = row4.createCell(4);
    e4.setCellStyle(styles.get(STYLE_CONTENT));
    e4.setCellValue(bookLabelModel.getClient());

    Row row14 = sheet.getRow(13);

    Cell a14 = row14.createCell(0);
    a14.setCellStyle(styles.get(STYLE_LABEL));
    a14.setCellValue(CLIENT);

    Cell b14 = row14.createCell(1);
    b14.setCellStyle(styles.get(STYLE_CONTENT));
    b14.setCellValue(bookLabelModel.getClient());

    Cell d14 = row14.createCell(3);
    d14.setCellStyle(styles.get(STYLE_LABEL));
    d14.setCellValue(CLIENT);

    Cell e14 = row14.createCell(4);
    e14.setCellStyle(styles.get(STYLE_CONTENT));
    e14.setCellValue(bookLabelModel.getClient());
}

From source file:com.griffinslogistics.document.excel.BookLabelGenerator.java

private static void generateTransportation(Sheet sheet, Map<String, CellStyle> styles,
        BookLabelModel bookLabelModel) {
    Row row5 = sheet.getRow(4);/*  w  ww.j av  a  2  s .com*/

    Cell a5 = row5.createCell(0);
    a5.setCellValue(TRANSPORT_NUMBER);
    a5.setCellStyle(styles.get(STYLE_LABEL));

    Cell b5 = row5.createCell(1);
    b5.setCellValue(bookLabelModel.getPackageNumber());
    b5.setCellStyle(styles.get(STYLE_CONTENT));

    Cell d5 = row5.createCell(3);
    d5.setCellValue(TRANSPORT_NUMBER);
    d5.setCellStyle(styles.get(STYLE_LABEL));

    Cell e5 = row5.createCell(4);
    e5.setCellValue(bookLabelModel.getPackageNumber());
    e5.setCellStyle(styles.get(STYLE_CONTENT));

    Row row15 = sheet.getRow(14);

    Cell a15 = row15.createCell(0);
    a15.setCellValue(TRANSPORT_NUMBER);
    a15.setCellStyle(styles.get(STYLE_LABEL));

    Cell b15 = row15.createCell(1);
    b15.setCellValue(bookLabelModel.getPackageNumber());
    b15.setCellStyle(styles.get(STYLE_CONTENT));

    Cell d15 = row15.createCell(3);
    d15.setCellValue(TRANSPORT_NUMBER);
    d15.setCellStyle(styles.get(STYLE_LABEL));

    Cell e15 = row15.createCell(4);
    e15.setCellValue(bookLabelModel.getPackageNumber());
    e15.setCellStyle(styles.get(STYLE_CONTENT));
}

From source file:com.griffinslogistics.document.excel.BookLabelGenerator.java

private static void generateTitle(Sheet sheet, Map<String, CellStyle> styles, BookLabelModel bookLabelModel) {
    sheet.addMergedRegion(CellRangeAddress.valueOf("$A6:A7"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$D6:D7"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$A16:A17"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$D16:D17"));

    String isbn = bookLabelModel.getISBN() != null ? bookLabelModel.getISBN() : "";
    String titleISBNString = String.format("%s %s", bookLabelModel.getTitle(), isbn);
    Row row6 = sheet.getRow(5);/*from w  ww  .  j  av a 2 s .c  o  m*/
    Row row7 = sheet.getRow(6);

    Cell a6 = row6.createCell(0);
    a6.setCellStyle(styles.get(STYLE_LABEL));
    a6.setCellValue(TITLE);

    Cell a7 = row7.createCell(0);
    a7.setCellStyle(styles.get(STYLE_LABEL));

    Cell b6 = row6.createCell(1);
    b6.setCellStyle(styles.get(STYLE_CONTENT));
    b6.setCellValue(titleISBNString);

    Cell b7 = row7.createCell(1);
    b7.setCellStyle(styles.get(STYLE_CONTENT));
    b7.setCellValue(bookLabelModel.getBookNumber());

    Cell d6 = row6.createCell(3);
    d6.setCellStyle(styles.get(STYLE_LABEL));
    d6.setCellValue(TITLE);

    Cell d7 = row7.createCell(3);
    d7.setCellStyle(styles.get(STYLE_LABEL));

    Cell e6 = row6.createCell(4);
    e6.setCellStyle(styles.get(STYLE_CONTENT));
    e6.setCellValue(titleISBNString);

    Cell e7 = row7.createCell(4);
    e7.setCellStyle(styles.get(STYLE_CONTENT));
    e7.setCellValue(bookLabelModel.getBookNumber());

    Row row16 = sheet.getRow(15);
    Row row17 = sheet.getRow(16);

    Cell a16 = row16.createCell(0);
    a16.setCellStyle(styles.get(STYLE_LABEL));
    a16.setCellValue(TITLE);

    Cell a17 = row17.createCell(0);
    a17.setCellStyle(styles.get(STYLE_LABEL));

    Cell b16 = row16.createCell(1);
    b16.setCellStyle(styles.get(STYLE_CONTENT));
    b16.setCellValue(titleISBNString);

    Cell b17 = row17.createCell(1);
    b17.setCellStyle(styles.get(STYLE_CONTENT));
    b17.setCellValue(bookLabelModel.getBookNumber());

    Cell d16 = row16.createCell(3);
    d16.setCellStyle(styles.get(STYLE_LABEL));
    d16.setCellValue(TITLE);

    Cell d17 = row17.createCell(3);
    d17.setCellStyle(styles.get(STYLE_LABEL));

    Cell e16 = row16.createCell(4);
    e16.setCellStyle(styles.get(STYLE_CONTENT));
    e16.setCellValue(titleISBNString);

    Cell e17 = row17.createCell(4);
    e17.setCellStyle(styles.get(STYLE_CONTENT));
    e17.setCellValue(bookLabelModel.getBookNumber());
}

From source file:com.griffinslogistics.document.excel.BookLabelGenerator.java

private static void generateCountPerBox(Sheet sheet, Map<String, CellStyle> styles,
        BookLabelModel bookLabelModel) {
    Row row8 = sheet.getRow(7);// www . j  a  va  2  s. c o m

    Cell a8 = row8.createCell(0);
    a8.setCellStyle(styles.get(STYLE_LABEL));
    a8.setCellValue(COUNT_PER_BOX);

    Cell b8 = row8.createCell(1);
    b8.setCellStyle(styles.get(STYLE_CONTENT));
    b8.setCellValue(EX);

    Cell d8 = row8.createCell(3);
    d8.setCellStyle(styles.get(STYLE_LABEL));
    d8.setCellValue(COUNT_PER_BOX);

    Cell e8 = row8.createCell(4);
    e8.setCellStyle(styles.get(STYLE_CONTENT));
    e8.setCellValue(EX);

    Row row18 = sheet.getRow(17);

    Cell a18 = row18.createCell(0);
    a18.setCellStyle(styles.get(STYLE_LABEL));
    a18.setCellValue(COUNT_PER_BOX);

    Cell b18 = row18.createCell(1);
    b18.setCellStyle(styles.get(STYLE_CONTENT));
    b18.setCellValue(EX);

    Cell d18 = row18.createCell(3);
    d18.setCellStyle(styles.get(STYLE_LABEL));
    d18.setCellValue(COUNT_PER_BOX);

    Cell e18 = row18.createCell(4);
    e18.setCellStyle(styles.get(STYLE_CONTENT));
    e18.setCellValue(EX);
}

From source file:com.griffinslogistics.document.excel.BookLabelGenerator.java

private static void generateCountPerAddress(Sheet sheet, Map<String, CellStyle> styles,
        BookLabelModel bookLabelModel) {
    Row row9 = sheet.getRow(8);//  www .  j  a  v a  2s . c o  m

    Cell a9 = row9.createCell(0);
    a9.setCellStyle(styles.get(STYLE_LABEL));
    a9.setCellValue(COUNT_PER_ADDRESS);

    Cell b9 = row9.createCell(1);
    b9.setCellStyle(styles.get(STYLE_CONTENT));
    b9.setCellValue(bookLabelModel.getCount().toString() + " " + EX);

    Cell d9 = row9.createCell(3);
    d9.setCellStyle(styles.get(STYLE_LABEL));
    d9.setCellValue(COUNT_PER_ADDRESS);

    Cell e9 = row9.createCell(4);
    e9.setCellStyle(styles.get(STYLE_CONTENT));
    e9.setCellValue(bookLabelModel.getCount().toString() + " " + EX);

    Row row19 = sheet.getRow(18);

    Cell a19 = row19.createCell(0);
    a19.setCellStyle(styles.get(STYLE_LABEL));
    a19.setCellValue(COUNT_PER_ADDRESS);

    Cell b19 = row19.createCell(1);
    b19.setCellStyle(styles.get(STYLE_CONTENT));
    b19.setCellValue(bookLabelModel.getCount().toString() + " " + EX);

    Cell d19 = row19.createCell(3);
    d19.setCellStyle(styles.get(STYLE_LABEL));
    d19.setCellValue(COUNT_PER_ADDRESS);

    Cell e19 = row19.createCell(4);
    e19.setCellStyle(styles.get(STYLE_CONTENT));
    e19.setCellValue(bookLabelModel.getCount().toString() + " " + EX);
}

From source file:com.griffinslogistics.document.excel.CMRGenerator.java

private static void generateHeaderRow(Row headerRow, Map<String, CellStyle> styles, String packageNumber) {
    Cell headingCell = headerRow.createCell(1);
    headingCell.setCellValue(HEADING_INTERNATIONAL_BILL);
    headingCell.setCellStyle(styles.get(DEFAULT_STYLE));

    Cell CMRCell = headerRow.createCell(2);
    CMRCell.setCellValue(HEADING_CMR);/*from   w w w.  ja v  a  2 s.  c o m*/
    CMRCell.setCellStyle(styles.get(DEFAULT_STYLE));

    Cell internationalHeadingCell = headerRow.createCell(3);
    internationalHeadingCell.setCellValue(HEADING_CONSIGNMENT);
    internationalHeadingCell.setCellStyle(styles.get(DEFAULT_STYLE));

    Cell countryHeadingCell = headerRow.createCell(7);
    countryHeadingCell.setCellValue(HEADING_COUNTRY);
    countryHeadingCell.setCellStyle(styles.get(DEFAULT_STYLE));

    Cell numberHeadingCell = headerRow.createCell(9);
    numberHeadingCell.setCellValue(HEADING_NUMBER + packageNumber);
    numberHeadingCell.setCellStyle(styles.get(DEFAULT_STYLE));
}

From source file:com.griffinslogistics.document.excel.CMRGenerator.java

private static int generateSenderAndDriver(XSSFSheet sheet, Map<String, CellStyle> styles, int currentRow) {
    // new value is 5
    currentRow = currentRow + 3;/*from   www  .j  a v  a 2  s  . c  om*/

    Row labelRow = sheet.createRow(currentRow);
    sheet.addMergedRegion(CellRangeAddress.valueOf("$B$6:$C6"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$B$7:$C7"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$B$8:$C8"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$B$9:$C9"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$B$10:$C10"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$D$6:$I$10"));

    Cell senderLabelCell = labelRow.createCell(1);
    senderLabelCell.setCellValue(LABEL_SENDER);
    senderLabelCell.setCellStyle(styles.get(LABEL_TOP_STYLE));
    labelRow.createCell(2).setCellStyle(styles.get(LABEL_TOP_STYLE));

    currentRow++;
    Row addressRow1 = sheet.createRow(currentRow);
    Cell addressCell1 = addressRow1.createCell(1);
    addressCell1.setCellValue(ADDRESS_PART_1);
    addressCell1.setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));

    currentRow++;
    Row addressRow2 = sheet.createRow(currentRow);
    Cell addressCell2 = addressRow2.createCell(1);
    addressCell2.setCellValue(ADDRESS_PART_2);
    addressCell2.setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));

    currentRow++;
    Row addressRow3 = sheet.createRow(currentRow);
    Cell addressCell3 = addressRow3.createCell(1);
    addressCell3.setCellValue(ADDRESS_PART_3);
    addressCell3.setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));

    currentRow++;
    Row addressRow4 = sheet.createRow(currentRow);
    Cell addressCell4 = addressRow4.createCell(1);
    addressCell4.setCellValue(ADDRESS_PART_4);
    addressCell4.setCellStyle(styles.get(CONTENT_BOTTOM_STYLE));
    addressRow4.createCell(2).setCellStyle(styles.get(CONTENT_BOTTOM_STYLE));

    //set styles for driver cells
    for (int i = 5; i <= 9; i++) {
        // the rows are already initialized above
        Row row = sheet.getRow(i);

        for (int j = 3; j <= 8; j++) {
            Cell cell = row.createCell(j);
            cell.setCellStyle(styles.get(LABEL_WHOLE_STYLE));
        }
    }

    Cell driverCell = labelRow.createCell(3);
    driverCell.setCellValue(LABEL_DRIVER);
    driverCell.setCellStyle(styles.get(LABEL_WHOLE_STYLE));

    return currentRow;
}

From source file:com.griffinslogistics.document.excel.CMRGenerator.java

private static int generatePoint2Till9(XSSFSheet sheet, Map<String, CellStyle> styles, int currentRow,
        String deliveryAddress) {
    for (int i = 11; i < 27; i++) {
        sheet.addMergedRegion(CellRangeAddress.valueOf("$B$" + i + ":$C$" + i));
        sheet.addMergedRegion(CellRangeAddress.valueOf("$D$" + i + ":$I$" + i));
    }//from ww  w . j a  v a  2 s  . c o m

    currentRow++;
    Row row11 = sheet.createRow(currentRow);
    Cell receiverLabelCell = row11.createCell(1);
    receiverLabelCell.setCellValue(LABEL_RECEIVER);
    receiverLabelCell.setCellStyle(styles.get(LABEL_TOP_STYLE));
    row11.createCell(2).setCellStyle(styles.get(LABEL_TOP_STYLE));

    currentRow++;
    Row row12 = sheet.createRow(currentRow);
    row12.createCell(1).setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));
    row12.createCell(2).setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));

    currentRow++;
    Row row13 = sheet.createRow(currentRow);
    Cell receiverCell1 = row13.createCell(1);
    receiverCell1.setCellValue(RECEIVER_PART_1);
    receiverCell1.setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));
    row13.createCell(2).setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));

    currentRow++;
    Row row14 = sheet.createRow(currentRow);
    Cell receiverCell2 = row14.createCell(1);
    receiverCell2.setCellValue(RECEIVER_PART_2);
    receiverCell2.setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));
    row14.createCell(2).setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));
    row14.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    currentRow++;
    Row row15 = sheet.createRow(currentRow);
    Cell receiverCell3 = row15.createCell(1);
    receiverCell3.setCellValue(RECEIVER_PART_3);
    receiverCell3.setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));
    row15.createCell(2).setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));

    Cell successiveCarrierCell1 = row11.createCell(3);
    successiveCarrierCell1.setCellValue(LABEL_SUCCESSIVE_CARRIERS_PART_1);
    successiveCarrierCell1.setCellStyle(styles.get(LABEL_TOP_STYLE));
    row11.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    Cell successiveCarrierCell2 = row12.createCell(3);
    successiveCarrierCell2.setCellValue(LABEL_SUCCESSIVE_CARRIERS_PART_2);
    successiveCarrierCell2.setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row12.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    Cell successiveCarrierCell3 = row13.createCell(3);
    successiveCarrierCell3.setCellValue(LABEL_SUCCESSIVE_CARRIERS_PART_3);
    successiveCarrierCell3.setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row13.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    Cell reservationsCell1 = row15.createCell(3);
    reservationsCell1.setCellValue(RESERVATIONS_PART_1);
    reservationsCell1.setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row15.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    currentRow++;
    Row row16 = sheet.createRow(currentRow);
    Cell reservationsCell2 = row16.createCell(3);
    reservationsCell2.setCellValue(RESERVATIONS_PART_2);
    reservationsCell2.setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row16.createCell(1).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row16.createCell(2).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row16.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    currentRow++;
    Row row17 = sheet.createRow(currentRow);
    row17.createCell(1).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row17.createCell(2).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row17.createCell(3).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row17.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    currentRow++;
    Row row18 = sheet.createRow(currentRow);
    Cell takingOverCellLabel = row18.createCell(1);
    takingOverCellLabel.setCellValue(LABEL_TAKING_OVER);
    takingOverCellLabel.setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row18.createCell(2).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row18.createCell(3).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row18.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    currentRow++;
    Row row19 = sheet.createRow(currentRow);
    Cell takingOverContentCell = row19.createCell(1);
    takingOverContentCell.setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));
    takingOverContentCell.setCellValue(TAKING_OVER_CONTENT);

    row19.createCell(2).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row19.createCell(3).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row19.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    currentRow++;
    Row row20 = sheet.createRow(currentRow);
    Cell countryLabelCell = row20.createCell(1);
    countryLabelCell.setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    countryLabelCell.setCellValue(LABEL_COUNTRY);

    row20.createCell(2).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row20.createCell(3).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row20.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    currentRow++;
    Row row21 = sheet.createRow(currentRow);
    Cell countryContentCell = row21.createCell(1);
    countryContentCell.setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));
    countryContentCell.setCellValue(ADDRESS_PART_4.trim());

    row21.createCell(2).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row21.createCell(3).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row21.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    currentRow++;
    Row row22 = sheet.createRow(currentRow);
    Cell dateCell = row22.createCell(1);
    dateCell.setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    dateCell.setCellValue(LABEL_DATE);

    row22.createCell(2).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row22.createCell(3).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row22.createCell(8).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    currentRow++;
    Row row23 = sheet.createRow(currentRow);
    Cell arrivalTime = row23.createCell(1);
    arrivalTime.setCellStyle(styles.get(LABEL_BOTTOM_STYLE));
    arrivalTime.setCellValue(LABEL_ARRIVAL_TIME);

    row23.createCell(2).setCellStyle(styles.get(LABEL_BOTTOM_STYLE));

    for (int i = 3; i < 9; i++) {
        row23.createCell(i).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    }

    currentRow++;
    Row row24 = sheet.createRow(currentRow);
    Cell goodsDeliveryLabelCell = row24.createCell(1);
    goodsDeliveryLabelCell.setCellValue(LABEL_DELIVERY_OF_GOODS);
    goodsDeliveryLabelCell.setCellStyle(styles.get(LABEL_TOP_STYLE));
    row24.createCell(2).setCellStyle(styles.get(LABEL_TOP_STYLE));

    currentRow++;
    Row row25 = sheet.createRow(currentRow);
    Cell placeLabelCell = row25.createCell(1);
    placeLabelCell.setCellValue(LABEL_PLACE);
    placeLabelCell.setCellStyle(styles.get(LABEL_MIDDLE_STYLE));
    row25.createCell(2).setCellStyle(styles.get(LABEL_MIDDLE_STYLE));

    currentRow++;
    Row row26 = sheet.createRow(currentRow);
    row26.setHeight((short) 1500);
    Cell placeContentCell = row26.createCell(1);
    placeContentCell.setCellValue(deliveryAddress);
    placeContentCell.setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));
    row26.createCell(2).setCellStyle(styles.get(CONTENT_MIDDLE_STYLE));

    currentRow++;
    Row row27 = sheet.createRow(currentRow);
    Cell deliveryCountryLabelCell = row27.createCell(1);
    deliveryCountryLabelCell.setCellValue(LABEL_COUNTRY);
    deliveryCountryLabelCell.setCellStyle(styles.get(LABEL_LEFT_STYLE));
    Cell deliveryCountryContentCell = row27.createCell(2);
    deliveryCountryContentCell.setCellValue(FRANCE);
    deliveryCountryContentCell.setCellStyle(styles.get(CONTENT_RIGHT_STYLE));

    currentRow++;
    Row row28 = sheet.createRow(currentRow);
    sheet.addMergedRegion(CellRangeAddress.valueOf("$B$28:$C$28"));
    Cell openingHoursCell = row28.createCell(1);
    openingHoursCell.setCellValue(LABEL_OPENING_HOURS);
    openingHoursCell.setCellStyle(styles.get(LABEL_BOTTOM_STYLE));
    row28.createCell(2).setCellStyle(styles.get(LABEL_BOTTOM_STYLE));

    currentRow++;
    Row row29 = sheet.createRow(currentRow);
    sheet.addMergedRegion(CellRangeAddress.valueOf("$B$29:$C$29"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$B$30:$C$30"));
    Cell senderInstructionsCell1 = row29.createCell(1);
    senderInstructionsCell1.setCellValue(SENDER_INSTRUCTIONS_BULGARIAN);
    senderInstructionsCell1.setCellStyle(styles.get(LABEL_TOP_STYLE));
    row29.createCell(2).setCellStyle(styles.get(LABEL_TOP_STYLE));

    sheet.addMergedRegion(CellRangeAddress.valueOf("$D$29:$I$29"));
    sheet.addMergedRegion(CellRangeAddress.valueOf("$D$30:$I$30"));
    Cell carrierDocumentsCell1 = row29.createCell(3);
    carrierDocumentsCell1.setCellValue(CARRIER_DOCUMENTS_BULGARIAN);
    carrierDocumentsCell1.setCellStyle(styles.get(LABEL_TOP_STYLE));

    for (int i = 4; i < 9; i++) {
        row29.createCell(i).setCellStyle(styles.get(LABEL_TOP_STYLE));
    }

    currentRow++;
    Row row30 = sheet.createRow(currentRow);
    Cell senderInstructionsCell2 = row30.createCell(1);
    senderInstructionsCell2.setCellValue(SENDERS_INSTRUCTIONS_ENGLISH);
    senderInstructionsCell2.setCellStyle(styles.get(LABEL_BOTTOM_STYLE));
    row30.createCell(2).setCellStyle(styles.get(LABEL_BOTTOM_STYLE));

    Cell carrierDocumentsCell2 = row30.createCell(3);
    carrierDocumentsCell2.setCellValue(CARRIER_DOCUMENTS_ENGLISH);
    carrierDocumentsCell2.setCellStyle(styles.get(LABEL_BOTTOM_STYLE));

    for (int i = 4; i < 9; i++) {
        row30.createCell(i).setCellStyle(styles.get(LABEL_BOTTOM_STYLE));
    }

    for (int i = 23; i < 28; i++) {
        sheet.getRow(i).createCell(8).setCellStyle(styles.get(LABEL_RIGHT_STYLE));
    }

    return currentRow;
}