PHP で Excel

PHP Excel COM ADO

Excel のシート名を列挙する (ADO)

lesson007.php



<?php

    $cn = new COM("ADODB.Connection");

    $cn->Provider         = "Microsoft.Jet.OLEDB.4.0";

    $cn->ConnectionString = "Data Source=".$argv[1].";Extended Properties=Excel 8.0;";

    $cn->CursorLocation   = 3; # adUseClient

    $cn->Open;
    $rs = $cn->OpenSchema(20); # adSchemaTables

    while (!$rs->EOF)

    {

        echo $rs->Fields("TABLE_NAME")->Value, "\n";

        $rs->MoveNext;

    }

    $rs->Close;
    $cn->Close;

?>
実行結果


C:\>php c:\study\php\chapter004\lesson007.php c:\study\Book1.xls

Sheet1$

Sheet2$

Sheet3$