13 unshift @a, ($n-1) % 26;
14 $n = int(($n-1)/26); #Edited for failing corner case
16 join '', map chr(ord('A') + $_), @a;
27 <div class="panel panel-info">
28 <div class="panel-heading">
31 <div class="panel-body">
37 <th>Number of Sheets</th>
43 <td><% $filename %></td>
44 <td><% @$file_content[0]->[0]->{type} %></td>
45 <td><% @$file_content[0]->[0]->{sheets} %></td>
46 <td><% @$file_content[0]->[0]->{parser} %> (<% @$file_content[0]->[0]->{version} %>)</td>
53 % my $num_sheets = @$file_content[0]->[0]->{sheets};
55 <div class="panel panel-info">
56 <div class="panel-heading">
57 <h3>File Contents</h3>
59 <div class="panel-body">
61 <ul class="nav nav-tabs" role="tablist">
63 % for ( my $s=1; $s<=$num_sheets; $s++) {
65 % my $sheet_label = @$file_content[0]->[$s]->{label};
66 % $sheet_label =~ s/\s+//g;
69 <li role="presentation" class="active"><a href="#<% $sheet_label %>" aria-controls="<% $sheet_label %>" role="tab" data-toggle="tab"><% $sheet_label %></a></li>
71 <li role="presentation"><a href="#<% $sheet_label %>" aria-controls="<% $sheet_label %>" role="tab" data-toggle="tab"><% $sheet_label %></a></li>
78 <div class="tab-content">
80 % for (my $i=1; $i<=$num_sheets; $i++) {
82 % my $max_row = @$file_content[0]->[$i]->{maxrow};
83 % my $max_col = @$file_content[0]->[$i]->{maxcol};
85 % my $sheet_label = @$file_content[0]->[$i]->{label};
86 % $sheet_label =~ s/\s+//g;
89 <div role="tabpanel" class="tab-pane fade in active" id="<% $sheet_label %>">
91 <div role="tabpanel" class="tab-pane fade" id="<% $sheet_label %>">
94 <table class="table table-hover table-bordered">
98 % my $max_aa = n2a(@$file_content[0]->[$i]->{maxcol});
99 % foreach ('A'..$max_aa) {
100 <th><% @$file_content[0]->[$i]->{$_.'1'} %></th>
106 % for (my $j=2; $j<=$max_row; $j++) {
110 % foreach ('A'..$max_aa) {
112 <td><% @$file_content[0]->[$i]->{$_.$j} %></td>