Please enter Aspose SID and Key on plugin settings page.
';
// return;
}
/*
* Assign Base Product URL
*/
Product::$baseProductUri = 'http://api.aspose.com/v1.1';
AsposeApp::$appSID = $ape_sid;
AsposeApp::$appKey = $ape_key;
$sheet_name = 'Sheet1';
$excel_file = $filename;
$ext = pathinfo($excel_file, PATHINFO_EXTENSION);
if($ext == 'xls' || $ext == 'xlsx') {
$func = new Worksheet($excel_file,$sheet_name);
$rows = $func->getRowsCount(1,10000);
$cols = $func->getMaxColumn(0,10000);
$html_string = '';
for($row = 1; $row <= $rows; $row++){
$html_string .= '';
for($col = 0; $col <= $cols; $col++){
$cell = generateAlphabet($col) . $row;
$cell_value = $func->getcell($cell);
$cell_value = $cell_value->Value;
if($row == '1') {
$html_string .= '| ' . $cell_value . ' | ';
} else {
$html_string .= '' . $cell_value . ' | ';
}
}
$html_string .= '
';
}
$html_string .= '
';
echo $html_string;
//echo ""; print_r($rows); exit;
} else {
echo "Wrong File was selected!";
}