Example usage for org.apache.poi.ss.usermodel Sheet setColumnWidth

List of usage examples for org.apache.poi.ss.usermodel Sheet setColumnWidth

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.ss.usermodel.*
  5. Sheet
  6. setColumnWidth

Introduction

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

Prototype

void setColumnWidth(int columnIndex, int width);

Source Link

Document

Set the width (in units of 1/256th of a character width)

The maximum column width for an individual cell is 255 characters.

Usage

From source file:org.sakaiproject.signup.tool.downloadEvents.EventWorksheet.java

License:Educational Community License

/**
 * Create a data excel worksheet for attendee's informaiton, which is in the gradebook import format
 */// www  . j  a v  a  2s .  c o m
private Workbook createAttendanceDataWorksheet(List<SignupMeetingWrapper> wrappers) {
    String eventTitle = rb.getString("sheet_name_Attendance_data", "Attendance");
    Sheet sheet = wb.createSheet(eventTitle);
    PrintSetup printSetup = sheet.getPrintSetup();
    printSetup.setLandscape(true);
    sheet.setFitToPage(true);
    sheet.setHorizontallyCenter(true);
    //Map to store all data
    Map<String, List<Integer>> m = new HashMap<String, List<Integer>>();

    if (wrappers == null)
        return wb;

    /* Define column numbers and width here */
    int numberOfColumn = wrappers.size() + 1;
    sheet.setColumnWidth(0, 25 * 256);// event title

    int rowNum = 0;
    Cell cell = null;
    Row titleRow = sheet.createRow(rowNum++);
    titleRow.setHeightInPoints(rowHigh);
    for (int i = 0; i <= numberOfColumn; i++) {
        titleRow.createCell(i).setCellStyle(styles.get("item_leftBold"));
    }

    int cellNum = 0;
    titleRow.getCell(cellNum++).setCellValue(rb.getString("wksheet_attendance_UserID", "UserID"));
    int index = -1;

    for (SignupMeetingWrapper wrp : wrappers) {

        if (wrp.getMeeting().isAllowAttendance()) {

            index++;
            titleRow.getCell(cellNum++).setCellValue(wrp.getMeeting().getTitle());

            List<SignupTimeslot> tsItems = wrp.getMeeting().getSignupTimeSlots();
            if (tsItems != null) {
                for (SignupTimeslot tsItem : tsItems) {
                    /*strange thing happen for hibernate, tsItem can be null for mySql 4.x*/
                    List<SignupAttendee> attendees = tsItem == null ? null
                            : getValidAttendees(tsItem.getAttendees());
                    if (attendees != null) {
                        for (SignupAttendee att : attendees) {

                            //If attended then score is 1 else 0
                            Integer attended = 0;
                            if (att.isAttended()) {
                                attended = 1;
                            }

                            User attendee = sakaiFacade.getUser(att.getAttendeeUserId());
                            String attendeeEID = attendee.getEid();
                            if (m.containsKey(attendeeEID)) {
                                //Integer value=m.get(attendeeEID).get(index);
                                List<Integer> attendanceList = m.get(attendeeEID);
                                if (attendanceList.get(index) != null) {
                                    attendanceList.set(index, attendanceList.get(index) + attended);
                                } else {
                                    attendanceList.set(index, attended);
                                }
                            } else {
                                List<Integer> newList = Arrays.asList(new Integer[wrappers.size()]);
                                newList.set(index, attended);
                                m.put(attendeeEID, newList);
                            }
                        }
                    }

                    //Recording attendance for waitlisted user Signup-106
                    List<SignupAttendee> waitingList = tsItem == null ? null : tsItem.getWaitingList();
                    if (waitingList != null) {
                        //For waitlisted user, if added it is scored, if not ignored
                        Integer attended = 1;
                        for (SignupAttendee wt : waitingList) {

                            if (wt.isAttended()) {
                                User attendee = sakaiFacade.getUser(wt.getAttendeeUserId());
                                String attendeeEID = attendee.getEid();
                                if (m.containsKey(attendeeEID)) {
                                    //Integer value=m.get(attendeeEID).get(index);
                                    List<Integer> attendanceList = m.get(attendeeEID);
                                    if (attendanceList.get(index) != null) {
                                        attendanceList.set(index, attendanceList.get(index) + attended);
                                    } else {
                                        attendanceList.set(index, attended);
                                    }
                                } else {
                                    List<Integer> newList = Arrays.asList(new Integer[wrappers.size()]);
                                    newList.set(index, attended);
                                    m.put(attendeeEID, newList);
                                }
                            }
                        }
                    }
                }

            }
        }
    }
    //populate the map into workbook
    Iterator it = m.entrySet().iterator();
    while (it.hasNext()) {

        //key value pair of Map
        Map.Entry pairs = (Map.Entry) it.next();

        //create new row
        Row row = sheet.createRow(rowNum++);
        for (int i = 0; i <= numberOfColumn; i++) {
            row.createCell(i).setCellStyle(styles.get("item_left"));
        }
        cellNum = 0;
        row.getCell(cellNum++).setCellValue((String) pairs.getKey());
        List<Integer> attendanceList = (List) pairs.getValue();
        for (int i = 0; i < attendanceList.size(); i++) {
            if (attendanceList.get(i) != null) {
                row.getCell(cellNum++).setCellValue(attendanceList.get(i));
            } else { //empty value if null
                row.getCell(cellNum++).setCellValue("");
            }
        }

    }
    return wb;
}

