001 /* 002 * Copyright (C) 2008-2010 by Holger Arndt 003 * 004 * This file is part of the Universal Java Matrix Package (UJMP). 005 * See the NOTICE file distributed with this work for additional 006 * information regarding copyright ownership and licensing. 007 * 008 * UJMP is free software; you can redistribute it and/or modify 009 * it under the terms of the GNU Lesser General Public License as 010 * published by the Free Software Foundation; either version 2 011 * of the License, or (at your option) any later version. 012 * 013 * UJMP is distributed in the hope that it will be useful, 014 * but WITHOUT ANY WARRANTY; without even the implied warranty of 015 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 016 * GNU Lesser General Public License for more details. 017 * 018 * You should have received a copy of the GNU Lesser General Public 019 * License along with UJMP; if not, write to the 020 * Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, 021 * Boston, MA 02110-1301 USA 022 */ 023 024 package org.ujmp.jexcelapi; 025 026 import java.io.File; 027 import java.io.IOException; 028 import java.io.OutputStream; 029 030 import jxl.Workbook; 031 import jxl.biff.EmptyCell; 032 import jxl.write.Label; 033 import jxl.write.WritableCell; 034 import jxl.write.WritableSheet; 035 import jxl.write.WritableWorkbook; 036 import jxl.write.WriteException; 037 038 import org.ujmp.core.Matrix; 039 import org.ujmp.core.exceptions.MatrixException; 040 import org.ujmp.core.util.StringUtil; 041 042 public abstract class ExportMatrixXLS { 043 044 public static void toFile(File file, Matrix matrix, Object... parameters) 045 throws IOException, MatrixException { 046 try { 047 WritableWorkbook writableWorkbook = Workbook.createWorkbook(file); 048 WritableSheet sheet = writableWorkbook 049 .createSheet("First Sheet", 0); 050 for (long[] c : matrix.allCoordinates()) { 051 int row = (int) c[Matrix.ROW]; 052 int column = (int) c[Matrix.COLUMN]; 053 Object o = matrix.getAsObject(c); 054 WritableCell cell = null; 055 if (o == null) { 056 cell = new EmptyCell(column, row); 057 } else if (o instanceof Number) { 058 cell = new jxl.write.Number(column, row, ((Number) o) 059 .doubleValue()); 060 } else { 061 cell = new Label(column, row, StringUtil.convert(o)); 062 } 063 sheet.addCell(cell); 064 } 065 writableWorkbook.write(); 066 writableWorkbook.close(); 067 } catch (WriteException e) { 068 throw new MatrixException("could not save to file " + file, e); 069 } 070 } 071 072 public static void toStream(OutputStream outputStream, Matrix matrix, 073 Object... parameters) throws IOException, MatrixException { 074 try { 075 WritableWorkbook writableWorkbook = Workbook 076 .createWorkbook(outputStream); 077 WritableSheet sheet = writableWorkbook 078 .createSheet("First Sheet", 0); 079 for (long[] c : matrix.allCoordinates()) { 080 int row = (int) c[Matrix.ROW]; 081 int column = (int) c[Matrix.COLUMN]; 082 Object o = matrix.getAsObject(c); 083 WritableCell cell = null; 084 if (o == null) { 085 cell = new EmptyCell(column, row); 086 } else if (o instanceof Number) { 087 cell = new jxl.write.Number(column, row, ((Number) o) 088 .doubleValue()); 089 } else { 090 cell = new Label(column, row, StringUtil.convert(o)); 091 } 092 sheet.addCell(cell); 093 } 094 writableWorkbook.write(); 095 writableWorkbook.close(); 096 } catch (WriteException e) { 097 throw new MatrixException("could not save to stream", e); 098 } 099 } 100 101 }