Removing Worksheets Using Sheet Name in PHP
Contents
[
Hide
]
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 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 Running Code
Download Removing Worksheets Using Sheet Name (Aspose.Cells) from any of the below mentioned social coding sites: