Example usage for org.apache.poi.ss.usermodel Row createCell

List of usage examples for org.apache.poi.ss.usermodel Row createCell

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.ss.usermodel.*
  5. Row
  6. createCell

Introduction

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

Prototype

Cell createCell(int column);

Source Link

Document

Use this to create new cells within the row and return it.

Usage

From source file:business.SongExcelParser.java

private void setRowInfo(Row row, Song song, SongContainer container) {
    Cell cell = row.createCell(0);
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue(container.getAlbumName());
    cell = row.createCell(1);//from www  .  j  a v a  2  s .  co m
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue(song.getName());
    cell = row.createCell(2);
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue(song.getSinger());
    cell = row.createCell(3);
    cell.setCellType(Cell.CELL_TYPE_NUMERIC);
    cell.setCellValue((double) song.getDurationInMinutes());
    cell = row.createCell(4);
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue(song.getMusicalGenre());
    cell = row.createCell(5);
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue(container.getLocation());
}

From source file:business.SongExcelParser.java

private Row setRowHeader(Sheet sheet) {
    Row row = sheet.createRow(0);
    Cell cell = row.createCell(0);
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue("?lbum");
    cell = row.createCell(1);/*from   w  w w  . j  av a 2s. c o  m*/
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue("Nombre de la cancin");
    cell = row.createCell(2);
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue("Cantante");
    cell = row.createCell(3);
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue("Duracin");
    cell = row.createCell(4);
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue("Gnero musical");
    cell = row.createCell(5);
    cell.setCellType(Cell.CELL_TYPE_STRING);
    cell.setCellValue("Path o ubicacin");
    return row;
}

From source file:campmanager.CampUI.java

public void exportToExcel() {
    JFrame parentFrame = new JFrame();
    File fileToSave = null;/*from  ww w  . j av a  2 s  . c o m*/
    ;
    JFileChooser fileChooser = new JFileChooser();
    fileChooser.setDialogTitle("Export to Excel");

    int userSelection = fileChooser.showSaveDialog(parentFrame);

    if (userSelection == JFileChooser.APPROVE_OPTION) {
        fileToSave = fileChooser.getSelectedFile();
        // System.out.println("Save as file: " + fileToSave.getAbsolutePath());
    }
    if (fileToSave != null) {

        String fileName = fileToSave.getAbsolutePath();
        if (!fileName.endsWith(".xls"))
            fileName += ".xls";
        try {
            DefaultTableModel dtm = (DefaultTableModel) jTable_records.getModel();
            Workbook wb = new HSSFWorkbook();
            CreationHelper createhelper = wb.getCreationHelper();
            Sheet sheet = wb.createSheet("new sheet");
            Row row = null;
            Cell cell = null;
            row = sheet.createRow(0);

            HSSFFont font = (HSSFFont) wb.createFont();
            font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
            HSSFCellStyle style = (HSSFCellStyle) wb.createCellStyle();

            style.setFont(font);

            for (int t = 0; t < dtm.getColumnCount() - 1; t++) {
                cell = row.createCell(t);
                cell.setCellStyle(style);
                cell.setCellValue(dtm.getColumnName(t));
            }

            HSSFCellStyle style_gray = (HSSFCellStyle) wb.createCellStyle();
            style_gray.setFillForegroundColor(IndexedColors.DARK_BLUE.getIndex());
            // style_gray.setFillPattern(CellStyle.ALT_BARS);
            for (int i = 1; i <= dtm.getRowCount(); i++) {
                row = sheet.createRow(i);

                for (int j = 0; j < dtm.getColumnCount() - 1; j++) {
                    cell = row.createCell(j);
                    if (i % 2 == 0)
                        cell.setCellStyle(style_gray);
                    cell.setCellValue(dtm.getValueAt(i - 1, j).toString());

                }
            }

            FileOutputStream out = new FileOutputStream(fileName);
            wb.write(out);
            out.close();
        } catch (FileNotFoundException ex) {
            ex.printStackTrace();
        } catch (IOException ex) {
            ex.printStackTrace();
        }
    }

}

From source file:cartel.DynamicDegreeCalculation.java

License:Open Source License