From source file:org.spdx.compare.AbstractFileCompareSheet.java

License:Apache License

/**
 * @param wb/*w  w  w  . java  2  s  .  co  m*/
 * @param sheetName
 */
public static void create(Workbook wb, String sheetName, int columnWidth) {
    int sheetNum = wb.getSheetIndex(sheetName);
    if (sheetNum >= 0) {
        wb.removeSheetAt(sheetNum);
    }
    Sheet sheet = wb.createSheet(sheetName);
    Row row = sheet.createRow(0);
    CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
    CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
    sheet.setColumnWidth(FILENAME_COL, FILENAME_COL_WIDTH * 256);
    sheet.setDefaultColumnStyle(FILENAME_COL, defaultStyle);
    Cell fileNameHeadercell = row.createCell(FILENAME_COL);
    fileNameHeadercell.setCellStyle(headerStyle);
    fileNameHeadercell.setCellValue(FILENAME_TITLE);
    sheet.setColumnWidth(DIFF_COL, DIFF_COL_WIDTH * 256);
    sheet.setDefaultColumnStyle(DIFF_COL, defaultStyle);
    Cell diffHeaderCell = row.createCell(DIFF_COL);
    diffHeaderCell.setCellStyle(headerStyle);
    diffHeaderCell.setCellValue(DIFF_TITLE);

    for (int i = FIRST_DOCUMENT_COL; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS + FIRST_DOCUMENT_COL; i++) {
        sheet.setColumnWidth(i, columnWidth * 256);
        sheet.setDefaultColumnStyle(i, defaultStyle);
        Cell cell = row.createCell(i);
        cell.setCellStyle(headerStyle);
    }
}

From source file:org.spdx.compare.CreatorSheet.java

License:Apache License

/**
 * @param wb/*  ww  w  .  ja  v  a 2  s.  co m*/
 * @param sheetName
 */
public static void create(Workbook wb, String sheetName) {
    int sheetNum = wb.getSheetIndex(sheetName);
    if (sheetNum >= 0) {
        wb.removeSheetAt(sheetNum);
    }
    Sheet sheet = wb.createSheet(sheetName);
    CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
    CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
    Row row = sheet.createRow(0);
    for (int i = 0; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS; i++) {
        sheet.setColumnWidth(i, COL_WIDTH * 256);
        sheet.setDefaultColumnStyle(i, defaultStyle);
        Cell cell = row.createCell(i);
        cell.setCellStyle(headerStyle);
    }
}

From source file:org.spdx.compare.DocumentAnnotationSheet.java

License:Apache License

/**
 * @param wb//from w  ww.ja  v  a  2s  .com
 * @param sheetName
 */
public static void create(Workbook wb, String sheetName) {
    int sheetNum = wb.getSheetIndex(sheetName);
    if (sheetNum >= 0) {
        wb.removeSheetAt(sheetNum);
    }
    Sheet sheet = wb.createSheet(sheetName);
    CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
    CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
    Row row = sheet.createRow(0);
    sheet.setColumnWidth(ANNOTATOR_COL, ANNOTATOR_COL_WIDTH * 256);
    sheet.setDefaultColumnStyle(ANNOTATOR_COL, defaultStyle);
    Cell annotatorHeaderCell = row.createCell(ANNOTATOR_COL);
    annotatorHeaderCell.setCellStyle(headerStyle);
    annotatorHeaderCell.setCellValue(ANNOTATOR_COL_TEXT_TITLE);

    sheet.setColumnWidth(TYPE_COL, TYPE_COL_WIDTH * 256);
    sheet.setDefaultColumnStyle(TYPE_COL, defaultStyle);
    Cell typeHeaderCell = row.createCell(TYPE_COL);
    typeHeaderCell.setCellStyle(headerStyle);
    typeHeaderCell.setCellValue(TYPE_COL_TEXT_TITLE);

    sheet.setColumnWidth(COMMENT_COL, COMMENT_COL_WIDTH * 256);
    sheet.setDefaultColumnStyle(COMMENT_COL, defaultStyle);
    Cell commentHeaderCell = row.createCell(COMMENT_COL);
    commentHeaderCell.setCellStyle(headerStyle);
    commentHeaderCell.setCellValue(COMMENT_COL_TEXT_TITLE);

    for (int i = FIRST_DATE_COL; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS; i++) {
        sheet.setColumnWidth(i, DATE_COL_WIDTH * 256);
        sheet.setDefaultColumnStyle(i, defaultStyle);
        Cell cell = row.createCell(i);
        cell.setCellStyle(headerStyle);
    }
}

