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    }