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. {