biz.deinum.jxl.util.JxlUtils.java Source code

Introduction

Here is the source code for biz.deinum.jxl.util.JxlUtils.java

Source

/*
 * Copyright 2007-2011 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package biz.deinum.jxl.util;

import java.util.ArrayList;
import java.util.List;

import jxl.Cell;
import jxl.Workbook;

import org.springframework.util.StringUtils;

/**
 * Class containing utility methods to work with JXL.
 *
 * @author Marten Deinum
 *
 */
public final class JxlUtils {

    /** Private constructor to prevent easy instantiation. */
    private JxlUtils() {
    }

    /**
     * Checks if the given cell is emtpy. The cell is empty if it contains no characters, it will trim spaces.
        
     * @param cell to check
     * @return true/false
     * @see StringUtils#hasText(String)
     */
    public static boolean isEmpty(final Cell cell) {
        return cell == null || !StringUtils.hasText(cell.getContents());
    }

    /**
     * Check if the given row (Cell[]) is empty. It is considered empty when the row is null, the array is empty or all the cells in the row are empty.
     * @param row to check
     * @return true/false
     */
    public static boolean isEmpty(final Cell[] row) {
        if (row == null || row.length == 0) {
            return true;
        }
        for (final Cell cell : row) {
            if (!isEmpty(cell)) {
                return false;
            }
        }
        return true;
    }

    /**
     * Check if the given workbook has any sheets.
     * 
     * @param workbook to check
     * @return true/false
     */
    public static boolean hasSheets(final Workbook workbook) {
        return workbook != null && workbook.getNumberOfSheets() > 0;
    }

    /**
     * Extract the content from the given row. 
     * 
     * @param row the row
     * @return the content as String[]
     */
    public static String[] extractContents(final Cell[] row) {
        final List<String> values = new ArrayList<String>();
        for (final Cell cell : row) {
            if (!isEmpty(cell)) {
                values.add(cell.getColumn(), cell.getContents());
            }
        }
        return values.toArray(new String[values.size()]);
    }
}