public void compute(Graph graph) throws FileNotFoundException, IOException {

    Map<String, Integer> weightedDegreeForOneCountryfForOneYear;

    Workbook wb = new XSSFWorkbook();
    CreationHelper createHelper = wb.getCreationHelper();
    Sheet sheet = wb.createSheet("weighted degree");
    Row row;
    Cell cell;/*  w  w  w .j  a  v  a 2  s.  c o m*/
    Map<String, Integer> countryIndices = new TreeMap();

    int index = 0;
    for (String country : CartelDynamic.europeanCountries) {
        index++;
        countryIndices.put(country, index);
    }

    //COLUMNS HEADER
    row = sheet.createRow((short) 0);
    index = 1;
    for (int i = 1948; i < 2009; i++) {
        cell = row.createCell(index);
        index++;
        cell.setCellValue(String.valueOf(i));
    }

    //CREATING EMPTY CELLS FOR EACH ROW
    for (String country : countryIndices.keySet()) {
        row = sheet.createRow((countryIndices.get(country)));
        index = 0;
        for (int i = 1948; i <= 2009; i++) {
            row.createCell(index);
            index++;
        }
    }

    //FILLING FIRST COLUMN WITH COUNTRIES
    for (String country : countryIndices.keySet()) {
        row = sheet.getRow(countryIndices.get(country));
        row.getCell(0).setCellValue(country);
    }

    int indexYear = 1;
    for (int i = 1948; i < 2009; i++) {
        weightedDegreeForOneCountryfForOneYear = new TreeMap();
        for (Node node : graph.getNodes()) {
            String nodeLabel = node.getLabel();
            int sumDegrees = 0;

            for (Edge edge : graph.getAllEdges()) {
                if (!edge.getSource().getLabel().equals(nodeLabel)
                        & !edge.getTarget().getLabel().equals(nodeLabel)) {
                    continue;
                }
                if (edge.getSource().getLabel().equals(edge.getTarget().getLabel())) {
                    continue;
                }
                AttributeValueList attributeValueList = edge.getAttributeValues();
                for (AttributeValue attributeValue : attributeValueList) {
                    if (!attributeValue.getAttribute().getTitle().equals("freq")) {
                        continue;
                    }

                    if (((Integer) attributeValue.getStartValue()) != i) {
                        continue;
                    }
                    sumDegrees = sumDegrees + Integer.parseInt(attributeValue.getValue());
                }
            }
            sumDegrees = sumDegrees / 2;
            row = sheet.getRow(countryIndices.get(nodeLabel));
            cell = row.getCell(indexYear);
            cell.setCellValue(String.valueOf(sumDegrees));

        }
        indexYear++;
    }
    String pathFile = "D:/workbook weighted degree.xlsx";
    FileOutputStream fileOut = new FileOutputStream(pathFile);

    wb.write(fileOut);

    fileOut.close();

}

From source file:cfdi.clases.db.DerbyUtilities.java

License:Open Source License

/**
 * Exporta los registros de de CFDI datos generales o su detalle, con el filtro que se
 * haya utilizado en la interface grfica
 * //  w ww  . j  a  va  2s .  co m
 * @param query es el query filtradn para la tabla de CFDI y CFDI_DETALLE
 * @param nombre nombre del archivo 
 * @param path directorio donde se va a crear el archivo de excel
 * @return the boolean
 */
