From Code to Community: Sponsoring The Perl and Raku Conference 2025 Learn more

NKH / Spreadsheet-Perl-0.12 / Perl / Html.pm 

            

              
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
—
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112

              
package Spreadsheet::Perl ;
use 5.006 ;
use Carp ;
use strict ;
use warnings ;
require Exporter ;
our @ISA = qw(Exporter) ;
our %EXPORT_TAGS = 
        (
        'all' => [ qw() ]
        ) ;
our @EXPORT_OK = ( @{ $EXPORT_TAGS{'all'} } ) ;
our @EXPORT ;
push @EXPORT, qw( ) ;
our $VERSION = '0.01' ;
#-------------------------------------------------------------------------------
sub GenerateHtml
{
eval "use Data::Table ;" ;
confess "Data::Table is not installed" if($@) ;
my $ss = shift ;
my ($last_letter, $rows) = $ss->GetLastIndexes() ;
my $cols = FromAA($last_letter) ;
my $data = 
        [
        map
                {
                [
                map{''} (1 ..$cols + 1)
                ]
                } (1 .. $rows)
        ] ;
my $table1 = new Data::Table($data, [ map{$ss->Get("$_,0")} (0, 1 .. $cols)]) ;
for (1 .. $rows)
        {
        $table1->setElm($_ - 1, 0, $ss->Get("0,$_")) ;
        }
         
for ($ss->GetCellList())
        {
        my ($cellcol, $cellrow) =  ConvertAdressToNumeric($_) ;
         
        my $cell_info = '' ;
         
        if(exists $ss->{DEBUG}{INLINE_INFORMATION})
                {
                $cell_info = $ss->GetCellInfo($_) ;
                }
                 
        $table1->setElm ($cellrow - 1, $cellcol, $cell_info . $ss->Get($_)) ;
        }
return($table1->html()) ;
}
sub GenerateHtmlToFile
{
my $ss = shift ;
my $file_name = shift ;
open(HTML_FILE, '>', $file_name) or confess "Can't open '$file_name' for HTML dump" ;
print HTML_FILE $ss->GenerateHtml() ;
close HTML_FILE
}
#-------------------------------------------------------------------------------
1 ;
__END__
=head1 NAME
Spreadsheet::Perl::Html - HTML output for Spreadsheet::Perl
=head1 SYNOPSIS
  print $ss->GenerateHtml() ;
  $ss->GenerateHtmlToFile('file.html') ;
   
=head1 DESCRIPTION
Part of Spreadsheet::Perl.
=head1 AUTHOR
Khemir Nadim ibn Hamouda. <nadim@khemir.net>
  Copyright (c) 2004 Nadim Ibn Hamouda el Khemir. All rights
  reserved.  This program is free software; you can redis-
  tribute it and/or modify it under the same terms as Perl
  itself.
   
If you find any value in this module, mail me!  All hints, tips, flames and wishes
are welcome at <nadim@khemir.net>.
=cut