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}