public boolean exportarExcel(String query, String nombre, String path) {
    Connection connection = null;
    Statement st = null;
    ResultSet rs = null;
    boolean respuesta = false;
    BoneCP connectionPool = null;
    try {
        Class.forName(propiedades.getProperty("DB_DRIVER"));
        // setup the connection pool
        BoneCPConfig config = new BoneCPConfig();
        config.setJdbcUrl(propiedades.getProperty("DB_SERVER")); // jdbc url specific to your database, eg jdbc:mysql://127.0.0.1/yourdb
        config.setUsername(propiedades.getProperty("DB_USER"));
        config.setPassword(propiedades.getProperty("DB_PASSWORD"));
        config.setMinConnectionsPerPartition(5);
        config.setMaxConnectionsPerPartition(10);
        config.setPartitionCount(1);
        connectionPool = new BoneCP(config); // setup the connection pool
        FileOutputStream fileOut = new FileOutputStream(path + nombre + ".xlsx");
        connection = connectionPool.getConnection(); // fetch a connection

        if (connection != null) {
            st = connection.createStatement();
            rs = st.executeQuery(query);
            ResultSetMetaData metaData = rs.getMetaData();
            int count = metaData.getColumnCount();
            SXSSFWorkbook workbook = new SXSSFWorkbook(10000);
            Sheet sheet = workbook.createSheet(nombre);
            int rownum = 0;
            Row row = sheet.createRow(rownum++);
            CellStyle stylec = workbook.createCellStyle();
            stylec.setBorderBottom(CellStyle.BORDER_THIN);
            stylec.setBottomBorderColor(IndexedColors.BLACK.getIndex());
            Font fontc = workbook.createFont();
            fontc.setBoldweight(Font.BOLDWEIGHT_BOLD);
            stylec.setFont(fontc);
            for (int i = 1; i <= count; i++) {
                row.createCell(i).setCellValue(metaData.getColumnName(i));
                row.getCell(i).setCellStyle(stylec);
            }
            while (rs.next()) {
                Row rowh = sheet.createRow(rownum++);
                for (int i = 1; i <= count; i++) {
                    if (metaData.getColumnTypeName(i).equalsIgnoreCase("INT")
                            || metaData.getColumnTypeName(i).equalsIgnoreCase("INT UNSIGNED"))
                        rowh.createCell(i).setCellValue(rs.getInt(i));
                    else if (metaData.getColumnTypeName(i).equalsIgnoreCase("DOUBLE"))
                        rowh.createCell(i).setCellValue(rs.getDouble(i));
                    else
                        rowh.createCell(i).setCellValue(rs.getString(i));
                }
            }
            /*if(rownum<5000){
            for (int i = 1; i <= count; i++)
                sheet.autoSizeColumn(i); 
            }*/
            try {
                workbook.write(fileOut);
                fileOut.flush();
                fileOut.close();

            } catch (FileNotFoundException e) {
                System.out.println("Error: export 1");
            } catch (IOException e) {
                System.out.println("Error: export 2");
            }
            respuesta = true;
            connectionPool.shutdown();
        }
    } catch (SQLException e) {
        System.out.println("Error: insertDatos 3");
        logger.log(Level.SEVERE, null, e);
    } catch (ClassNotFoundException ex) {
        logger.log(Level.SEVERE, null, ex);
    } catch (Exception ex) {
        System.out.println("Error: insertDatos 5");
        logger.log(Level.SEVERE, null, ex);
    } finally {
        if (connection != null) {
            try {
                connection.close();
            } catch (SQLException e) {
                System.out.println("Error: insertDatos 4");
                logger.log(Level.SEVERE, null, e);
            }
        }
    }
    return respuesta;
}

From source file:ch.bfh.lca._15h.library.export.ExportToExcel.java

/***
 * Generate an Excel file based on a list of results.
 * Use the name of the fields described in the GenericResultRow to label the columns.
 * @param language Language of the label in the Excel file
 * @param sheetTitle Title of the sheet in the Excel file
 * @param tableTitle Title of the table in the Excel file
 * @param rows Arrays of rows to include in the listing
 * @param excelFilePath Path of the outputed file
 * @throws FileNotFoundException/*w  w w.j a va  2s  . c  o  m*/
 * @throws IOException 
 */
public static void exportToExcel(Translation.TRANSLATION_LANGUAGE language, String sheetTitle,
        String tableTitle, GenericResultRow[] rows, String excelFilePath)
        throws FileNotFoundException, IOException {
    //Workbook wb = new HSSFWorkbook(); //xls
    Workbook wb = new SXSSFWorkbook(); //xlsx
    //create new sheet
    Sheet sheet1 = wb.createSheet(sheetTitle);
    Row row;
    Cell cell;
    String translation;

    int rowIndex = 0;

    //add title
    row = sheet1.createRow((short) rowIndex);
    cell = row.createCell(0);
    cell.setCellValue(tableTitle);
    CellStyle style = wb.createCellStyle();
    Font font = wb.createFont();
    font.setFontHeightInPoints((short) 24);
    //font.setFontName("Courier New");
    style.setFont(font);
    cell.setCellStyle(style);

    //add rows
    for (int i = 0; i < rows.length; i++) {
        //if first line, write col names
        if (i == 0) {
            row = sheet1.createRow((short) rowIndex + 2);

            for (int j = 0; j < rows[i].getColNames().length; j++) {
                cell = row.createCell(j);

                //look for translation
                translation = Translation.getForKey(language, rows[i].getColNames()[j]);
                if (translation == null) {
                    translation = rows[i].getColNames()[j]; //if doesn't found a translation for the column take name of col
                }
                cell.setCellValue(translation);
            }
        }

        row = sheet1.createRow((short) (rowIndex + i + 3));

        for (int j = 0; j < rows[i].getColNames().length; j++) {
            cell = row.createCell(j);
            cell.setCellValue(rows[i].getValueAt(j).toString());
        }
    }

    //write to the file
    FileOutputStream fileOut = new FileOutputStream(excelFilePath);
    wb.write(fileOut);
    fileOut.close();

    wb.close();
}

