diff lib/CPT/Writer/Spreadsheet/XLS.pm @ 1:f093e08f21f3 draft default tip

planemo upload commit 94b0cd1fff0826c6db3e7dc0c91c0c5a8be8bb0c
author cpt
date Mon, 05 Jun 2023 02:47:24 +0000
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/lib/CPT/Writer/Spreadsheet/XLS.pm	Mon Jun 05 02:47:24 2023 +0000
@@ -0,0 +1,71 @@
+package CPT::Writer::Spreadsheet::XLS;
+use Moose;
+with 'CPT::Writer', 'CPT::Writer::Spreadsheet';
+use Spreadsheet::WriteExcel;
+
+sub process {
+	my ($self) = @_;
+	if ( $self->galaxy_override ) {
+		die 'This class currently incompatible with Galaxy';
+	}
+	$self->OutputFilesClass->extension( $self->suffix() );
+	my $next_output_file = $self->OutputFilesClass->get_next_file();
+	my $workbook         = Spreadsheet::WriteExcel->new($next_output_file);
+
+	my %data   = %{ $self->data };
+	my @sheets = keys %data;
+	foreach (@sheets) {
+		my $current_worksheet = $workbook->add_worksheet($_);
+		my $data_struc_ref    = $data{$_};
+
+		#R,C,AR
+		$current_worksheet->write_row( 0, 0,
+			${$data_struc_ref}{'header'} );
+		my $row = 1;
+		foreach ( @{ ${$data_struc_ref}{'data'} } ) {
+			$current_worksheet->write_row( $row, 0, $_ );
+			$row++;
+		}
+	}
+	$self->processed_data($workbook);
+	$self->processing_complete(1);
+}
+
+sub write {
+	my ($self) = @_;
+	$self->processed_data()->close();
+}
+
+sub suffix {
+	return 'xls';
+}
+no Moose;
+1;
+
+__END__
+
+=pod
+
+=encoding UTF-8
+
+=head1 NAME
+
+CPT::Writer::Spreadsheet::XLS
+
+=head1 VERSION
+
+version 1.99.4
+
+=head1 AUTHOR
+
+Eric Rasche <rasche.eric@yandex.ru>
+
+=head1 COPYRIGHT AND LICENSE
+
+This software is Copyright (c) 2014 by Eric Rasche.
+
+This is free software, licensed under:
+
+  The GNU General Public License, Version 3, June 2007
+
+=cut