01.function getDataFromExcel($file, $sheet, $rows, $cols)
02.{
03.
04. fwrite(STDOUT, "----------------------------------------\r\n");
05. $excel = new COM("Excel.application") or die ("ERROR: Unable to instantaniate COM!\r\n");
06. fwrite(STDOUT, "Application name: {$excel->Application->value}\r\n") ;
07. fwrite(STDOUT, "Loaded version: {$excel->Application->version}\r\n");
08. fwrite(STDOUT, "----------------------------------------\r\n\r\n");
09.
10.
11. $Workbook = $excel->Workbooks->Open($file) or die("ERROR: Unable to open " . $file . "!\r\n");
12. $Worksheet = $Workbook->Worksheets($sheet);
13. $Worksheet->Activate;
14. $i = 0;
15. foreach ($rows as $row)
16. {
17. $i++; $j = 0;
18. foreach ($cols as $col)
19. {
20. $j++;
21. $cell = $Worksheet->Range($col . $row);
22. $cell->activate();
23. $matrix[$i][$j] = $cell->value;
24. }
25. }
26.
27.
28. $Workbook->Close();
29. unset($Worksheet);
30. unset($Workbook);
31. $excel->Workbooks->Close();
32. $excel->Quit();
33. unset($excel);
34.
35. return $matrix;
36.}
