simplexlsx.example2.php
960 Bytes
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
<?php
require_once __DIR__ . '/simplexlsx.class.php';
if ( $xlsx = SimpleXLSX::parse('countries_and_population.xlsx')) {
echo '<table cellpadding="10">
<tr><td valign="top">';
// output worsheet 1
list( $num_cols, $num_rows ) = $xlsx->dimension();
echo '<h1>Sheet 1</h1>';
echo '<table>';
foreach ( $xlsx->rows( 1 ) as $r ) {
echo '<tr>';
for ( $i = 0; $i < $num_cols; $i ++ ) {
echo '<td>' . ( ( ! empty( $r[ $i ] ) ) ? $r[ $i ] : ' ' ) . '</td>';
}
echo '</tr>';
}
echo '</table>';
echo '</td><td valign="top">';
// output worsheet 2
list( $num_cols, $num_rows ) = $xlsx->dimension( 2 );
echo '<h1>Sheet 2</h1>';
echo '<table>';
foreach ( $xlsx->rows( 2 ) as $r ) {
echo '<tr>';
for ( $i = 0; $i < $num_cols; $i ++ ) {
echo '<td>' . ( ( ! empty( $r[ $i ] ) ) ? $r[ $i ] : ' ' ) . '</td>';
}
echo '</tr>';
}
echo '</table>';
echo '</td></tr></table>';
} else {
echo SimpleXLSX::parse_error();
}
?>