From source file:org.spdx.compare.DocumentRelationshipSheet.java

License:Apache License

/**
 * @param wb// ww w  .j a  v  a  2 s  .c o  m
 * @param sheetName
 */
public static void create(Workbook wb, String sheetName) {
    int sheetNum = wb.getSheetIndex(sheetName);
    if (sheetNum >= 0) {
        wb.removeSheetAt(sheetNum);
    }
    Sheet sheet = wb.createSheet(sheetName);
    CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
    CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
    Row row = sheet.createRow(0);

    sheet.setColumnWidth(TYPE_COL, TYPE_COL_WIDTH * 256);
    sheet.setDefaultColumnStyle(TYPE_COL, defaultStyle);
    Cell typeHeaderCell = row.createCell(TYPE_COL);
    typeHeaderCell.setCellStyle(headerStyle);
    typeHeaderCell.setCellValue(TYPE_COL_TEXT_TITLE);

    for (int i = FIRST_RELATIONSHIP_COL; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS; i++) {
        sheet.setColumnWidth(i, FIRST_RELATIONSHIP_COL_WIDTH * 256);
        sheet.setDefaultColumnStyle(i, defaultStyle);
        Cell cell = row.createCell(i);
        cell.setCellStyle(headerStyle);
    }
}

From source file:org.spdx.compare.DocumentSheet.java

License:Apache License

/**
 * @param wb/*w  w  w. j  a  v a 2 s. co m*/
 * @param sheetName
 */
public static void create(Workbook wb, String sheetName) {
    int sheetNum = wb.getSheetIndex(sheetName);
    if (sheetNum >= 0) {
        wb.removeSheetAt(sheetNum);
    }
    Sheet sheet = wb.createSheet(sheetName);
    CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
    CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
    Row row = sheet.createRow(0);
    for (int i = 0; i < HEADER_TITLES.length; i++) {
        sheet.setColumnWidth(i, COLUMN_WIDTHS[i] * 256);
        sheet.setDefaultColumnStyle(i, defaultStyle);
        Cell cell = row.createCell(i);
        cell.setCellStyle(headerStyle);
        cell.setCellValue(HEADER_TITLES[i]);
    }
}

From source file:org.spdx.compare.ExternalReferencesSheet.java

License:Apache License

/**
 * @param wb//from   w ww. j  a va 2s  . c  om
 * @param sheetName
 */
public static void create(Workbook wb, String sheetName) {
    int sheetNum = wb.getSheetIndex(sheetName);
    if (sheetNum >= 0) {
        wb.removeSheetAt(sheetNum);
    }
    Sheet sheet = wb.createSheet(sheetName);
    CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
    CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
    Row row = sheet.createRow(0);
    sheet.setColumnWidth(NAMESPACE_COL, NAMESPACE_COL_WIDTH * 256);
    sheet.setDefaultColumnStyle(NAMESPACE_COL, defaultStyle);
    Cell extractedHeaderCell = row.createCell(NAMESPACE_COL);
    extractedHeaderCell.setCellStyle(headerStyle);
    extractedHeaderCell.setCellValue(NAMESPACE_TEXT_TITLE);

    sheet.setColumnWidth(CHECKSUM_COL, CHECKSUM_COL_WIDTH * 256);
    sheet.setDefaultColumnStyle(CHECKSUM_COL, defaultStyle);
    Cell checksumHeaderCell = row.createCell(CHECKSUM_COL);
    checksumHeaderCell.setCellStyle(headerStyle);
    checksumHeaderCell.setCellValue(CHECKSUM_TEXT_TITLE);

    for (int i = FIRST_DOC_ID_COL; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS; i++) {
        sheet.setColumnWidth(i, DOC_ID_COL_WIDTH * 256);
        sheet.setDefaultColumnStyle(i, defaultStyle);
        Cell cell = row.createCell(i);
        cell.setCellStyle(headerStyle);
    }
}

