Data Analy Visualization

Visualization

Zoom InZoom Out
Tool
Diagram Types 2D Bar Charts:
   
2D Pie Charts
3D Bar Charts
3D Pie Charts
Light Option: Using light
Data Source
*Note, only integer values can be execute and display.

Please select an Excel file to uplaod*: '.'Please seleect any file to uplaod!'.''; exit(); } else{ $filename = move_uploaded_file($file_tmp_name,"Excel_Files/$file_name");//copy file into Folder"Excel_Files $excelReader = PHPExcel_IOFactory::createReaderForFile("Excel_Files/$file_name"); //read excel file using PHP library $sheetName=$_POST['sh']; //assign value from sh to $sheetName $loadSheets = array($sheetName); //save sheetName into an array $excelReader->setLoadSheetsOnly($loadSheets); //read only from the sheet in the array if($sheetName ==''){echo 'No data, please type sheet name before upload file'; } else{ $excelObj = $excelReader->load("Excel_Files/$file_name"); echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo "

$file_name , $sheetName"; echo '
'; echo '
'; foreach ($excelObj->getWorksheetIterator() as $worksheet){ $highestRow = $worksheet->getHighestRow(); $highestColumn = $worksheet->getHighestColumn(); $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); $nrColumns = ord($highestColumn) - 64; echo ''; for($row=1;$row<=1; $row++){ //echo ''; for($col=0;$col<$highestColumnIndex;$col++){ $cell = $worksheet->getCellByColumnAndRow($col); $val = $cell->getCalculatedValue(); echo ''; } //echo ''; } echo ''; for ($row = 2; $row <= $highestRow; $row++){ echo ''; for ($col = 0; $col < $highestColumnIndex;$col++){ $cell = $worksheet->getCellByColumnAndRow($col, $row); $val = $cell->getCalculatedValue(); echo ''; } echo ''; } echo ''; } echo '
' . $val. '
' . $val. '
'; echo '

Sort data by clicking on the repective column header!In cases where to content of a column refers to diffent dates, this column must conforn to "dd/mm/yyyy" formating!

'; } } } ?>