From source file:ch.bfh.lca._15h.library.export.ExportToExcel.java

/***
 * Prototype function. Not yet functional.
 * Allow to generate an age pyramid graphic in Excel by using an existing Excel Template.
 * @param language Language of the label in the Excel file
 * @param rows Arrays of rows to include in the listing
 * @param excelFilePath Path of the outputed file
 * @throws FileNotFoundException//from   ww  w  .ja va  2  s.co m
 * @throws IOException
 * @throws InvalidFormatException 
 */
public static void exportToAgePyramid(Translation.TRANSLATION_LANGUAGE language, GenericResultRow[] rows,
        String excelFilePath) throws FileNotFoundException, IOException, InvalidFormatException {
    //open template
    URL url = Translation.class.getClassLoader()
            .getResource("ch/bfh/lca/_15h/library/export/template/alter-pyramide-v2.xlsx");
    //Workbook wb = WorkbookFactory.create(new File(url.getPath()));
    XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(new File(url.getPath())));

    Sheet sheet = wb.getSheetAt(0);

    //http://www.programming-free.com/2012/12/create-charts-in-excel-using-java.html
    //https://poi.apache.org/spreadsheet/quick-guide.html#NewWorkbook
    Row row;
    Cell cell;

    for (int i = 0; i < 20; i++) {
        row = sheet.getRow(i + 1);
        if (row == null) {
            row = sheet.createRow(i + 1);
        }

        for (int j = 0; j < 3; j++) {
            cell = row.getCell(j);
            if (cell == null) {
                cell = row.createCell(j);
            }

            switch (j) {
            case 0:
                cell.setCellValue(i);
                break;
            case 1:
                cell.setCellValue(i * j * -1);
                break;
            case 2:
                cell.setCellValue(i * j);
                break;
            }
        }
    }

    //redefine data range
    //http://thinktibits.blogspot.ch/2014/09/Excel-Insert-Format-Table-Apache-POI-Example.html
    XSSFSheet sheet1 = wb.getSheetAt(0);
    XSSFTable table = sheet1.getTables().get(0);
    CTTable cttable = table.getCTTable();

    AreaReference my_data_range = new AreaReference(new CellReference(0, 0), new CellReference(20, 2));
    /* Set Range to the Table */
    cttable.setRef(my_data_range.formatAsString());
    // cttable.setDisplayName("DATEN");      /* this is the display name of the table */
    //cttable.setName("test");    /* This maps to "displayName" attribute in &lt;table&gt;, OOXML */
    //cttable.setId(1L); //id attribute against table as long value

    /*
    //redefine data range
    Name rangeCell = wb.getName("DATEN");
    //Set new range for named range 
    //String reference = sheetName + "!$C$" + (deface + 1) + ":$C$" + (rowNum + deface);
    String reference = sheet.getSheetName() + "!$A$2:$C$20";
    //Assigns range value to named range
    rangeCell.setRefersToFormula(reference);
    */

    //write to the file
    FileOutputStream fileOut = new FileOutputStream(excelFilePath);
    wb.write(fileOut);
    fileOut.close();
    wb.close();
}

From source file:ch.dbs.actions.reports.HoldingsReport.java

License:Open Source License

