source: main/trunk/greenstone2/perllib/plugins/ExcelPlugin.pm@ 22597

###########################################################################
#
# ExcelPlugin.pm -- plugin for importing Microsoft Excel files.
#  (currently only versions 95 and 97)
#
# A component of the Greenstone digital library software
# from the New Zealand Digital Library Project at the 
# University of Waikato, New Zealand.
#
# Copyright (C) 2002 New Zealand Digital Library Project
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
#
###########################################################################

package ExcelPlugin;

use ConvertBinaryFile;
use strict;
no strict 'refs'; # allow filehandles to be variables and viceversa
no strict 'subs';
use gsprintf 'gsprintf';

# @ISA dynamically configured to be either OpenOfficeConverter or ConvertBinaryFile

# do not initialise these variables
my $openoffice_ext_installed;
my $openoffice_ext_working;
sub BEGIN {
    eval("require OpenOfficeConverter");
    if ($@) {
    # Useful debugging statement if there is a syntax error in OpenOfficeConverter  
    #print STDERR "$@\n";
    @ExcelPlugin::ISA = ('ConvertBinaryFile');
    $openoffice_ext_installed = 0;
    $openoffice_ext_working = 0;
    }
    else {
    # Successfully found
    $openoffice_ext_installed = 1;
    # now check whether it can run soffice
    if ($OpenOfficeConverter::openoffice_conversion_available) {
        @ExcelPlugin::ISA = ('OpenOfficeConverter');
        $openoffice_ext_working = 1;
        
    } else {
        @ExcelPlugin::ISA = ('ConvertBinaryFile');
        $openoffice_ext_working = 0;
    }
    }
}

my $arguments = 
    [ { 'name' => "process_exp",
    'desc' => "{BasePlugin.process_exp}",
    'type' => "regexp",
    'reqd' => "no",
    'deft' => &get_default_process_exp() }
      ];

my $opt_openoffice_args = 
    [ { 'name' => "openoffice_scripting",
    'desc' => "{OpenOfficeConverter.openoffice_scripting}",
    'type' => "flag",
    'reqd' => "no" } ];


my $options = { 'name'     => "ExcelPlugin",
        'desc'     => "{ExcelPlugin.desc}",
        'abstract' => "no",
        'inherits' => "yes",
        'srcreplaceable' => "yes", # Source docs in Excel format can be replaced with GS-generated html
        'args'     => $arguments };

sub new {
    my ($class) = shift (@_);
    my ($pluginlist,$inputargs,$hashArgOptLists) = @_;
    push(@$pluginlist, $class);
    
    if ($openoffice_ext_installed) {
    print STDERR "ExcelPlugin: OpenOffice Extension to Greenstone detected\n";
    if ($openoffice_ext_working) {
        print STDERR "... and it appears to be working\n";
    } else {
        print STDERR "... but it appears to be broken\n";
        &gsprintf(STDERR, "OpenOfficeConverter: {OpenOfficeConverter.noconversionavailable} ({OpenOfficeConverter.$OpenOfficeConverter::no_openoffice_conversion_reason})\n");
    }
    }

    if ($openoffice_ext_working) {
    push(@$arguments,@$opt_openoffice_args);
    }    

    push(@{$hashArgOptLists->{"ArgList"}},@{$arguments});
    push(@{$hashArgOptLists->{"OptList"}},$options);

    my $self = {};

    if ($openoffice_ext_working) {
    $self = new OpenOfficeConverter($pluginlist, $inputargs, $hashArgOptLists);
    }
    else {
    $self = new ConvertBinaryFile($pluginlist, $inputargs, $hashArgOptLists);
    }

    if ($self->{'info_only'}) {
    # don't worry about any options etc
    return bless $self, $class;
    }

    $self->{'filename_extension'} = "xls";
    $self->{'file_type'} = "Excel";

    my $outhandle = $self->{'outhandle'};

    # check convert_to
    if ($self->{'convert_to'} eq "auto") {
    $self->{'convert_to'} = "html";
    }

    $self->{'convert_options'} = "-openoffice_scripting" if $self->{'openoffice_scripting'};

    # set convert_to_plugin and convert_to_ext
    $self->ConvertBinaryFile::set_standard_convert_settings();
    print STDERR "final convert-to $self->{'convert_to'}\n";

    my $secondary_plugin_name = $self->{'convert_to_plugin'};
    my $secondary_plugin_options = $self->{'secondary_plugin_options'};

    if (!defined $secondary_plugin_options->{$secondary_plugin_name}) {
    $secondary_plugin_options->{$secondary_plugin_name} = [];
    }
    my $specific_options = $secondary_plugin_options->{$secondary_plugin_name};

    push(@$specific_options,"-extract_language") if $self->{'extract_language'};
    push(@$specific_options, "-file_rename_method", "none");

    if ($secondary_plugin_name eq "HTMLPlugin") {
    push(@$specific_options, "-processing_tmp_files");
    }

    $self = bless $self, $class;
    
    $self->load_secondary_plugins($class,$secondary_plugin_options,$hashArgOptLists);
    return bless $self;    
}

sub convert_post_process_old
{
    my $self = shift (@_);
    my ($conv_filename) = @_;
    
    my $outhandle=$self->{'outhandle'};
    
    my ($language, $encoding) = $self->textcat_get_language_encoding ($conv_filename);
    
    # read in file ($text will be in utf8)
    my $text = "";
    $self->read_file ($conv_filename, $encoding, $language, \$text);
    
    # turn any high bytes that aren't valid utf-8 into utf-8.
    #unicode::ensure_utf8(\$text);
    
    # Write it out again!
    #$self->utf8_write_file (\$text, $conv_filename);
}

sub get_default_process_exp {
    my $self = shift (@_);
    return q^(?i)\.xls$^;
}
    

1;