1 ////////////////////////////////////////////////////////////////////////////////
2 // MillScript-Excel: an Open Spice interpreter and batch website creation tool
3 // Copyright (C) 2006 Open World Ltd, Kevin Rogers
4 //
5 // This file is part of MillScript-Excel.
6 //
7 // MillScript-Excel is free software; you can redistribute it and/or modify it under
8 // the terms of the GNU General Public License as published by the Free
9 // Software Foundation; either version 2 of the License, or (at your option)
10 // any later version.
11 //
12 // MillScript-Excel is distributed in the hope that it will be useful, but WITHOUT
13 // ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
14 // FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
15 // more details.
16 //
17 // You should have received a copy of the GNU General Public License along with
18 // MillScript-Excel; if not, write to the Free Software Foundation, Inc., 59 Temple
19 // Place, Suite 330, Boston, MA 02111-1307 USA
20 ////////////////////////////////////////////////////////////////////////////////
21 package org.millscript.office.excel;
22
23 import org.millscript.commons.vfs.VFile;
24 import org.millscript.commons.vfs.protocols.file.LocalFile;
25 import org.millscript.office.alerts.OfficeIOAlert;
26 import org.millscript.office.compound.vfs.CompoundDocumentVolume;
27 import org.millscript.office.spreadsheet.Workbook;
28
29 import java.io.InputStream;
30
31 /**
32 *
33 */
34 public class ExcelLoader {
35
36 public static final Workbook getWorkbook( final InputStream is ) {
37 // Get the record tokenizer
38 final RecordTokenizer tokenizer = RecordTokenizer.getRecordTokenizer( is );
39 // Now make the appropriate parser and read the workbook
40 return tokenizer.getRecordParser().readWorkbook();
41 }
42
43 public static final Workbook getWorkbook( final CompoundDocumentVolume vol ) {
44 // An OLE2 file could be Excel 5+, that's BIFF5 or later
45 // BIFF8+ has a stream called "Workbook", BIFF5/7 "Book"
46 // BIFF8+ files can contain both streams for compatibility
47 VFile workbook = vol.getRootVFolder().getVFile( "Workbook" );
48 if ( ! workbook.exists() ) {
49 // The "Workbook" stream isn't there, so try for the "Book" stream
50 workbook = vol.getRootVFolder().getVFile( "Book" );
51 }
52 if ( workbook.exists() ) {
53 return getWorkbook( workbook.getInputStream() );
54 } else {
55 throw new OfficeIOAlert(
56 "Specified file is not an Excel 5.0 or later document"
57 ).decorate( vol ).mishap();
58 }
59 }
60
61 public static final Workbook getWorkbook( final LocalFile file ) {
62 return getWorkbook( new CompoundDocumentVolume( file ) );
63 }
64
65 }