FM / examples

/var/www/vhosts/bsbdokum.com.tr/httpdocs/app/Addition/simplexlsx-master/examples/

/var/www/vhosts/bsbdokum.com.tr/httpdocs/app/Addition/simplexlsx-master/examples

Name	Size	Mode	Actions
01-basic_usage.php	294	0644	edit dl rm
02-rows_and_rowsEx.php	466	0644	edit dl rm
03-sheets.php	1165	0644	edit dl rm
04-upload_and_convert_to_html.php	899	0644	edit dl rm
books.xlsx	9186	0644	edit dl rm
countries_and_population.xlsx	19317	0644	edit dl rm

Edit: /var/www/vhosts/bsbdokum.com.tr/httpdocs/app/Addition/simplexlsx-master/examples/03-sheets.php (1165B)

<?php

ini_set('error_reporting', E_ALL);
ini_set('display_errors', true);

require_once __DIR__.'/../src/SimpleXLSX.php';

echo '<h1>Read several sheets</h1>';
if ( $xlsx = SimpleXLSX::parse('countries_and_population.xlsx')) {

echo '<pre>'.print_r( $xlsx->sheetNames(), true ).'</pre>';

echo '<table cellpadding="10">
	<tr><td valign="top">';

// output worsheet 1

list( $num_cols, $num_rows ) = $xlsx->dimension();

echo '<h2>'.$xlsx->sheetName(0).'</h2>';
	echo '<table border=1>';
	foreach ( $xlsx->rows( 1 ) as $r ) {
		echo '<tr>';
		for ( $i = 0; $i < $num_cols; $i ++ ) {
			echo '<td>' . ( ! empty( $r[ $i ] ) ? $r[ $i ] : '&nbsp;' ) . '</td>';
		}
		echo '</tr>';
	}
	echo '</table>';

echo '</td><td valign="top">';

// output worsheet 2

list( $num_cols, $num_rows ) = $xlsx->dimension( 2 );

echo '<h2>'.$xlsx->sheetName(1).'</h2>';
	echo '<table border=1>';
	foreach ( $xlsx->rows( 2 ) as $r ) {
		echo '<tr>';
		for ( $i = 0; $i < $num_cols; $i ++ ) {
			echo '<td>' . ( ! empty( $r[ $i ] ) ? $r[ $i ] : '&nbsp;' ) . '</td>';
		}
		echo '</tr>';
	}
	echo '</table>';

echo '</td></tr></table>';
} else {
	echo SimpleXLSX::parseError();
}

Read several sheets'; if ( $xlsx = SimpleXLSX::parse('countries_and_population.xlsx')) { echo '

'.print_r( $xlsx->sheetNames(), true ).'

'; echo '

'; // output worsheet 1 list( $num_cols, $num_rows ) = $xlsx->dimension(); echo '

'.$xlsx->sheetName(0).'

'; echo ''; foreach ( $xlsx->rows( 1 ) as $r ) { echo ''; for ( $i = 0; $i < $num_cols; $i ++ ) { echo ''; } echo ''; } echo '

' . ( ! empty( $r[ $i ] ) ? $r[ $i ] : ' ' ) . '

'; echo '

'; // output worsheet 2 list( $num_cols, $num_rows ) = $xlsx->dimension( 2 ); echo '

'.$xlsx->sheetName(1).'

'; echo ''; foreach ( $xlsx->rows( 2 ) as $r ) { echo ''; for ( $i = 0; $i < $num_cols; $i ++ ) { echo ''; } echo ''; } echo '

' . ( ! empty( $r[ $i ] ) ? $r[ $i ] : ' ' ) . '

'; echo '

'; } else { echo SimpleXLSX::parseError(); }