Removing Worksheets Using Sheet Name in PHP

Removing Worksheets Using Sheet Name

Removing Worksheets Using Sheet Name

PHP Code

         $dataDir = '';

        // Create Aspose.Cells Helper Object
        $ptr = new \COM('Aspose.Cells.Interop.InteropHelper');

        // Opening through a path
        // Creating a Workbook object and opening an Excel file using its file path
        $workbook = $ptr->New("Aspose.Cells.Workbook", array($dataDir . '/book1.xls'));

        $worksheets = $ptr->Get($workbook, "Worksheets", array());

        $ptr->Call($worksheets, "RemoveAt_2", array("Sheet1"));

        $ptr->Call($workbook, "Save", array($dataDir . "/output.xls"));

        print "Completed." . PHP_EOL;

Download Sample Code

Download Removing Worksheets Using Sheet Name (Aspose.Cells) from any of the below‑mentioned social coding sites:

• GitHub