Maison > php教程 > php手册 > 利用PhpExcel读取Excel中文件

利用PhpExcel读取Excel中文件

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Libérer: 2016-06-06 20:08:06
original
1403 Les gens l'ont consulté

?phpini_set("display_errors",1);ini_set('include_path', ini_get('include_path').';F://sources//PHPExcel_1.7.8-with_documentation-msoffice_format//Classes//');//设置此页面包含路径include 'PHPExcel.php';include 'PHPExcel/IOFactory.php';defin

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

<?php ini_set("display_errors",1);

ini_set('include_path', ini_get('include_path').';F://sources//PHPExcel_1.7.8-with_documentation-msoffice_format//Classes//');//设置此页面包含路径

include 'PHPExcel.php';

include 'PHPExcel/IOFactory.php';

define('EXCEL_EXTENSION_2003', "xls");

define('EXCEL_EXTENSION_2007', "xlsx");

$fileName2003 = "f://Standard_Format_File1.xls";

$fileName2007 = "f://Standard_Format_File1.xlsx";

$fileName = $fileName2003;

//$fileName = $fileName2007;

if(getExtendFileName($fileName) == EXCEL_EXTENSION_2003)

{

    $reader = PHPExcel_IOFactory::createReader('Excel5');

}

else if(getExtendFileName($fileName) == EXCEL_EXTENSION_2007)

{

    $reader = new PHPExcel_Reader_Excel2007();

}

$PHPExcel = $reader->load($fileName);

$worksheet = $PHPExcel->getActiveSheet();

$imageInfo = extractImageFromWorksheet($worksheet,"f://");

print_r($imageInfo);

function getExtendFileName($file_name) {

    $extend = pathinfo($file_name);

    $extend = strtolower($extend["extension"]);

    return $extend;

}

function extractImageFromWorksheet($worksheet,$basePath){

    $result = array();

    $imageFileName = "";

    foreach ($worksheet->getDrawingCollection() as $drawing) {

        $xy=$drawing->getCoordinates();

        $path = $basePath;

        // for xlsx

        if ($drawing instanceof PHPExcel_Worksheet_Drawing) {

            $filename = $drawing->getPath();

            $imageFileName = $drawing->getIndexedFilename();

            $path = $path . $drawing->getIndexedFilename();

            copy($filename, $path);

            $result[$xy] = $path;

            // for xls

        } else if ($drawing instanceof PHPExcel_Worksheet_MemoryDrawing) {

            $image = $drawing->getImageResource();

            $renderingFunction = $drawing->getRenderingFunction();

            switch ($renderingFunction) {

                case PHPExcel_Worksheet_MemoryDrawing::RENDERING_JPEG:

                    $imageFileName = $drawing->getIndexedFilename();

                    $path = $path . $drawing->getIndexedFilename();

                    imagejpeg($image, $path);

                    break;

                case PHPExcel_Worksheet_MemoryDrawing::RENDERING_GIF:

                    $imageFileName = $drawing->getIndexedFilename();

                    $path = $path . $drawing->getIndexedFilename();

                    imagegif($image, $path);

                    break;

                case PHPExcel_Worksheet_MemoryDrawing::RENDERING_PNG:

                    $imageFileName = $drawing->getIndexedFilename();

                    $path = $path . $drawing->getIndexedFilename();

                    imagegif($image, $path);

                    break;

                case PHPExcel_Worksheet_MemoryDrawing::RENDERING_DEFAULT:

                    $imageFileName = $drawing->getIndexedFilename();

                    $path = $path . $drawing->getIndexedFilename();

                    imagegif($image, $path);

                    break;

            }

            $result[$xy] = $imageFileName;

        }

    }

    return $result;

}

Copier après la connexion
Étiquettes associées:
Déclaration de ce site Web
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn
Derniers numéros
Recommandations populaires
Tutoriels populaires
Plus>
Derniers téléchargements
Plus>
effets Web
Code source du site Web
Matériel du site Web
Modèle frontal