private void getXLSLine(final Workbook wb, final Sheet s, final Bestand b, final short rownumber) {

    final Row row = s.createRow(rownumber);

    if (b.getId() != null) {
        row.createCell((short) 0).setCellValue(b.getId().toString());
    } else {/*from ww w.  ja  v  a 2  s  . c  o  m*/
        row.createCell((short) 0).setCellValue("");
    }
    if (b.getHolding().getId() != null) {
        row.createCell((short) 1).setCellValue(b.getHolding().getId().toString());
    } else {
        row.createCell((short) 1).setCellValue("");
    }
    if (b.getStandort().getId() != null) {
        row.createCell((short) 2).setCellValue(b.getStandort().getId().toString());
    } else {
        row.createCell((short) 2).setCellValue("");
    }
    if (b.getStandort().getInhalt() != null) {
        row.createCell((short) 3).setCellValue(b.getStandort().getInhalt());
    } else {
        row.createCell((short) 3).setCellValue("");
    }
    if (b.getShelfmark() != null) {
        row.createCell((short) 4).setCellValue(removeSpecialCharacters(b.getShelfmark()));
    } else {
        row.createCell((short) 4).setCellValue("");
    }
    if (b.getHolding().getTitel() != null) {
        row.createCell((short) 5).setCellValue(removeSpecialCharacters(b.getHolding().getTitel()));
    } else {
        row.createCell((short) 5).setCellValue("");
    }
    if (b.getHolding().getCoden() != null) {
        row.createCell((short) 6).setCellValue(removeSpecialCharacters(b.getHolding().getCoden()));
    } else {
        row.createCell((short) 6).setCellValue("");
    }
    if (b.getHolding().getVerlag() != null) {
        row.createCell((short) 7).setCellValue(removeSpecialCharacters(b.getHolding().getVerlag()));
    } else {
        row.createCell((short) 7).setCellValue("");
    }
    if (b.getHolding().getOrt() != null) {
        row.createCell((short) 8).setCellValue(removeSpecialCharacters(b.getHolding().getOrt()));
    } else {
        row.createCell((short) 8).setCellValue("");
    }
    if (b.getHolding().getIssn() != null) {
        row.createCell((short) 9).setCellValue(removeSpecialCharacters(b.getHolding().getIssn()));
    } else {
        row.createCell((short) 9).setCellValue("");
    }
    if (b.getHolding().getZdbid() != null) {
        row.createCell((short) 10).setCellValue(removeSpecialCharacters(b.getHolding().getZdbid()));
    } else {
        row.createCell((short) 10).setCellValue("");
    }
    if (b.getStartyear() != null) {
        row.createCell((short) 11).setCellValue(removeSpecialCharacters(b.getStartyear()));
    } else {
        row.createCell((short) 11).setCellValue("");
    }
    if (b.getStartvolume() != null) {
        row.createCell((short) 12).setCellValue(removeSpecialCharacters(b.getStartvolume()));
    } else {
        row.createCell((short) 12).setCellValue("");
    }
    if (b.getStartissue() != null) {
        row.createCell((short) 13).setCellValue(removeSpecialCharacters(b.getStartissue()));
    } else {
        row.createCell((short) 13).setCellValue("");
    }
    if (b.getEndyear() != null) {
        row.createCell((short) 14).setCellValue(removeSpecialCharacters(b.getEndyear()));
    } else {
        row.createCell((short) 14).setCellValue("");
    }
    if (b.getEndvolume() != null) {
        row.createCell((short) 15).setCellValue(removeSpecialCharacters(b.getEndvolume()));
    } else {
        row.createCell((short) 15).setCellValue("");
    }
    if (b.getEndissue() != null) {
        row.createCell((short) 16).setCellValue(removeSpecialCharacters(b.getEndissue()));
    } else {
        row.createCell((short) 16).setCellValue("");
    }
    row.createCell((short) 17).setCellValue(String.valueOf(b.getSuppl()));
    if (b.getBemerkungen() != null) {
        row.createCell((short) 18).setCellValue(removeSpecialCharacters(b.getBemerkungen()));
    } else {
        row.createCell((short) 18).setCellValue("");
    }
    row.createCell((short) 19).setCellValue(String.valueOf(b.isEissue()));
    row.createCell((short) 20).setCellValue(String.valueOf(b.isInternal()));

}

From source file:ch.dbs.actions.reports.HoldingsReport.java

License:Open Source License

private void initXLS(final Workbook wb, final Sheet s) {

    final Row rowhead = s.createRow((short) 0);
    rowhead.createCell((short) 0).setCellValue("Stock ID");
    rowhead.createCell((short) 1).setCellValue("Holding ID");
    rowhead.createCell((short) 2).setCellValue("Location ID");
    rowhead.createCell((short) 3).setCellValue("Location Name");
    rowhead.createCell((short) 4).setCellValue("Shelfmark");
    rowhead.createCell((short) 5).setCellValue("Title");
    rowhead.createCell((short) 6).setCellValue("Coden");
    rowhead.createCell((short) 7).setCellValue("Publisher");
    rowhead.createCell((short) 8).setCellValue("Place");
    rowhead.createCell((short) 9).setCellValue("ISSN");
    rowhead.createCell((short) 10).setCellValue("ZDB-ID");
    rowhead.createCell((short) 11).setCellValue("Startyear");
    rowhead.createCell((short) 12).setCellValue("Startvolume");
    rowhead.createCell((short) 13).setCellValue("Startissue");
    rowhead.createCell((short) 14).setCellValue("Endyear");
    rowhead.createCell((short) 15).setCellValue("Endvolume");
    rowhead.createCell((short) 16).setCellValue("Endissue");
    rowhead.createCell((short) 17).setCellValue("Suppl");
    rowhead.createCell((short) 18).setCellValue("remarks");
    rowhead.createCell((short) 19).setCellValue("eissue");
    rowhead.createCell((short) 20).setCellValue("internal");

}