From source file:org.spdx.compare.ExtractedLicenseSheet.java

License:Apache License

/**
 * @param wb/*from  ww  w  .  j  a  v  a 2 s .  co  m*/
 * @param sheetName
 */
public static void create(Workbook wb, String sheetName) {
    int sheetNum = wb.getSheetIndex(sheetName);
    if (sheetNum >= 0) {
        wb.removeSheetAt(sheetNum);
    }
    Sheet sheet = wb.createSheet(sheetName);
    CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
    CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
    Row row = sheet.createRow(0);
    sheet.setColumnWidth(EXTRACTED_TEXT_COL, EXTRACTED_TEXT_WIDTH * 256);
    sheet.setDefaultColumnStyle(EXTRACTED_TEXT_COL, defaultStyle);
    Cell extractedHeaderCell = row.createCell(EXTRACTED_TEXT_COL);
    extractedHeaderCell.setCellStyle(headerStyle);
    extractedHeaderCell.setCellValue(EXTRACTED_TEXT_TITLE);
    for (int i = FIRST_LIC_ID_COL; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS; i++) {
        sheet.setColumnWidth(i, LIC_ID_COL_WIDTH * 256);
        sheet.setDefaultColumnStyle(i, defaultStyle);
        Cell cell = row.createCell(i);
        cell.setCellStyle(headerStyle);
    }
}

From source file:org.spdx.compare.PackageSheet.java

License:Apache License

/**
 * @param wb// w ww.  ja v a2  s .co m
 * @param sheetName
 */
public static void create(Workbook wb, String sheetName) {
    int sheetNum = wb.getSheetIndex(sheetName);
    if (sheetNum >= 0) {
        wb.removeSheetAt(sheetNum);
    }
    Sheet sheet = wb.createSheet(sheetName);
    CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
    CellStyle defaultStyle = AbstractSheet.createLeftWrapStyle(wb);
    Row headerRow = sheet.createRow(0);
    sheet.setColumnWidth(FIELD_COL, FIELD_COL_WIDTH * 256);
    sheet.setDefaultColumnStyle(FIELD_COL, defaultStyle);
    Cell fieldCell = headerRow.createCell(FIELD_COL);
    fieldCell.setCellStyle(headerStyle);
    fieldCell.setCellValue(FIELD_HEADER_TEXT);

    sheet.setColumnWidth(EQUALS_COL, EQUALS_COL_WIDTH * 256);
    sheet.setDefaultColumnStyle(EQUALS_COL, defaultStyle);
    Cell equalsCell = headerRow.createCell(EQUALS_COL);
    equalsCell.setCellStyle(headerStyle);
    equalsCell.setCellValue(EQUALS_HEADER_TEXT);

    for (int i = FIRST_DOC_COL; i < MultiDocumentSpreadsheet.MAX_DOCUMENTS + FIRST_DOC_COL; i++) {
        sheet.setColumnWidth(i, COL_WIDTH * 256);
        sheet.setDefaultColumnStyle(i, defaultStyle);
        Cell cell = headerRow.createCell(i);
        cell.setCellStyle(headerStyle);
    }
}

From source file:org.spdx.spdxspreadsheet.AnnotationsSheet.java

License:Apache License

public static void create(Workbook wb, String sheetName) {
    int sheetNum = wb.getSheetIndex(sheetName);
    if (sheetNum >= 0) {
        wb.removeSheetAt(sheetNum);/*from  w  ww .  j a  v a  2 s .  c om*/
    }
    Sheet sheet = wb.createSheet(sheetName);
    CellStyle headerStyle = AbstractSheet.createHeaderStyle(wb);
    CellStyle centerStyle = AbstractSheet.createCenterStyle(wb);
    CellStyle wrapStyle = AbstractSheet.createLeftWrapStyle(wb);
    Row row = sheet.createRow(0);
    for (int i = 0; i < HEADER_TITLES.length; i++) {
        sheet.setColumnWidth(i, COLUMN_WIDTHS[i] * 256);
        if (LEFT_WRAP[i]) {
            sheet.setDefaultColumnStyle(i, wrapStyle);
        } else if (CENTER_NOWRAP[i]) {
            sheet.setDefaultColumnStyle(i, centerStyle);
        }
        Cell cell = row.createCell(i);
        cell.setCellStyle(headerStyle);
        cell.setCellValue(HEADER_TITLES[i]);
    }
}