001/**
002 *
003 * Copyright (c) 2014, the Railo Company Ltd. All rights reserved.
004 *
005 * This library is free software; you can redistribute it and/or
006 * modify it under the terms of the GNU Lesser General Public
007 * License as published by the Free Software Foundation; either 
008 * version 2.1 of the License, or (at your option) any later version.
009 * 
010 * This library is distributed in the hope that it will be useful,
011 * but WITHOUT ANY WARRANTY; without even the implied warranty of
012 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
013 * Lesser General Public License for more details.
014 * 
015 * You should have received a copy of the GNU Lesser General Public 
016 * License along with this library.  If not, see <http://www.gnu.org/licenses/>.
017 * 
018 **/
019package lucee.runtime.poi;
020
021import lucee.runtime.exp.CasterException;
022
023public class ExcelUtil {
024
025        public static short format(String strFormat, short defaultValue){
026                strFormat=strFormat.trim().toUpperCase();
027                if("XSSF".equals(strFormat)) return Excel.FORMAT_XSSF;
028                if("HSSF".equals(strFormat)) return Excel.FORMAT_HSSF;
029                return defaultValue;
030        }
031        
032        public static String format(short format, String defaultValue){
033                if(Excel.FORMAT_XSSF==format) return "XSSF";
034                if(Excel.FORMAT_HSSF==format) return "HSSF";
035                return defaultValue;
036        }
037
038        public static Excel toExcel(Object obj,Excel defaultValue) {
039                if(obj instanceof Excel) return (Excel) obj;
040                return defaultValue;
041        }
042
043        public static Excel toExcel(Object obj) throws CasterException {
044                if(obj instanceof Excel) return (Excel) obj;
045                throw new CasterException(obj,"Excel");
046        }
047}