From source file:ch.dbs.actions.reports.KbartReport.java

License:Open Source License

private void getXLSLine(final Workbook wb, final Sheet s, final KbartForm kbart, final short rownumber) {

    final Row row = s.createRow(rownumber);

    if (kbart.getPublication_title() != null) {
        row.createCell((short) 0).setCellValue(removeSpecialCharacters(kbart.getPublication_title()));
    } else {//from   w  w  w .ja v a  2s. co m
        row.createCell((short) 0).setCellValue("");
    }
    if (kbart.getPrint_identifier() != null) {
        row.createCell((short) 1).setCellValue(kbart.getPrint_identifier());
    } else {
        row.createCell((short) 1).setCellValue("");
    }
    if (kbart.getOnline_identifier() != null) {
        row.createCell((short) 2).setCellValue(kbart.getOnline_identifier());
    } else {
        row.createCell((short) 2).setCellValue("");
    }
    if (kbart.getDate_first_issue_online() != null) {
        row.createCell((short) 3).setCellValue(kbart.getDate_first_issue_online());
    } else {
        row.createCell((short) 3).setCellValue("");
    }
    if (kbart.getNum_first_vol_online() != null) {
        row.createCell((short) 4).setCellValue(kbart.getNum_first_vol_online());
    } else {
        row.createCell((short) 4).setCellValue("");
    }
    if (kbart.getNum_first_issue_online() != null) {
        row.createCell((short) 5).setCellValue(kbart.getNum_first_issue_online());
    } else {
        row.createCell((short) 5).setCellValue("");
    }
    if (kbart.getDate_last_issue_online() != null) {
        row.createCell((short) 6).setCellValue(kbart.getDate_last_issue_online());
    } else {
        row.createCell((short) 6).setCellValue("");
    }
    if (kbart.getNum_last_vol_online() != null) {
        row.createCell((short) 7).setCellValue(kbart.getNum_last_vol_online());
    } else {
        row.createCell((short) 7).setCellValue("");
    }
    if (kbart.getNum_last_issue_online() != null) {
        row.createCell((short) 8).setCellValue(kbart.getNum_last_issue_online());
    } else {
        row.createCell((short) 8).setCellValue("");
    }
    if (kbart.getTitle_url() != null) {
        row.createCell((short) 9).setCellValue(kbart.getTitle_url());
    } else {
        row.createCell((short) 9).setCellValue("");
    }
    if (kbart.getFirst_author() != null) {
        row.createCell((short) 10).setCellValue(removeSpecialCharacters(kbart.getFirst_author()));
    } else {
        row.createCell((short) 10).setCellValue("");
    }
    if (kbart.getTitle_id() != null) {
        row.createCell((short) 11).setCellValue(removeSpecialCharacters(kbart.getTitle_id()));
    } else {
        row.createCell((short) 11).setCellValue("");
    }
    if (kbart.getEmbargo_info() != null) {
        row.createCell((short) 12).setCellValue(removeSpecialCharacters(kbart.getEmbargo_info()));
    } else {
        row.createCell((short) 12).setCellValue("");
    }
    if (kbart.getCoverage_depth() != null) {
        row.createCell((short) 13).setCellValue(removeSpecialCharacters(kbart.getCoverage_depth()));
    } else {
        row.createCell((short) 13).setCellValue("");
    }
    if (kbart.getCoverage_notes() != null) {
        row.createCell((short) 14).setCellValue(removeSpecialCharacters(kbart.getCoverage_notes()));
    } else {
        row.createCell((short) 14).setCellValue("");
    }
    if (kbart.getPublisher_name() != null) {
        row.createCell((short) 15).setCellValue(removeSpecialCharacters(kbart.getPublisher_name()));
    } else {
        row.createCell((short) 15).setCellValue("");
    }

}