Exemplo n.º 1
0
echo "Total Sheets in this xls file: " . count($data->sheets) . "<br /><br />";
//print_r($data->boundsheets[0]['name']);die();
$html = "<table border='1'>";
for ($i = 0; $i < count($data->sheets); $i++) {
    if (isset($data->sheets[$i]['cells'])) {
        if (count($data->sheets[$i]['cells']) > 0) {
            if ($data->boundsheets[$i]['name'] == 'Keywords') {
                $Keywords = new Keywords();
                echo "Sheet Keywords:<br /><br />Total rows in sheet {$i}  " . count($data->sheets[$i]['cells']) . "<br />";
                for ($j = 1; $j <= count($data->sheets[$i]['cells']); $j++) {
                    $html .= "<tr>";
                    for ($k = 1; $k <= count($data->sheets[$i]['cells'][$j]); $k++) {
                        $html .= "<td>";
                        if (!empty($data->sheets[$i]['cells'][$j][$k])) {
                            $keyword = $data->sheets[$i]['cells'][$j][$k];
                            $result = $Keywords->importKeyword($keyword);
                        }
                        $html .= "<b>" . $data->sheets[$i]['cells'][$j][$k] . "</b> {$result}";
                        $html .= "</td>";
                    }
                    $html .= "</tr>";
                }
            } elseif ($data->boundsheets[$i]['name'] == 'Tags') {
                echo "Sheet Tags:<br /><br />Total rows in sheet {$i}  " . count($data->sheets[$i]['cells']) . "<br />";
                /*for($j=1;$j<=count($data->sheets[$i]['cells']);$j++) // loop used to get each row of the sheet
                		{
                			$html.="<tr>";
                		
                			for($k=1;$k<=count($data->sheets[$i]['cells'][$j]);$k++) // This loop is created to get data in a table format.
                		
                			{